Referencing sheets

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
 
P

Peo Sjoblom

='Raw'!A1

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

need help on either doing a loop and counting specific values orusing subtotal function 2
Excel 2010 countifs for date range 3
If and Vlookup 3
Need Help with a VBA subroutine 0
Getpivot data not referencing properly 0
Formating bolded text exclusively. 0
HELP! Lookup, countif or if statement 3
Separate raw data onto different worksheets 4

Top