Hide Answer in Excel

K

Kenneth

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.
 
M

Martin B

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
 
Top