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

[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" ???

 

[ShaneDevenshire]

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?"

 

[Sheeloo]

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)

 

[steve45]

Bloody Genius. It worked!!! Fantastic.

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)

 

[steve45]

"Duh" on me! However Sheeloo read my mind. Thanks.

 

[Sheeloo]

 

[MartinW]

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