When I put the formula in my spreadsheet I made that change so it took care
of it! I'm not great with the logicals so just to see what it should look
like helped a ton. Thanks guys!

"FSt1" wrote:

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!