STORN and GETN functions

STORN and GETN supercede the old STOR and GET functions, and should be used instead of STOR and GET in the future.

The STORN function lets you store numbers in any number of memory locations, and GETN lets you retrieve numbers from those memory locations.

Examples:

=STORN(3,12.34) would store the value 12.34 in memory location 3, so then...
=GETN(3) would return the value 12.34

=STORN(6,B17) would store whatever value is in cell B17, in memory location 6, and...
=GETN(6) would return that same numeric value.

Usage Notes

▪Calling STORN 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 GETN any number of times to retrieve the value from that memory location.

▪Any formula involving STORN must appear in the spreadsheet before formulas which call GETN. Otherwise, GETN will return 0 because nothing has yet been stored in that memory location.

See the STOR and GET functions topic for additional usage information.