Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Resolved · Low Priority · Version 2003
ian has attended:
Excel Intermediate course
I have the following 4 cells;
Was:
Then:
Save:
Now:
'Was' and 'Save' will always be completed, 'Then' may not.
What is the best way to SUM the 'Now:' price based on 'Was'/'Then'/'Save'?
Hi Ian
Thank you for your question; and welcome to the forum.
Can I assume that the Now price is the Was price minus the Save amount? Can you clarify?
Thank you in advance
Amanda
|
Excel tip:Turn Function tooltips on and offExcel 2002 (XP) and Excel 2003 have the Function tooltips facility. When you type in a function name followed by a bracket, for example, =IF(, a yellow box appears beside the function name and lists the function's arguments. This is very useful when you can't quite remember the order of a function's arguments or what the arguments actually are! |
We'll call during UK business hours
Server loaded in 0.08 secs.