G Guest Oct 9, 2006 #1 Can anyone please show me an example of a formula with relative references rather than absolute? Thanls, Stefano
Can anyone please show me an example of a formula with relative references rather than absolute? Thanls, Stefano
B Bob Phillips Oct 9, 2006 #2 =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)
=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 Oct 9, 2006 #3 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, 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 Oct 9, 2006 #4 Tools/Options/General/R1C1 reference style Regards, Stefi „smaruzzi†ezt Ãrta:
B Bob Phillips Oct 9, 2006 #5 =OFFSET(A1,3,-2) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
=OFFSET(A1,3,-2) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
