Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keep Cell Data Blank when Copying It
This is a silly question for me, but:
I have a column of cells that are currently blank and another column that is a direct reference to that (i.e., cell AC3=Y3). However, while Y3 remains blank, AC3 instead reflects a 0. How do I make this remain blank until there is a value 0 or higher entered into Y3? This is key because I have formulas referencing AC3 that depend on whether it is blank and the 0 valuation is skewing that. Thank you! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keep Cell Data Blank when Copying It
Try an IF statement in column AC:
=IF(Y30,Y3,"") Dave O'Brien Eschew obfuscation |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keep Cell Data Blank when Copying It
Hi
=IF(Y3="","",Y3) -- Regards Roger Govier "king60611" wrote in message ... This is a silly question for me, but: I have a column of cells that are currently blank and another column that is a direct reference to that (i.e., cell AC3=Y3). However, while Y3 remains blank, AC3 instead reflects a 0. How do I make this remain blank until there is a value 0 or higher entered into Y3? This is key because I have formulas referencing AC3 that depend on whether it is blank and the 0 valuation is skewing that. Thank you! __________ Information from ESET Smart Security, version of virus signature database 4754 (20100108) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4754 (20100108) __________ The message was checked by ESET Smart Security. http://www.eset.com |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keep Cell Data Blank when Copying It
You can change your formula to:
=IF(Y3="","",Y3) Note that if this is evaluate by the ISBLANK function, it returns false as the cell is not truly "blank". This is a common annoyance, but the workaround usually involves using a < or operator, or simply the ISNUMBER function. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "king60611" wrote: This is a silly question for me, but: I have a column of cells that are currently blank and another column that is a direct reference to that (i.e., cell AC3=Y3). However, while Y3 remains blank, AC3 instead reflects a 0. How do I make this remain blank until there is a value 0 or higher entered into Y3? This is key because I have formulas referencing AC3 that depend on whether it is blank and the 0 valuation is skewing that. Thank you! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keep Cell Data Blank when Copying It
I thought Roger's solution would work, but I'm not really sure how to
incorporate it into the rest of my formula since I guess it's really not as simple as I made it out to be: =IF(G3="Mktg Paid", Y3,"") So, the idea is that as long as Y3 is blank, so should cell AC be but if there's a value, that's what it should read. Unfortunately, I left out the further qualifier of the G3 value. My apologies. I'm still new at writing my own formulas. "Roger Govier" wrote: Hi =IF(Y3="","",Y3) -- Regards Roger Govier "king60611" wrote in message ... This is a silly question for me, but: I have a column of cells that are currently blank and another column that is a direct reference to that (i.e., cell AC3=Y3). However, while Y3 remains blank, AC3 instead reflects a 0. How do I make this remain blank until there is a value 0 or higher entered into Y3? This is key because I have formulas referencing AC3 that depend on whether it is blank and the 0 valuation is skewing that. Thank you! __________ Information from ESET Smart Security, version of virus signature database 4754 (20100108) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4754 (20100108) __________ The message was checked by ESET Smart Security. http://www.eset.com |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keep Cell Data Blank when Copying It
Hi
Try =IF(AND(G3="Mktg Paid",Y3=""),"",Y3) -- Regards Roger Govier "king60611" wrote in message ... I thought Roger's solution would work, but I'm not really sure how to incorporate it into the rest of my formula since I guess it's really not as simple as I made it out to be: =IF(G3="Mktg Paid", Y3,"") So, the idea is that as long as Y3 is blank, so should cell AC be but if there's a value, that's what it should read. Unfortunately, I left out the further qualifier of the G3 value. My apologies. I'm still new at writing my own formulas. "Roger Govier" wrote: Hi =IF(Y3="","",Y3) -- Regards Roger Govier "king60611" wrote in message ... This is a silly question for me, but: I have a column of cells that are currently blank and another column that is a direct reference to that (i.e., cell AC3=Y3). However, while Y3 remains blank, AC3 instead reflects a 0. How do I make this remain blank until there is a value 0 or higher entered into Y3? This is key because I have formulas referencing AC3 that depend on whether it is blank and the 0 valuation is skewing that. Thank you! __________ Information from ESET Smart Security, version of virus signature database 4754 (20100108) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4754 (20100108) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4755 (20100108) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4755 (20100108) __________ The message was checked by ESET Smart Security. http://www.eset.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return blank cell if data cell is blank | Excel Worksheet Functions | |||
how can i fill data in blank cells after copying a pivot report? | Excel Discussion (Misc queries) | |||
finding last non-blank cell and then copying it to the next cell | Excel Discussion (Misc queries) | |||
Copying a Blank Cell | Excel Worksheet Functions | |||
Automatic copying data excluding blank cells | Excel Worksheet Functions |