Excel

The UK's most regular instructor-led training courses.
Training information: excel microsoft training · Excel advanced · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

Excel

ian has attended:
Excel Intermediate course

by - delegate ian [1 post] (2008 May 28 Wed, 16:49) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2009 Jan 22 Thu + 23 Fri	Southwark	0	FULL
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	4	book now	£475	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	5	book now	£485	£490
2003	2009 Feb 19 Thu + 20 Fri	Southwark	4	book now	£475	£485
2003	2009 Feb 26 Thu + 27 Fri	Bayswater	8	book now	£335	£365
2003	2009 Mar 12 Thu + 13 Fri	Bloomsbury	7	book now	£345	£399
Full Schedule: See all 43 Excel VBA course dates. Bookings currently available until 18th March 2010.

RE: Excel

by - trainer Amanda diamond contributer [1298 posts] (2008 May 30 Fri, 17:24) Reply

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

· Microsoft Excel Courses Teach Advanced Macro Techniques
· Why Excel Training (Sometimes) Doesn't Work and What You Can Do About It
· Reporting and Analysis with Excel
· Identifying Suitable Candidates For VBA For Excel Training
· Microsoft Excel Training - Numerical excellence for all

Please browse our web site to find out more about
excel microsoft training and other Microsoft training courses.