S
shannon
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.
want the 2nd one to be blank and not put a 0.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
santaviga
Change the font colour to match the cell and enter a conditional format.
MN
MN
C
Cimjet
Hi Shannon
Type this in your second column, =IF(A2<1," ",A2) and copy down.
Change cell reference to your needs.
Regards
Cimjet
Type this in your second column, =IF(A2<1," ",A2) and copy down.
Change cell reference to your needs.
Regards
Cimjet
G
Gord Dibben
I would suggest you do use " " or you will create an unneeded space character.
Use "" instead.
Gord Dibben MS Excel MVP
Use "" instead.
Gord Dibben MS Excel MVP
G
Gord Dibben
Correction for typo "do NOT use"
Gord
Gord
I would suggest you do use " " or you will create an unneeded space character.
Use "" instead.
Gord Dibben MS Excel MVP