software

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: www.excelforum.com/member.php...oamp;userid=32164
View this thread: www.excelforum.com/showthread...hreadid=525658
sharkfoot Wrote:
gt; How do I write this formula:
gt;
gt; D21 =TNT!C10 TNT!C13 but if D21 is greater than D27, D21 should equal
gt; whatever is in D27.
gt;
gt; I have never written an If Then formula. How do I accomplish this?

Try this one mate:

=IF((SUM(tnt!c10,tnt!c13)gt;C3),C3,(SUM(tnt!c10,tnt! c13)))

Chris--
christopherp
------------------------------------------------------------------------
christopherp's Profile: www.excelforum.com/member.php...foamp;userid=4162
View this thread: www.excelforum.com/showthread...hreadid=525658in D21:

=if(TNT!C10 TNT!C13 gt;D27,D27,TNT!C10 TNT!C13 )

HTH

quot;sharkfootquot; wrote:

gt;
gt; How do I write this formula:
gt;
gt; D21 =TNT!C10 TNT!C13 but if D21 is greater than D27, D21 should equal
gt; whatever is in D27.
gt;
gt; I have never written an If Then formula. How do I accomplish this?
gt;
gt;
gt; --
gt; sharkfoot
gt; ------------------------------------------------------------------------
gt; sharkfoot's Profile: www.excelforum.com/member.php...oamp;userid=32164
gt; View this thread: www.excelforum.com/showthread...hreadid=525658
gt;
gt;