Offset values

[maartenvanbenthem]

Offset values

[maartenvanbenthem]

And offset in percentages is not working as expected.

[thenikso]

hmm interesting. the code seams fine. perhaps you could add a jsbin (for example based on this) to show off the problem?

[ianldgs]

Negative values in percentage are also not working.

[Khaos-Storm]

I too have found that OFFSET doesn't work when it points to a cell that calculates a percentage. Frustrating limitation, but my work around has been to create a second column that just points to the cell that does the calculation. Then I point my offset to the cell that just has the value, rather than the calculation for percentage.

Example: Let's say column A is date, column B is my total, and column C is my partials. Column D calculates that row for C/B, and shows a percentage.
If my OFFSET points to a cell in column D, it will just return 0.
So my workaround was to create a column E that just points to the calculated value in column D. Then setup my OFFSET so that it points to E.

-Silly limitation to run into.