| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF function inequality is not calculating correct result
I recently copied a IF formula to a new sheet and am finding that the
inequality contained in the statement is not providing the correct results. Here is the formula: =IF((F6(I6*5)), ((ABS(G6-F6))/((F6+G6)/2)), "NA") The results are showing the formula calculation, even when the inequality is not true and the "NA" should be showing. For example, where F6 is less than I6*5, the cell contents do not show "NA" but the calculated result. The formula is working fine in other places in the workbook, but just not in this one section. Any help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function argument correct result but answer 0 in cell? | Excel Worksheet Functions | |||
| Not obtaining the correct result | Excel Discussion (Misc queries) | |||
| A correct IF function doesn't show the function's result in cell | Excel Discussion (Misc queries) | |||
| Function WEEKNUM does not show correct result for 15.2.2005 | Excel Worksheet Functions | |||
| the result of nbval is not correct | Excel Discussion (Misc queries) | |||
Threaded Mode
