This question about **Using an extension**: Answered

--

SinanGUL - 24 Jan 2018

# TABLE 1

#

# TABLE 2

Could you please help me to write the calculation ( %CALC {...% ) formulations of "TABLE 1 cells" to "TABLE 2 cells as described. Thanks in advance for your support.

--

SinanGUL - 24 Jan 2018

I know my above question is really beginner level question to foswiki gurus, especially while their agendas is full of developing tasks&issues. But for now, this is my question and still needs your support.

--

SinanGUL - 24 Jan 2018

Here is a bit of a tutorial starting with how to reference an individual cell, and how to do calculations, finishing with a couple of columns from your example:

Reference to a single cell is done with

`$T(Rn:Cn)`

So this example uses

`%CALC{"$T(R1:C1)"}%`

to access Row 1 Column 1.

However to be flexible, you might want to reference columns in "this row", without having to enter an explicit row number.

`$ROW()`

returns the absolute row number, so replace the row number with

`R$ROW()`

to reference to cells in "this" row. This example uses

`%CALC{"$T(R$ROW():C1)"}%`

To make calculations, you use the

`$EVAL()`

function. For example, to multiple Column 1 times 2:

--

GeorgeClark - 24 Jan 2018

## FİYAT TEKLİFİ DETAYI

I would like to thank so much to

GeorgeClark for helping me to learn such kind above formulations.

--

SinanGUL - 30 Jan 2018