This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
start:calculated_fields [2016/08/29 11:03] rnadler |
start:calculated_fields [2016/08/29 11:06] rnadler |
||
---|---|---|---|
Line 7: | Line 7: | ||
The follow options are supported by entering the syntax below into the cell to be calculated: | The follow options are supported by entering the syntax below into the cell to be calculated: | ||
- | Summation: | + | **Summation**: =sum(r2c2: |
- | Calculations: | + | **Calculations**: =r2c2*r2c3/ |
+ | |||
+ | **If else logic**: =(if(r2c2==0) s = 0; else if(r2c2 >= 1) s=2; else s = 3; | ||
Note about row and column references: | Note about row and column references: |