If Function
 

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
--
Bushy

If Function
 

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

John

"Bushy" wrote in message ...
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
--
Bushy

If Function
 

Try

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

If this post helps click Yes
---------------
Jacob Skaria


"Bushy" wrote:

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
--
Bushy

If Function
 

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")




Bushy wrote:

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
--
Bushy

--

Dave Peterson