Differences

This shows you the differences between two versions of the page.

--- start:calculated_fields [2016/08/29 11:04]
rnadler
+++ start:calculated_fields [2016/08/29 11:06]
rnadler
@@ Line 10: / Line 10: @@
 **Calculations**:  =r2c2*r2c3/200  or = r1c1/r1c4*100%  (the percent sign is optional and will add a % sign to the result)
+**If else logic**: =(if(r2c2==0) s = 0; else if(r2c2 >= 1) s=2; else s = 3;
 Note about row and column references:  The tables include a column and row for table labels.  These are row 1 and column 1.  When referencing cells the first textbox cell is typically r2c2.