Relative references

S

smaruzzi

Can anyone please show me an example of a formula with relative references
rather than absolute?

Thanls, Stefano
 
B

Bob Phillips

=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)
 
S

smaruzzi

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
 
S

Stefi

Tools/Options/General/R1C1 reference style

Regards,
Stefi


„smaruzzi†ezt írta:
 
B

Bob Phillips

=OFFSET(A1,3,-2)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top