Thread: How do I create a formula using cells from two different sheets?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carlo Carlo is offline
external usenet poster
  
Posts: 179
Default 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
Reply With QuoteReply With Quote