Excel

Resolved · Low Priority · Version 2003

Wed 28 May 2008, 16:49 Delegate ian said...

ian has attended:
Excel Intermediate course

Excel

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'?

Fri 30 May 2008, 17:24 Trainer Amanda said...

RE: Excel

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 off

Excel 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!

However, Function tooltips can become annoying. To turn them off, choose Tools|Options. and select the General tab. Then, untick the Function tooltips box and choose OK.

View all Excel hints and tips

Excel

Excel

RE: Excel

Excel articles

Excel tip:

Turn Function tooltips on and off