Referencing sheets

  • Thread starter Thread starter Sly929
  • Start date Start date
S

Sly929

ok, I need some major help. I am referencing sheet1 which I named "Raw"
which is only raw data, on Sheet2(sort) I want to make this statement.
if there is a number in the cell that I am referencing from raw, then
fill in a cell on my sort sheet with that number, but if there is not a
number in the raw sheet than fill in with 0's
 
='Raw'!A1

should do it, if the cell is empty you always get a zero, if not you get
what's in the cell
 
Back
Top