Or =MAX(January!AH2+January!AI2,0)
--
David Biddulph

"FSt1" wrote in message
...
hi
i think bob did a typo.
i think it should be...
=IF(January!AH2+January!AI2<0,0,January!AH2+Januar y!AI2)

it happens now and then. i've done it too.

Regards
FSt1

"sferguson" wrote:

I am trying to create a formula that would read as follows:

If JanuaryAH2+JanuaryAI2 equals a negative amount then return a zero, if
it
is a positive amount, return that amount.

Any help would be appreciated.

Thanks!