| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulas producing unjustified results
using "if" functions such as"=IF(SUM(E27:M27)-D27=0,"",SUM(E27:M27)-D27)" I
keep getting unexpected results such as -9.09495E-13 when formula code is set to general or -0.00 when it is set to two decimal places. No cells within the range have more than two decimal places and there are no hidden cells involved either. This is not happening everytime, maybe once or twice on a spreadsheet where the formula is applied up to 30 times. Can anyone explain why this is happening and how to stop it in future please? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif formulas change after doing a sort | Excel Worksheet Functions | |||
| Formulas not showing results | Excel Worksheet Functions | |||
| How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
| Displaying the results of multiple formulas in a single cell. | New Users to Excel | |||
| Copying options: contents, results, formulas, etc. | New Users to Excel | |||
Threaded Mode
