Menu
I am trying to create a simple ledger and on the far right of the "Book" it totals any debit/credit that I input. But instead of leaving the unused rows blank, it keeps repeating the latest total to the bottom of the page.
How Can I make that cell blank if the equation equals 0?
=H15+G16-F16
is the formula I am currently using.
400
Keep cell blank until data entered in Select first cell that you want to place the calculated result, type this formula =IF(OR(ISBLANK(A2),ISBLANK(B2)), "", A2-B2), and drag fill handle down to apply this formula to the cells you need.
Use Excel's Find/Replace Function to Replace Zeros Choose Find/Replace (CTRL-H). Use 0 for Find what and leave the Replace with field blank (see below). Check “Match entire cell contents” or Excel will replace every zero, even the ones within values.
Click on Options. In the Excel Options dialog box that opens, click on the 'Advanced' option in the left pane. Scroll down to the section that says 'Display option for this worksheet', and select the worksheet in which you want to hide the zeros. Uncheck the 'Show a zero in cells that have zero value' option.
Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it's false. For example: =IF(A2>B2,"Over Budget","OK") =IF(A2=B2,B4-A4,"")
You can change the number format of the column to this custom format:
0;-0;;@
which will hide all 0 values.
To do this, select the column, right-click > Format Cells > Custom.
69
Use =IF(H15+G16-F16=0,"",H15+G16-F16)
41
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
