| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"IF" formula returns zero or other incorrect number
I have a workbook consisting of three interactive pages that I have worked
with for twoyears. Recently various cells have begun to return inncorrect numbers, most often "Zero". Auditing the formula results in the formula screen (use of Fx function) displaying the correct number, even while the cell is displayingan incorrect number. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to determine number of Standard Deviations based on % of population | Excel Worksheet Functions | |||
| formula to use when number of rows changes dynamically | Excel Worksheet Functions | |||
| sumif formula returns incorrect value | Excel Worksheet Functions | |||
| Formula giving incorrect answer... | Excel Discussion (Misc queries) | |||
| How do I replace a negative number at the end of a formula with a. | Excel Discussion (Misc queries) | |||
Threaded Mode
