Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" ??? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" ??? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" ??? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" ??? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" ??? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" ??? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" ??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! | Excel Discussion (Misc queries) | |||
Make "Edit" mode default, rather than "Enter"? | Excel Discussion (Misc queries) | |||
how do you enter more than 7 "if" functions in a formula? | Excel Worksheet Functions | |||
excel formula to enter "0" if cell blank | Excel Worksheet Functions |