if statement for blank cell

[steve hill]

Hi I have a sheet column C contains a formula +wo 1'!n1 this looks a cell on sheet wo 1 what I want to do id if cell B is blank enter 0 if not pull in n1 from sheet wo 1

thanks

steve

 

[Gerald Higgins]

Hi, your request is a bit vague, but perhaps something like

=if(isblank(B1),0,+'wo 1'!n1)

 

[steve hill]

Hi, your request is a bit vague, but perhaps something like

=if(isblank(B1),0,+'wo 1'!n1)

thanks Gerald that's worked a treat
steve