Help with functions

[terry_d]

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

 

[Dana DeLouis]

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

 

[terry_d]

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

 

[Guest]

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

=IF(F35<=50,20,IF(F35>50,IF(F35>200,F35*0.15,30),"not >50 or <=50"))

 

[terry_d]

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

 

[Pete_UK]

Try this:

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

Hope this helps.

Pete

 

[terry_d]

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

 

[Pete_UK]

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

 

[terry_d]

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

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

Thanks SO much for your help!

Terr

 

[Pete_UK]

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

 

[terry_d]

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