STORT and GETT functions

Top  Previous  Next

The STORT function lets you store text in any number of memory locations, and GETT lets you retrieve the text stored in those memory locations.

Examples:

=STORT(4,"John Doe") would store "John Doe" in memory location 4, so then...
=GETT(4) would return "John Doe"

=STORT(6,E17) would store whatever text is in cell E17, in memory location 6, so then...
=GETT(6) would return that same text

Usage Notes

Calling STORT for any particular memory location should generally only be done once (i.e., in one formula cell) in the FormCalc SST spreadsheet. However, you may call GETT any number of times to retrieve the text from that memory location.

Any formula involving STORT must appear in the spreadsheet before formulas which call GETT. Otherwise, GETN will return "" (nothing) because nothing has yet been stored in that memory location.