Function Help

S

Stac

I am trying to divide 2 numbers on page 1 of workbook and have the resultant
on page 2 of same workbook (ex: A2/A9 = answer on page 2 at A2). Any
suggestions?
 
O

Otávio Alves Ribeiro

Hi there.
Please, try putting in cell A2 of page 2:

=Page1!A2/Page1!A9

Where Page1 is the name of your first sheet, as it appears on the sheet tab.
Regards,
Otávio
 
P

Pete_UK

Put this in A2 on sheet2:

=Sheet1!A2/Sheet1!A9

You put the formula in the cell where you want the result to be
displayed, and if the formula refers to a cell on another sheet then
you have to include a reference to the sheet name - with apostrophes
around it if it contains space(s).

Hope this helps.

Pete
 
R

Rick Rothstein

On **sheet** 2, put this formula in the cell you want the division result to
be in...

=Sheet1!A2/Sheet1!A9

where Sheet1 is the worksheet name containing the A2 and A9 cells you want
to reference (change it in my formula as necessary). If your sheet names
have spaces in them, then surround the sheet name with apostrophes; for
example, if your sheet were named "Sheet One", then the above formula would
be...

='Sheet One'!A2/'Sheet One'!A9
 

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

Top