Thread: if statements
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joe User[_2_] Joe User[_2_] is offline
external usenet poster
 
Posts: 905
Default 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!