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

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

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

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

--
Thanks,
Shane Devenshire


"steve45" wrote:

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

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

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)
--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"steve45" wrote:

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

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

Bloody Genius. It worked!!! Fantastic.

"Sheeloo" wrote:

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)
--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"steve45" wrote:

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

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

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

"ShaneDevenshire" wrote:

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

--
Thanks,
Shane Devenshire


"steve45" wrote:

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

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

:-)


--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"steve45" wrote:

Bloody Genius. It worked!!! Fantastic.

"Sheeloo" wrote:

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)
--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"steve45" wrote:

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

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

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

"steve45" wrote in message
...
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" ???