IF formula? 1

[jasonsas]

Hi,

I am linking cells from one worksheet to another. I've found that if the "linked" cell does not contain anything, it returns a value of 0. Is there anyway to do it so that the cell cell just remains blank? I'm thinking the IF formula would do this, but I'm not sure how to go about it.

Thanks.

 

[MeGustaXL]

Couple of ways come to mind for starters:

1. Tools, Options, View, uncheck Zero values

or..

2. In the Destination cell(s): =IF(ISBLANK(SourceCell),"",SourceCell)

Try those and see if one helps

Chris

When his pin is pulled, Mr Grenade is not our friend - USMC Infantry Manual

 

[GlennUK]

... or a Custom Number format of:
#,##0;-#,##0;;

( or similar ).

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[jasonsas]

Thanx MeGustaXL, the Tools>Options way worked perfectly!!