Show Blank Cell instead of zero

[CLSSY56]

If A1 is blank, how can F1 Reflect what is in A1? I had =A1, but the value in F1 was 0.

[VBA Noob]

Either

=if(a1="","",a1)

or see link

http://www.excelforum.com/showthread.php?t=618412

VBA Noob

[NBVC]

=if(A1="","",A1)

[corinereyes]

Hi CLSSY56,

Do you want F1 to return blank when A1 is blank?

Please Login or Register  to view this content.

[CLSSY56]

thanks, ya'll are the best.

[VBA Noob]

Good to see.

Here were the other options

1) tools > options > view and untick zero values

2)You can also use conditional formatting

http://www.contextures.com/xlCondFormat01.html
Were value equal zero

3) Format the cell as

0;;

VBA Noob