Excell formula required. If a^b=C....... a = ?

  • Thread starter Thread starter Guest
  • Start date Start date
I am in need of help, i am making a check book and i have a final column that
show my balance. the formula for this is "SUM=E11-C12+D12" and for the next
cell "SUM=E12-C13+D13" Now when i drop down the window for the rest of my
cells, it shows my current balance for ALL of them.. i understand why it is
doing it but is there a way to hide them until a withdraw or deposit is
issued? Not only does it look ugly but kinda confusing seeing the grand total
 
=if(count(c12:d12)=0,"",e11-c12+d12)

So if you don't enter any numbers in C12:D12, then the cell looks empty (even
though it contains that formula).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

EXCEL - IF(IFERROR(VLOOKUP question 0
Scrabble Value calculation for Welsh words 0
Copying formulas across columns 2
With F1 value, look at A, if match or partial match return B 5
If statements 2
Compare A&B columns with C&D columns 4
=IF(I2="",IF(F3>0,F3,""),IF(F3>0,(F3+1)*(I2+1)-1,"")) ERROR?? 0
Formula required 1

Back
Top