If Function

[Bushy]

I keep getting the wrong result when I use =IF(G20<=+-H20,"OK","PROBLEM"). I
know the result should be "Problem" due to G20 being less than H20

 

[jaf]

Hi,
Delete the "+-"
If you need h20 to be a negative value wrap it in ().

John

 

[Jacob Skaria]

Try

=IF(G20<=ABS(H20),"OK","PROBLEM")

If this post helps click Yes

 

[Dave Peterson]

What's in G20 and what's in H20? And what should be returned with those two
values?

Maybe:

=IF(G20<=-H20,"OK","PROBLEM")
or
=IF(G20<=-abs(H20),"OK","PROBLEM")
or
=IF(G20<=H20,"OK","PROBLEM")