开发者

How to use CELL function inside OFFSET function?

开发者 https://www.devze.com 2023-03-17 04:39 出处:网络
I am trying below formula: OFFSET(CELL(\"address\"), 0, -2, 1, 1) Instead this works: OFFSET($P$20开发者_如何学JAVA, 0, -2, 1, 1)

I am trying below formula:

OFFSET(CELL("address"), 0, -2, 1, 1)

Instead this works:

OFFSET($P$20开发者_如何学JAVA, 0, -2, 1, 1)

I do not have the cell reference and so have to compute in formula itself. How to do it?

Thanks in advance!

Niraj


If you want to replace $P$20 by a string you compute, use

.... INDIRECT(function) ....

where function returns an A1-style or R1C1-style address (in the latter case you specify a second arg FALSE

0

精彩评论

暂无评论...
验证码 换一张
取 消