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

The error states; A formula in a cell (worksheet) could not me
converted because it contains a function that is not available in the
file format to which you are saving. If you continue the save, the
formula and result will be saved, but the function itself will be
converted to an error value.

It seems to be a setting within excel. The specific worksheet has
numberous functions and formulas in it. I actually copied the function
you had put out there for me. It works absolutely great. These errors
are just very annoying.

Thanks SO much for your help!

Terry


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

Are you trying to save the file as a different type than .xls (such as
..csv)? If so, then Excel is warning you that the new file type cannot
support formulae and so it will put the value of each formula in the
cell. Just make sure when you go to File | Save As that you select
Excel Workbook as the file type in the pull-down of the bottom panel.

Hope this helps.

Pete

This is being saved as an .xls file. I'm still getting errors...The
function is working beautifully though.


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