display total above certain number and display
 

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

display total above certain number and display
 

=IF(A144,A1,0)

HTH
--
AP

"MGD" a écrit dans le message de
...
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

display total above certain number and display
 

=MAX(0,44-A1)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"MGD" wrote in message
...
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

display total above certain number and display
 

I think you meant:

=MAX(0,A1-44)


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=518999