View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kenneth Kenneth is offline
external usenet poster
 
Posts: 20
Default 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.