View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pen pen is offline
external usenet poster
 
Posts: 5
Default Hiding Formula Answers in Specific Cells

In Excel 2003, I need to hide answers from a simple sum formula only in
specific cells.

I have a simple sum formula in a column that is dragged down into multiple
cells in one column. If I input a value like 2 into cell B14, it calculates
and inputs the answer into cells C14 - C29, repeating the answer in every
cell that has the formula. I need this to only display the answer in cell
C14, leaving cells C15 - C29 blank.

Is this possible?