display total above certain number and display

M

MGD

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
 
B

Bob Phillips

=MAX(0,44-A1)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top