S shannon May 2, 2008 #1 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.
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.
S santaviga May 2, 2008 #2 Change the font colour to match the cell and enter a conditional format. MN
C Cimjet May 2, 2008 #3 Hi Shannon Type this in your second column, =IF(A2<1," ",A2) and copy down. Change cell reference to your needs. Regards Cimjet
Hi Shannon Type this in your second column, =IF(A2<1," ",A2) and copy down. Change cell reference to your needs. Regards Cimjet
G Gord Dibben May 2, 2008 #4 I would suggest you do use " " or you will create an unneeded space character. Use "" instead. Gord Dibben MS Excel MVP
I would suggest you do use " " or you will create an unneeded space character. Use "" instead. Gord Dibben MS Excel MVP
G Gord Dibben May 2, 2008 #5 Correction for typo "do NOT use" Gord I would suggest you do use " " or you will create an unneeded space character. Use "" instead. Gord Dibben MS Excel MVP Click to expand...
Correction for typo "do NOT use" Gord I would suggest you do use " " or you will create an unneeded space character. Use "" instead. Gord Dibben MS Excel MVP Click to expand...
