Thread: I want data to show in the cell only when the info is inserted
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
davesexcel
 
Posts: n/a
Default I want data to show in the cell only when the info is inserted

Rebecca Wrote:
I am working in excel and have basic formulas set in the worksheet. As
I
copy and paste the formulas, if there is not any info there it either
puts a
0.00 or it just copies the pervious data from the cell above it. Is
there a
way to have the formulas there and nothing show in the cell until
information
is placed into the cells?

=if(ThisRange="","",YourFormulaHere)


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=535333

Reply With QuoteReply With Quote