Need Help with a Formula

[sferguson]

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!

 

[Bob Phillips]

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

--
---
HTH

Bob


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

 

[FSt1]

hi
i think bob did a typo.
i think it should be...
=IF(January!AH2+January!AI2<0,0,January!AH2+January!AI2)

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

Regards
FSt1

 

[sferguson]

Thanks so much! That took care of it!

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

--
---
HTH

Bob


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

 

[sferguson]

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!

 

[David Biddulph]

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