Hi

A1=$400
B1=31.82%
C1=37.18%
D1=A1+INT(MAX(0,C1-B1+0.0999)*10)*75


Arvi Laanemets


"phat al" wrote in
message ...

I need to make a sheet that give totals based on monthly figures from
last year.
Then based on difference between the 2 it will show no increase and no
bonus, or it will show an increase and bonus based on increments $75.
to help I will make one that needs work.

One month Last year the store made 31.82% on it's money.
The bonus for anything over is $75 per 10% increments.
Ie
0.00% $400
0.10% $475
0.20% $550
0.30% $625
0.40% $700
So this month was over last months, 37.18% so the bonus was $3,975.

What formula do I use to make this calculation shown under % is nothing
but anything over adds up to a relation with $75. added to a base of
$400 every 10%.
This hurt my head trying to get it right and im new to this more
complicated formulas.

Please in advance to anyone who has time to help Thank you


--
phat al
------------------------------------------------------------------------
phat al's Profile:
http://www.excelforum.com/member.php...o&userid=34988
View this thread: http://www.excelforum.com/showthread...hreadid=548169