M
Matt Ballantine
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?
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?