=IF(F35=0,0,IF(F35<=50,20,MAX(30,F35*0.15)))

What I'm trying to do here is get a total of $20, if miles are 1 to 50,
$30, if the miles are 50 to 200. If the miles are 200, or more, the
amount needs to be multiplied by $0.15.

The formula works very well, but generating errors...


--
terry_d
------------------------------------------------------------------------
terry_d's Profile: http://www.excelforum.com/member.php...o&userid=32678
View this thread: http://www.excelforum.com/showthread...hreadid=527604