Hide Answer in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kenneth - 26 Nov 2006 04:54 GMT

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.

Reply to this Message

Martin B - 26 Nov 2006 05:16 GMT

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

> Hey Everyone, I normally can find an answer but so far I dont see this
> answer.
[quoted text clipped - 7 lines]
> anything for C1, how can I hide the answer until I add something? I hope
> this makes sense.

Reply to this Message