| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula equals cell directly above
Hi
Just wondering if there is a formula like ... 'the cell alway equals the one above it' no matter where it is pasted to apart from A3 = A2 because if i use this formula and if the row above is deleted it doesn't adjust. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula equals cell directly above
Hi
Try this: =OFFSET(A6,-1,0) Andy. "Lynne......" wrote in message ... Hi Just wondering if there is a formula like ... 'the cell alway equals the one above it' no matter where it is pasted to apart from A3 = A2 because if i use this formula and if the row above is deleted it doesn't adjust. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula equals cell directly above
Hi Andy,
That worked ! Thank you "Andy" wrote: Hi Try this: =OFFSET(A6,-1,0) Andy. "Lynne......" wrote in message ... Hi Just wondering if there is a formula like ... 'the cell alway equals the one above it' no matter where it is pasted to apart from A3 = A2 because if i use this formula and if the row above is deleted it doesn't adjust. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| assign formula to another cell | Excel Worksheet Functions | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
Linear Mode
