IF THEN formula problem

S

sharkfoot

How do I write this formula:

D21 =TNT!C10+TNT!C13 but if D21 is greater than D27, D21 should equa
whatever is in D27.

I have never written an If Then formula. How do I accomplish this
 
C

christopherp

sharkfoot said:
How do I write this formula:

D21 =TNT!C10+TNT!C13 but if D21 is greater than D27, D21 should equa
whatever is in D27.

I have never written an If Then formula. How do I accomplish this?
Click to expand...

Try this one mate:

=IF((SUM(tnt!c10,tnt!c13)>C3),C3,(SUM(tnt!c10,tnt!c13)))

Chri
 
Top