Correction for typo "do NOT use"


Gord

On Fri, 02 May 2008 13:02:41 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

I would suggest you do use " " or you will create an unneeded space character.

Use "" instead.


Gord Dibben MS Excel MVP

On Fri, 2 May 2008 12:41:21 -0400, "Cimjet"
wrote:

Hi Shannon
Type this in your second column, =IF(A2<1," ",A2) and copy down.
Change cell reference to your needs.
Regards
Cimjet
"shannon" wrote in message
...
I have 2 cells, I want one to equal the other but if the 1st one is blank I
want the 2nd one to be blank and not put a 0.