This may not be the most elegant, but it works.

=IF(F35<=50,20,IF(F3550,IF(F35200,F35*0.15,30)," not 50 or <=50"))


"terry_d" wrote:


I am trying to set up a functions such as: If F35=<50, then $20.00, If
F3550, then $30.00, If F35200, F35*0.15. Hope someone can help with
this one...Thanks!


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