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