| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Blank Cell
I want a cell that has a formula to appear empty until I enter data into the
cell it's referring to. I am getting a zero and I want it to appear empty. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Blank Cell
post this formula and someone will help
"Tonks" wrote: I want a cell that has a formula to appear empty until I enter data into the cell it's referring to. I am getting a zero and I want it to appear empty. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Blank Cell
"Tonks" wrote:
I want a cell that has a formula to appear empty until I enter data into the cell it's referring to. I am getting a zero and I want it to appear empty. I think you want this paradigm: =if(A1="", "", A1*2) Caveat: If that formula is in A2, then use A2="", not ISBLANK(A2), to test if A2 is __appears__ empty. Also, since A2 is not truly empty, formulas like =A2*3 will not work when A2 evaluates to "" (null string). Use N(A2); for example, =N(A2)*3 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Blank Cell
The formula that I think I need to use is this one. I don't know where or how
to enter that I want it to remain blank until I've entered my data into B2 =SUM(IF((B20),C1+B2)) "Mike H" wrote: post this formula and someone will help "Tonks" wrote: I want a cell that has a formula to appear empty until I enter data into the cell it's referring to. I am getting a zero and I want it to appear empty. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Blank Cell
Try this
=IF(B20,C1+B2,"") Mike "Tonks" wrote: The formula that I think I need to use is this one. I don't know where or how to enter that I want it to remain blank until I've entered my data into B2 =SUM(IF((B20),C1+B2)) "Mike H" wrote: post this formula and someone will help "Tonks" wrote: I want a cell that has a formula to appear empty until I enter data into the cell it's referring to. I am getting a zero and I want it to appear empty. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Blank Cell
That's exactly what I needed. Thank you!
"Mike H" wrote: Try this =IF(B20,C1+B2,"") Mike "Tonks" wrote: The formula that I think I need to use is this one. I don't know where or how to enter that I want it to remain blank until I've entered my data into B2 =SUM(IF((B20),C1+B2)) "Mike H" wrote: post this formula and someone will help "Tonks" wrote: I want a cell that has a formula to appear empty until I enter data into the cell it's referring to. I am getting a zero and I want it to appear empty. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to return a blank formula cell if the reference is blank? | Excel Worksheet Functions | |||
| Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
| how to get excel to display blank if reference cell blank | Excel Worksheet Functions | |||
| How do I make a blank cell with a date format blank? | Excel Worksheet Functions | |||
| COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
Linear Mode
