Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want data to show in the cell only when the info is inserted
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data in cell not corresponding with entry | New Users to Excel | |||
How identify data of two coulams,Every cell count and show result | Excel Discussion (Misc queries) | |||
numbers being entered show in formula bar but not in cell? | Excel Discussion (Misc queries) | |||
Multiple worksheet queries | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |