2002 excel microsoft training - If Statement - Excel

Resolved · Low Priority · Version Standard

Mon 24 Sep 2007, 15:35 Delegate Dan said...

Dan has attended:
No courses

If Statement - Excel

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

Tue 25 Sep 2007, 10:44 Delegate Paul said...

RE: If Statement - Excel

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

Excel tip:

Multiple Lines of Text in a Cell

As an alternative to the Text Wrapping facility, type a word or two, press Alt+Enter to get a new line, type more text, and continue the process for as many lines as you need. Enter as normal when you have finished.

The line break is not affected by changing the column width, as text wrapping. To remove this you must edit the cell and remove the invisible character and replace with a normal space.

View all Excel hints and tips

2002 excel microsoft training - If Statement - Excel

If Statement - Excel

RE: If Statement - Excel

Excel articles

Excel tip:

Multiple Lines of Text in a Cell