=IF(A1=,"","",A1)
"Raza" wrote in message
...
When I reference a blank cell, the result is "0" but I want the result to
be
blank as well. Is this a formatting issue?
Example: A1 is blank
my formula for cell C1 is =A1, which results in 0 (I want it to be blank)
eventually, when I fill in A1, I want C1 to show the same result. I just
dont want a bunch of zeros all over my sheet!
|