Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() =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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
UDF help please | Excel Discussion (Misc queries) | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |