Using Avri's cell location and with B1 & C1 formatted as percentage

=FLOOR(MAX(0,C1-B1),0.001)*1000*75+IF(C1B1,A1,0)

returns 4375

have assumed that you want a zero bonus if this year's money is less than
last year's

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"phat al" wrote in
message ...

Ok so lets see if I get this in my head right ..
D1=A1+INT(MAX(0,C1-B1+0.0999)*10)*75

The total showing from that sum is 476.0000 ? I don't think that's
right

37.18 - 31.82 = 5.36 , the sum im looking for starts @ $400 and in
increments of ten I add $75 to each one.

0.00% $400
0.10% $475
0.20% $550
and then we jump too where i think we should be
5.20% 4300
5.30% 4375
5.40% 4450

I think the total im looking for is this 5.30% which is 4,375.00, if I
start with a base of $400 and add $75 every 10%?
Am I correct? Or have I made a mistake calculating.
What can I do to that sum to make it work?

Thank you so far for your help it is appreciated


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