How do I write this formula:

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

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


--
sharkfoot
------------------------------------------------------------------------
sharkfoot's Profile: http://www.excelforum.com/member.php...o&userid=32164
View this thread: http://www.excelforum.com/showthread...hreadid=525658