Problematic If clause

**gloria** · 12-16-2009, 12:44 PM

Can somebody please explain to me why this formula does not work?

=IF(O14+P14>0,(G12-O12)+(H12-P12)," ")

**NBVC** · 12-16-2009, 12:47 PM

How does it not work? What are you getting?

**CRIMEDOG** · 12-16-2009, 12:48 PM

=if((o14+p14)>0,((g12-o12)+(h12-p12)),"")
Probably too many parenthesis - but this is what I would try.

**gloria** · 12-16-2009, 02:19 PM

I've been playing around with a different take on the debt snowball idea whereby we reduce our debt to a 300 balance thereby getting the minimum payment down to 10 euro, and the interest paid to around 3 euro. To do that we need to make payments that are in excess of the 300 euro.

To keep track of the savings in the M column I want to enter the interest and minimum payment of the next months bill in columns N and O and have the formula =IF(N7+O7>0,(F5-N5)+(G5-O5)," ") kick in and give me the savings automatically. Then we can add that savings to the extra money we use to pay our debt with so as to make a slightly larger payment the following month.

Problem is that the formula doesn't get the job done

Thanks for the help.

**darkyam** · 12-16-2009, 01:13 PM

Crimedog, her formula should work as it was.

Gloria, my first guess is you're trying to add or subtract values entered as text that cannot be coerced into values, such as a date format Excel doesn't recognize. However, without a workbook or, at least, a good example of your layout and your results, it is impossible for us to determine your error.

**darkyam** · 12-16-2009, 02:24 PM

Perhaps you meant =IF(N7+O7>0,(F7-N7)+(G7-O7),"")

earthworm · 12-16-2009, 03:16 PM

Originally Posted by gloria

Can somebody please explain to me why this formula does not work?

=IF(O14+P14>0,(G12-O12)+(H12-P12)," ")

give the excel example

**gloria** · 12-16-2009, 04:37 PM

Thank you darkyam, don't know how I got so careless. You are absolutely right, that is exactly what I meant and the formula does exactly what I wanted it to do.

Perhaps you meant =IF(N7+O7>0,(F7-N7)+(G7-O7),"")

Thanks all. Sorry to have taken up your time with my confusion.