View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
terry_d
 
Posts: n/a
Default Errors using a new function


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


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