Greater Than/Equal To Formula
 

I am using a greater than formula "=IF(H42E42,200,0)". Can anyone tell me
if there is a greater than/equal to formula (if H42 is greater than or equal
to E42)?

Greater Than/Equal To Formula
 

=IF(H42=E42,200,0)
--
Gary''s Student - gsnu200730


"Millington" wrote:

I am using a greater than formula "=IF(H42E42,200,0)". Can anyone tell me
if there is a greater than/equal to formula (if H42 is greater than or equal
to E42)?

Greater Than/Equal To Formula
 

Sat, 16 Jun 2007 16:56:00 -0700 from Millington
:
I am using a greater than formula "=IF(H42E42,200,0)". Can anyone tell me
if there is a greater than/equal to formula (if H42 is greater than or equal
to E42)?

Indeed there is: =

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/

Greater Than/Equal To Formula
 

=(H4=E4)*200


"Millington" wrote:

I am using a greater than formula "=IF(H42E42,200,0)". Can anyone tell me
if there is a greater than/equal to formula (if H42 is greater than or equal
to E42)?

Greater Than/Equal To Formula
 

FYI. The Help file topic is found under "Calculation operators and
precedence".

--
HTH :)
Dana DeLouis

"Millington" wrote in message
...
I am using a greater than formula "=IF(H42E42,200,0)". Can anyone tell me
if there is a greater than/equal to formula (if H42 is greater than or
equal
to E42)?