IF THEN formula problem

[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

 

[christopherp]

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?

Try this one mate:

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

Chri

 

[Guest]

in D21:

=if(TNT!C10+TNT!C13 >D27,D27,TNT!C10+TNT!C13 )

HTH

 

[Bondi]

Hi,
Try

=IF(TNT!C10+TNT!C13>D27,D27,TNT!C10+TNT!C13)

Regards,
Bondi