software

What I need to do is the following:
if the total of formula A is greater than 44 then display the amount above 44
if not then display 0

Thank you for your assistance

=IF(A1gt;44,A1,0)

HTH
--
AP

quot;MGDquot; gt; a écrit dans le message de
...
gt; What I need to do is the following:
gt; if the total of formula A is greater than 44 then display the amount above
44
gt; if not then display 0
gt;
gt; Thank you for your assistance
=MAX(0,44-A1)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;MGDquot; gt; wrote in message
...
gt; What I need to do is the following:
gt; if the total of formula A is greater than 44 then display the amount above
44
gt; if not then display 0
gt;
gt; Thank you for your assistance

I think you meant:

=MAX(0,A1-44)--
Cutter
------------------------------------------------------------------------
Cutter's Profile: www.excelforum.com/member.php...foamp;userid=9848
View this thread: www.excelforum.com/showthread...hreadid=518999