address gnumeric cell with calculated address
 

I need to compute the address of a cell in a formula. So a cell has a number in it. I want to compute address=(number-1)*6+4) and then make that into a cell address like B(address).
I can't figure out if there is a syntax to express that in gnumeric.
Any ideas?
Thanks,
Jon

 

Try searching for "address" in the Gnumeric Manual...

Well, that brings up email addresses, there doesn't seem to be a search specific to gnumeric, it searches all of Gnome.
Is there a better place to ask Gnumeric questions?
Thanks,
Jon

 

That's Gnome stupid website design.

On the page I linked, use Ctrl-F to get the browser's in-page search, (or use the contents menu to go to section "A.11. Lookup").

Well, address seems to convert a cell address into text. What i WANT is to get the VALUE of a cell by using numbers from some cell as the address.
Thanks,
Jon

These may help....

http://www.gnumeric.org/

https://help.gnome.org/users/gnumeri.../gnumeric.html

If you mean what I think you mean..

Go to the cell, click the = sign, at the top of sheet, go to the cell holding the number, click it, it will appear at the top, insert -1, then *6, then +4, then hit the 'tick'.

To get the contents of a dynamic cell address, use the INDIRECT function.

To get the the contents of a cell from a particular range by using column/row numbers, there's the INDEX function.

To do something similar but different, it'll be one of the other functions in the Lookup category.

Thanks Boughtonp, indirect does seem to be what I'm looking for! I will have to learn the proper syntax for it, but it should work.
Thanks,
Jon

Thanks again, boughtonp, combining indirect and concatenate allowed me to assemble the cell references with the arithmetic to select the cells required! I now have the data being extracted from the disjoint lines of entered data.

It looks like this: =indirect(concatenate("B",(A910-1)*6+4)
Jon