Hide Answer in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey Everyone, I normally can find an answer but so far I dont see this answer.


How can I hide an answer in Excel.

Im doing a banking spreadsheet and I want to hide the total for the blank
cells.

Like B3=B1+A2, and that would give me the amount...but say I dont have
anything for C1, how can I hide the answer until I add something? I hope
this makes sense.
 
Assuming you mean you want a running total in Col B your formula would be
B2=B1+A2 which adds new enteries in Col A.

To hid the total until you make an entrie in Col A try B2=IF(ISBLANK(A2),"
",B1+A2) copied down as far as you like. This will hide the total until an
entrie is made in col A

Martin
 
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

Hiding Formula Answers in Specific Cells 1
Hiding sum formula answers in select cells 5
How to hide infromation in Excel? 3
excel "IF" function... is this possible ? 0
Hiding worksheets based on user selection 3
hiding an image 2
How do I hide subcategories in Excel? 1
Hiding uncalculated values 1

Back
Top