Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SQL concatenation statement | Excel Discussion (Misc queries) | |||
SET statement tutorial | Excel Discussion (Misc queries) | |||
If statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
IF Statement nightmare | Excel Discussion (Misc queries) |