Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to hide cell reference borders (top/left side) in Excel? | Excel Discussion (Misc queries) | |||
Hide Excel session when running at the batch mode | Excel Discussion (Misc queries) | |||
How do I make excel hide columns when it says cannot move objects | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |