LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hiding sum formula answers in select cells pen Excel Worksheet Functions 5 May 6th 09 07:21 PM
HOW TO AUTO COLOR CELLS BASED ON FORMULA ANSWERS Merv Excel Discussion (Misc queries) 1 December 4th 08 05:46 PM
hiding specific cells Ashley Excel Worksheet Functions 4 June 7th 08 12:34 AM
Hiding Results of Answers for a Quiz ScottishSteve Excel Discussion (Misc queries) 1 March 14th 08 05:00 PM
Hiding Formula in cells thrava Excel Discussion (Misc queries) 2 December 23rd 04 12:42 AM


All times are GMT +1. The time now is 09:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"