Errors using a new function

[terry_d]

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

After placing this function in a working worksheet. I'm now getting
errors. The function is working properly. It's just that every time I
do a save I receive errors.

The error states: A formula in a cell could not be 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 saed, but the function itself will be converted to an error
value.

Nothing seems to be happening to the function.

Hopefully someone can direct me on how to correct this error...

 

[kosciosco]

Hello,

Just had a look at your formula and it doesn't make sense. It either
returns a 0 or a 20 or a 30 - the F35*0.15 in the max function serves
no purpose.

=IF(A4=0,0,IF(A4<=50,20,30)) will have the exact same result as your
formula and may solve your problem.

Hope that helps

Simon

 

[terry_d]

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

 

[gjcase]

Suggest you save under a new name, then pull up teh saved spreadsheet
find out where the #ERROR is listed, then examine that cell from th
original spreadsheet.

---GJ