If statement
Of a zero is acceptable if A1 is *not* larger then B1, then try this:
=--(A1<B1)
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"RagDyeR" wrote in message
...
Try this:
=If(A1<B1,1,"")
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"Mary" wrote in message
...
Hello,
What is the syntax of a formula that looks up one cell ("A1")to see if that
one is smaller than another cell ("B1"). If it is, then a "1" should be
inserted into the cell with the formula "C1". Thank you in advance.
:) Mary
|