ReBecca, try this, =Sheet2!B1/Sheet2!A1

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"ReBecca" wrote in message
...
Hi guys, how can I have formula on one sheet that refers to values on
another
sheet within the same workbook?

Eg sheet one has formula b1/a1- but the values refer to the cells in sheet
two, but the answer is in sheet one.

thanks in advance