if(or statement to return blank cell

[TomRet]

Ok, I have a sheet for easy balancing of a checkbook (or other tracking) but I would like to see if I can modify the formula to return a blank cell if 0 (zero) is entered into the cell from which the computation takes place.

Here is the formula I currently have:

=IF(OR(F9>0,G9>0),H8-F9+G9,"")

I'm linking a workbook.

Thanks,
Tom

[AlKey]

Try it like this

=IFERROR(1/(1/IF(OR(F4>0,G4>0),H3-F4+G4,"")),"")

[oeldere]

alternative formula for cell H4

H4=if(F4="",H3+G4,H3-F4)

I don't understand your question though.

[TomRet]

Neither of those work. I apologize for the way I explained this, I see now that I worded it wrong in my spreadsheet. What cell E10 said was this "Here I want to have blank cells e10 and f10 return $100.00 in column G"...what it should have said was this; "Here I want to enter 0 into (one or the other or both) cells e10 and f10 and have it return $100.00 in column G".

Thanks,
Tom

[bebo021999]

In G10:

=IF(E10&F10="","",IF(LEFT(E10&F10)="0",100,""))

In H4 and drag down

=H3+IFERROR(G4-F4,0)

[TomRet]

Still not working but again I notice a problem...I am so sorry. The column I wish to modify is H...I want to be able to enter 0's into either (or both) F and G and have H return a value. Since I would be entering 0 then H10 should return the same value as H9.

Tom

[TomRet]

Would an isblank statement work here?