if statements

[sdav]

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]

In a new cell (say B34???):

=if(b33>c3*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*b32>c3*c33,c3*c33,b2*b32)
or
=min(b2*b32,c3*c33)

 

[Luke M]

==MIN(C3*C33,B2*B32)

 

[Joe User]

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