Error Message

[tomvh444]

I just transferred my excel (2010) files to a new computer. All is fine except on one formula that worked fine on the old computer but now gets the green error triangle. The formula is: =IF(OR(AND(J4=0,K4=0),COUNT(J4:K4)<2),"",IF(J4-K4<0,"L","W"))

There is also a number in I4 and if I change the formula to: =IF(OR(AND(J4=0,K4=0),COUNT(I4:K4)<2),"",IF(J4-K4<0,"L","W"))
then the little green triangle goes away. Or if I delete the number in I4 with the original formula the error message disappears. But I know the original formula is correct and don't want to start modifying the formula just to get the green error triangle to disappear. Can you help?

[Paul]

Hi Tom,

In Excel Options, you probably have Error Checking set to check for "Formulas which omit cells in a region". Open Excel Options > Formulas > un-check that rule.

[tomvh444]

Got it. Thank you very much for where to go to resolve this.