Sunday, October 27, 2013

yogi_Compute Running Balance Based On Income Fees Postage And Initial Balance

                                          Google Spreadsheet   Post  #1401
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct 27, 2013
question by Taitan Cards (http://productforums.google.com/forum/?zx=8bhktfk0b079#!mydiscussions/docs/IIl2Ej7Zeb0)
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

IncomeFeesPostageExpenseBalance
$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.
------------------------------------------------------------------------------------------------------

No comments:

Post a Comment