| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function Help
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 -- Rick (MVP - Excel) "Stac" wrote in message ... 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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Threaded Mode
