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?

Hiding Formula Answers in Specific Cells
 

Check out your earlier posting, and please do not multi-post.

Pete

On May 4, 6:45*pm, pen wrote:
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?