Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

ResolvedVersion 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:

Trace Dependents / Precedents without the blue arrows

Rather than using the toolbar you can press CTRL+] which is the equivelent of trace dependants and CTRL+[ for precendants. Both of these ways though will not show the blue arrows but jump to the cell containing the formula.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Excel

Excel

RE: Excel

Excel articles

Excel tip:

Trace Dependents / Precedents without the blue arrows