| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Relative references
Can anyone please show me an example of a formula with relative references
rather than absolute? Thanls, Stefano |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Relative references
=IF(D1<10,B1,C1)
but I don't think that is telling you much. The difference is if you put that formula in A1, and then copy it to A2, A2 will then be =IF(D2<10,B2,C2) whereas if you start with =IF($D$1<10,$B$1,$C$1) copying it down to A2 will result in the same formula in A2 as in A1. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "smaruzzi" wrote in message ... Can anyone please show me an example of a formula with relative references rather than absolute? Thanls, Stefano |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Relative references
Bob,
i meant something dofferent: is there a way to reference a cell not in absolute terms such as A1 or B10, but rather as 3 rows down and 2 columns left? tso "Bob Phillips" wrote: =IF(D1<10,B1,C1) but I don't think that is telling you much. The difference is if you put that formula in A1, and then copy it to A2, A2 will then be =IF(D2<10,B2,C2) whereas if you start with =IF($D$1<10,$B$1,$C$1) copying it down to A2 will result in the same formula in A2 as in A1. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "smaruzzi" wrote in message ... Can anyone please show me an example of a formula with relative references rather than absolute? Thanls, Stefano |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Relative references
Tools/Options/General/R1C1 reference style
Regards, Stefi €žsmaruzzi€ť ezt Ă*rta: Bob, i meant something dofferent: is there a way to reference a cell not in absolute terms such as A1 or B10, but rather as 3 rows down and 2 columns left? tso "Bob Phillips" wrote: =IF(D1<10,B1,C1) but I don't think that is telling you much. The difference is if you put that formula in A1, and then copy it to A2, A2 will then be =IF(D2<10,B2,C2) whereas if you start with =IF($D$1<10,$B$1,$C$1) copying it down to A2 will result in the same formula in A2 as in A1. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "smaruzzi" wrote in message ... Can anyone please show me an example of a formula with relative references rather than absolute? Thanls, Stefano |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Relative references
=OFFSET(A1,3,-2)
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "smaruzzi" wrote in message ... Bob, i meant something dofferent: is there a way to reference a cell not in absolute terms such as A1 or B10, but rather as 3 rows down and 2 columns left? tso "Bob Phillips" wrote: =IF(D1<10,B1,C1) but I don't think that is telling you much. The difference is if you put that formula in A1, and then copy it to A2, A2 will then be =IF(D2<10,B2,C2) whereas if you start with =IF($D$1<10,$B$1,$C$1) copying it down to A2 will result in the same formula in A2 as in A1. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "smaruzzi" wrote in message ... Can anyone please show me an example of a formula with relative references rather than absolute? Thanls, Stefano |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Relative, absolute & mixed references in many cells | Excel Worksheet Functions | |||
| Named formulas in CHOOSE need to be Relative references when paste | Excel Worksheet Functions | |||
| I want chart source data to be relative references, not absolute. | Charts and Charting in Excel | |||
| Confused about relative references in named formulas | Excel Worksheet Functions | |||
| Averaging using relative references across sheets | Excel Discussion (Misc queries) | |||
Hybrid Mode
