Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to create a formala in one sheet for a cell in another sheet?
I need to set up a formula in one sheet to appertain to a cell in another
sheet of the same workbook. is this possible if so how? Ant help would be great thanks |
#2
|
|||
|
|||
How to create a formala in one sheet for a cell in another sheet?
=IF(Sheet2!A10,1,0)
as an example, easiest way is actually to use the mouse and select the cell(s) on the other sheet, that way sheet names will be inserted automatically -- Regards, Peo Sjoblom "Beth" wrote in message ... I need to set up a formula in one sheet to appertain to a cell in another sheet of the same workbook. is this possible if so how? Ant help would be great thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking a dinamic cell value from one sheet to another | Excel Discussion (Misc queries) | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Need formula for sheet & cell reference | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |