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
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(A1>44,A1,0)
HTH
--
AP
"MGD" <[email protected]> a écrit dans le message de
news:[email protected]...
> 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
=MAX(0,44-A1)
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"MGD" <[email protected]> wrote in message
news:[email protected]...
> 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
I think you meant:
=MAX(0,A1-44)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks