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!

=IF(January!AH2+January!AI2<0,9,January!AH2+Januar y!AI2)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



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

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!

Thanks so much! That took care of it!

"Bob Phillips" wrote:

=IF(January!AH2+January!AI2<0,9,January!AH2+Januar y!AI2)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



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

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!

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!