Using a formula alongside "ISBLANK" request is resulting in bad values

Hello everyone,

I am new to this forum, so please forgive me if I have posted this in an incorrect section. I've spent the last two hours reading forums and searching Google for assistance prior to coming here, but to no avail.

Capture.PNG

I have created a ledger and my goal is to have the balance (or I column) appear blank when there is not a value in the credit (E) and debit (F) cells.
I encountered this issue when using a formula such as =I22-E24+F24 to calculate the balance. As a result of copying the formula down the column, the balance is repeated all the way down as shown below:

Capture.PNG

In an attempt to combat this, I tried using the following formula:

=IF(OR(ISBLANK(E24),ISBLANK(F24)),"",I24-E24+F24)

It works, however, if I enter an amount in the debit field, I have to enter a 0 in the credit field in order for it to calculate, resulting in $0.00 being erroneously displayed as displayed below:

Capture.PNG

I don't understand what I am missing. Does anyone have any insight on how this may work without entering an opposing "$0.00" in the credit/debit cells? Your help would be immensely appreciated.

Hi, welcome to the forum

1st, where do the contents of E and F come from?
Note that a cell with a formula - no matter what that formula returns - is NOT blank. Blank means empty/contains nothing.
I prefer to use ="" instead
=IF(OR(E24="",F24=""),"",I24-E24+F24)

If that still doesnt work, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.