I want data to show in the cell only when the info is inserted

R

Rebecca

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?
 
D

davesexcel

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

=if(ThisRange="","",YourFormulaHere
 
Top