| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if statements
I need to add an if statement to a calculation...
B2 = 2% B32 = 1,000,000 B33 = B2*B32 B33: Can not be higher than C3*C33 - how do I add that to the field? Thank you! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if statements
In a new cell (say B34???):
=if(b33c3*c33,c3*c33,b33) or =min(b33,c3*c33) If the formula goes in B33, then just substitute your original formula in either expressions: =if(b2*b32c3*c33,c3*c33,b2*b32) or =min(b2*b32,c3*c33) sdav wrote: I need to add an if statement to a calculation... B2 = 2% B32 = 1,000,000 B33 = B2*B32 B33: Can not be higher than C3*C33 - how do I add that to the field? Thank you! -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if statements
==MIN(C3*C33,B2*B32)
-- Best Regards, Luke M "sdav" wrote in message ... I need to add an if statement to a calculation... B2 = 2% B32 = 1,000,000 B33 = B2*B32 B33: Can not be higher than C3*C33 - how do I add that to the field? Thank you! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if statements
"sdav" wrote:
B33 = B2*B32 B33: Can not be higher than C3*C33 - how do I add that to the field? =MIN(B2*B32, C3*C33) ----- original message ----- "sdav" wrote: I need to add an if statement to a calculation... B2 = 2% B32 = 1,000,000 B33 = B2*B32 B33: Can not be higher than C3*C33 - how do I add that to the field? Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if then statements | Excel Worksheet Functions | |||
| If, Then Statements | Excel Worksheet Functions | |||
| If, Then Statements | Excel Worksheet Functions | |||
| IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
| if statements help | New Users to Excel | |||
Hybrid Mode
