ExcelBanter - Relative Cell Reference [How To]

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Relative Cell Reference [How To] (https://www.excelbanter.com/excel-programming/373561-relative-cell-reference-%5Bhow-%5D.html)

Rob

Relative Cell Reference [How To]

In VBA I can do a relative cell reference from the currently selected cell by
using...
R[2]C[-4]
.... How do I achive the same thing within a formula?

Thanks,
Rob

JLGWhiz

Relative Cell Reference [How To]

This site might be of help:
http://www.bettersolutions.com/excel...C418316331.htm

"Rob" wrote:

In VBA I can do a relative cell reference from the currently selected cell by
using...
R[2]C[-4]
... How do I achive the same thing within a formula?

Thanks,
Rob

Rob

Relative Cell Reference [How To]

No help what-so-ever. What I'm looking for is something along the lines of...

Formula in cell C4
=IF(ROWS(9)+COLUMNS(-2)="TOOTSIE","BEE-ATCH","YUCK FOU")

Does that help?

Thanks,
Rob

"JLGWhiz" wrote:

This site might be of help:
http://www.bettersolutions.com/excel...C418316331.htm

"Rob" wrote:

In VBA I can do a relative cell reference from the currently selected cell by
using...
R[2]C[-4]
... How do I achive the same thing within a formula?

Thanks,
Rob

All times are GMT +1. The time now is 05:30 PM.