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

One Option:
=IF(F35<=50,20,MAX(30,F35*0.15))

--
HTH. :)
Dana DeLouis
Windows XP, Office 2003

"terry_d" wrote in
message ...

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

Thanks Dana for your response, the formula works great, however, if
there there is no amount in F35, the response is still 20, I need it to
be zero...


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

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

This function is working well, but I need to get a result of zero if F35
has no entry.


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

Try this:

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

Hope this helps.

Pete

Now I'm getting errors. It doesn't seem to want to allow me to save the
function in the format it is in, or the version I'm using. I'm running
on Office 2002 Pro...


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

I don't understand what you mean. Does Excel say that there is an error
in the formula? If so, are you sure you have typed it in correctly? The
formula should work on all versions of Excel.

Pete