## Sunday, October 27, 2013

### yogi_Compute Running Balance Based On Income Fees Postage And Initial Balance

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct 27, 2013
IF Statement giving error
I'm having a bit of a issue trying to figure this out.

I have created a spreadsheet that is supposed to be kinda of like a register

 Income Fees Postage Expense Balance \$77.00 \$9.46 \$1.69 \$65.85 \$155.00 \$18.75 \$1.69 \$200.41

The fees (eBay+PayPal) uses the following formula =IF(D3>0,(D3*.09)+((D3*0.029)+.30),IF(D3=0, ""))
The balance uses the following formula =IF(D3>0,((D3)-(E3+F3+G3)),IF(D3=0, ""))

The problem comes up when there's an expense. It sees that D3 (income) is blank and errors out. I've tried the following
=IF(D4>0,((H3+D4)-(E4+F4)),IF(D4=0, ""),IF(G4>0, H3-G4)) which does not work.

I think something like this will work, but I don't know the proper syntax, or if it's even possible.
=IF(D4>0, H3+D4-(E3+F3)), IF(D4=0 AND G4=0, ""), IF(D4=0 AND G4>0, H3-G4)

Any help would be greatly appreciated.
------------------------------------------------------------------------------------------------------