How do I create a formula using cells from two different sheets?
 

I am trying to create formulas where the resulting data is on one sheet and
the parameters are on another sheet. I want to create something like this:
Sheet 1 cell A1*sheet 2 cell A1=Sheet 1 cell B1

How do I create a formula using cells from two different sheets?
 

Hi Elaine

in Sheet 1 cell B1 enter following formula:
=Sheet1!A1*Sheet2!A1

you can tell excel with a ! to which sheet the cell refers to.

hth

Carlo

"Elaine Z" wrote:

I am trying to create formulas where the resulting data is on one sheet and
the parameters are on another sheet. I want to create something like this:
Sheet 1 cell A1*sheet 2 cell A1=Sheet 1 cell B1

How do I create a formula using cells from two different sheets?
 

=Sheet2!B1*Sheet2!B2
Put this in Sheet1, cell A1 (or anywhere else for that matter) and the
result will be Sheet2, cell B1 multiplied by Sheet2, cell B2.
You can type it manually or in the cell you want the result, enter an
'Equals' (=) sign, then select the cell in the other sheet, go back to the
original sheet and enter the multiplication sign (*) in the formula bar then
select the other cell in the other sheet and Excel will do it for you.
Regards,
Alan.
"Elaine Z" <Elaine wrote in message
...
I am trying to create formulas where the resulting data is on one sheet and
the parameters are on another sheet. I want to create something like
this:
Sheet 1 cell A1*sheet 2 cell A1=Sheet 1 cell B1