Keep Cell Data Blank when Copying It

[king60611]

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!

 

[Dave O]

Try an IF statement in column AC:
=IF(Y3>0,Y3,"")

Dave O'Brien
Eschew obfuscation

 

[Roger Govier]

Hi

=IF(Y3="","",Y3)

--
Regards
Roger Govier

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

 

[Luke M]

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.

 

[king60611]

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]

Hi

Try
=IF(AND(G3="Mktg Paid",Y3=""),"",Y3)

--
Regards
Roger Govier

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.



__________ 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