Referencing a cell on a different sheet

thetank

Board Regular
Joined
Mar 17, 2005
Messages
142
I am trying to reference a cell on a separate sheet. If the cell I am referencing is blank, the cell I want the information to be inputed into returns a 0.

How can I make it reference the cell and return the info but if the referenced cell is blank, leave the requested cell blank as well?

Thanks
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
How's this: =IF(Sheet2!A1="",0,Sheet2!A1)

Hope that helps,

Smitty
 

Watch MrExcel Video

Forum statistics

Threads
1,118,110
Messages
5,570,250
Members
412,313
Latest member
pauloalex
Top