Hi

I'm somewhat confused - are increments 10%, or 0.1% ???

I understood, that when 37.18% - 31.82% = 5.36% , then it falls into
interval between 0%-10%, which makes the bonus $75. And the formula returns
$475


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"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