If statement

[Guest]

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

 

[RagDyeR]

Try this:

=If(A1<B1,1,"")
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

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

 

[RagDyeR]

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!
=====================================================

Try this:

=If(A1<B1,1,"")
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

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