Calculate formula w/in one worksheet but 2 diff. pages

J

JacksGarden

I'm trying to create a formula on Sheet 2 but need to access a field from Sheet 1.
Can't find how to do this via help. Can someone give me the formula.
Thx.
 
F

Frank Kabel

Hi
something like
='sheet1'!A1*B1

or using the mouse:
- enter the equation sign
- select the cell with your mouse
 

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

Calculating nr of books a certain author has published 2
Excel formula help for calculating freight. 2
Using a vlookup to search multiple criteria for one result? 7
Conditional formula with text 1
Excel Formula question 0
Help with a formula for a Time Sheet. 1
Calculate the median value before a specified list 0
Specify MTD Diff by month's columns 0

Top