If statement
 

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

If statement
 

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

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