2002 excel microsoft training - If Statement

2002 excel microsoft training - If Statement - Excel

Resolved · Low Priority · Version Standard

If Statement - Excel

Dan has attended:
No courses

by - delegate Dan [3 posts] (2007 Sep 24 Mon, 15:35) Reply

Hi All

Im currently working on a spreadsheet whereby i need to know if Cell BK10 is between 2500-3499 the figure that it is above 2500 by needs to be multiplied by 0.45 BUT at the same time i need to incorporate into the formula that if it is also above 3500 and by how much then that figure needs to be multiplied by 0.60

So if the figure is 3800
then 999 needs to be multiplied by 0.45

and

300 needs to be multipled by 0.60

Then both of the figures need to be added together.

Please can you help me put together the correct formula so that this can be worked out

Than you

Dan

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 3 Wed	Bloomsbury	0	FULL
2003	2008 Dec 5 Fri	Bayswater	1	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
2007	2008 Dec 10 Wed	Bloomsbury	2	book now	£240	£245
2003	2008 Dec 12 Fri	Southwark	6	book now	£214	£230
Full Schedule: See all 96 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: If Statement - Excel

by - delegate Paul gold contributer [121 posts] (2007 Sep 25 Tue, 10:44) Reply

Hi Dan,

Try this (untested)

=IF(AND(BK10>2500,BK10<3500),(BK10-2500)*0.45,IF(BK10>=3500,(BK10-3499)*0.6,""))

it will probably need a bit of tinkering with the figures but that'll probably work..

Hope this helps

Paul