Please advise why the following formula returns the FALSE word, even
when the entered amount (D8 equal to 650000) meets one of the
arguments:

=SI(D8<450000,(D8*0.7%),SI(D8=450000<600000,(D8*0 .65%),SI(D8=600000<750000,(D8*0.6%),SI(D8=750000 <900000,(D8*0.55%),SI(D8900000,(D8*0.5%))))))

I have tried everything, please help


--
cin
------------------------------------------------------------------------
cin's Profile: http://www.excelforum.com/member.php...o&userid=27088
View this thread: http://www.excelforum.com/showthread...hreadid=466040