formula I can't figure it out?! ARGH
 

I am trying to make the following formula work and am going nuts trying to
make it work - I even called Microsoft and they couldn't do it either? Here
is what I am trying to do.

I want say cell A1 (this will be the variable)

from 0 to 100,000 multiply by 6%
from 100,000 to 125,0000 multiply by 9%
from 125,000 to 150,0000 multilpy by 12%
from 150,000 and up multiply by 13%

so if A1 was 175,000, the first 100,000 is at 6% (6,000)
the next 25,000 is at 9% (2,250)
the next 25,000 is at 12% (3,000)
the next 25,000 is at 13% (3,250)
the total would be $14,500.

This is a bonus calculation so A1 is the revenue that bonus is calculated.

Does anyone have any ideas!

I would be forever grateful!

Thanks

Jewels

formula I can't figure it out?! ARGH
 

Take a look he

http://www.mcgimpsey.com/excel/variablerate.html

In article ,
jewels wrote:

I am trying to make the following formula work and am going nuts trying to
make it work - I even called Microsoft and they couldn't do it either? Here
is what I am trying to do.

I want say cell A1 (this will be the variable)

from 0 to 100,000 multiply by 6%
from 100,000 to 125,0000 multiply by 9%
from 125,000 to 150,0000 multilpy by 12%
from 150,000 and up multiply by 13%

so if A1 was 175,000, the first 100,000 is at 6% (6,000)
the next 25,000 is at 9% (2,250)
the next 25,000 is at 12% (3,000)
the next 25,000 is at 13% (3,250)
the total would be $14,500.

This is a bonus calculation so A1 is the revenue that bonus is calculated.

Does anyone have any ideas!

I would be forever grateful!

Thanks

Jewels

formula I can't figure it out?! ARGH
 

=MAX(6%*A1,9%*A1-3000,12%*A1-6750,13%*A1-8250)

HTH. :)

--
Dana DeLouis
Win XP & Office 2003


"jewels" wrote in message
...
I am trying to make the following formula work and am going nuts trying to
make it work - I even called Microsoft and they couldn't do it either?
Here
is what I am trying to do.

I want say cell A1 (this will be the variable)

from 0 to 100,000 multiply by 6%
from 100,000 to 125,0000 multiply by 9%
from 125,000 to 150,0000 multilpy by 12%
from 150,000 and up multiply by 13%

so if A1 was 175,000, the first 100,000 is at 6% (6,000)
the next 25,000 is at 9% (2,250)
the next 25,000 is at 12% (3,000)
the next 25,000 is at 13% (3,250)
the total would be $14,500.

This is a bonus calculation so A1 is the revenue that bonus is calculated.

Does anyone have any ideas!

I would be forever grateful!

Thanks

Jewels

formula I can't figure it out?! ARGH
 

Hi Dana

Very neat!!

Regards

Roger Govier


Dana DeLouis wrote:
=MAX(6%*A1,9%*A1-3000,12%*A1-6750,13%*A1-8250)

HTH. :)

formula I can't figure it out?! ARGH
 

THANK YOU THANK YOU THANK YOU

"jewels" wrote:

I am trying to make the following formula work and am going nuts trying to
make it work - I even called Microsoft and they couldn't do it either? Here
is what I am trying to do.

I want say cell A1 (this will be the variable)

from 0 to 100,000 multiply by 6%
from 100,000 to 125,0000 multiply by 9%
from 125,000 to 150,0000 multilpy by 12%
from 150,000 and up multiply by 13%

so if A1 was 175,000, the first 100,000 is at 6% (6,000)
the next 25,000 is at 9% (2,250)
the next 25,000 is at 12% (3,000)
the next 25,000 is at 13% (3,250)
the total would be $14,500.

This is a bonus calculation so A1 is the revenue that bonus is calculated.

Does anyone have any ideas!

I would be forever grateful!

Thanks

Jewels