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