shrivallabha
Excel Ninja
Agree completely on this.Hi shrivallabha ,
I think I was talking about the entire formula ; if you put in the entire formula in various cells and toggle to R1C1 style of referencing , R1C1 will be the same since it is absolute addressing , but since A1 has been used in a relative style of addressing , it will depend on where you are entering the formula. This is what I wanted to point out.
Narayan