How do you enter an "if, then" formula?

  • Thread starter Thread starter steve45
  • Start date Start date
S

steve45

Does anyone know how to enter a formula that tells the cell function: "if
the sum of B1-B2 is Less than 2000, then enter 2000" ???
 
Hi,

=IF(B1-B2<2000,2000,"what's here?")

Well you told us what you wan to do if it is less than 2000, what if it is
2000 or greater. I put in "what's here?"
 
Yes, many of us do :-)
=IF((B1-B2)<2000,2000,(B1-B2))
This will evaluate to 2000 if (B1-B2) is less than 2000 and to (B1-B2)
otherwise...

IF syntax is
=IF(condition, value if true, value if false)
 
Bloody Genius. It worked!!! Fantastic.

Sheeloo said:
Yes, many of us do :-)
=IF((B1-B2)<2000,2000,(B1-B2))
This will evaluate to 2000 if (B1-B2) is less than 2000 and to (B1-B2)
otherwise...

IF syntax is
=IF(condition, value if true, value if false)
Click to expand...
 
Just to add a bit here,

As well as using the IF function, can also use the MAX
and MIN functions to do this sort of thing. e.g.

=MAX(B1-B2,2000)

HTH
Martin
 
Back
Top