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=548164

Try this

=IF(A1=0,400+(A1*75000),0)

assuming that the % figure is in column A and the formula is placed in
B1.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=548164