LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
UDF help please Adam Kroger Excel Discussion (Misc queries) 3 December 17th 05 07:21 PM
Date & Time mully New Users to Excel 4 May 23rd 05 11:56 AM
Hyperlinks using R[1]C[1] and offset function in its cell referenc Elijah-Dadda Excel Worksheet Functions 0 March 5th 05 03:31 AM
Conversion SVC Excel Worksheet Functions 9 February 28th 05 02:29 PM
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. Robert AS Excel Worksheet Functions 4 December 2nd 04 10:49 AM


All times are GMT +1. The time now is 05:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"