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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF function inequality is not calculating correct result
If you could show the values you have in F6 and I6? Since the formula works
elsewhere, somethign must not be accurate in the section you're referencing. "Matt Ballantine" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF function inequality is not calculating correct result
Matt,
The formula as stated tests if F6 is Greater Than I6*5 and works for me. However, the term "inequality" would suggest the "<" 'not equal to' operator. If you really need to test that F6 is Not Equal to I6*5, change the "" to" <". Hope this helps. Dave "Matt Ballantine" <Matt wrote in message ... 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? |
Reply |
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) |