Relative references

G

Guest

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)
 
G

Guest

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
 
G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing relative references 1
Range of cells: Convert relative reference into absolute 5
relative defined name references? 1
convert relative cell references to absolute cell references via amacro? 1
Change ref type 3
Absolute References 3
Switch between relative, absolute, and mixed references 3
sum by conditional formatted color 2

Top