Hide Answer in Excel
 

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.

Hide Answer in Excel
 

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

"Kenneth" wrote in message
...
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.

Hide Answer in Excel
 

It worked, thanks Martin! :)

"Martin B" wrote:

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

"Kenneth" wrote in message
...
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.