F(C6="","",ROUNDUP(SUM(L6:N6),2))
C6 = Output
L6:N6 = Worker , Leader , Supv. in the field of Actual
But in the app we will use abbreviations. Because we will also make a template, so we use abbreviations instead.
C6 = Out put
Worker = wk.2
leader = ld2
supv = sp.2
How can we modify this formula?
=IF(C6="","",ROUNDUP(SUM(L6:N6),2))
You can't try to do this.
if(
[output]="","",
Round(sum[wk.2][ld2][sp.2]),2
) )
I need a formula similar to excel. and round the decimal
such as
1.231 will be rounded to 1.24
1.230 will be rounded to 1.23
1.23001 will be rounded to 1.24.
excel example
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |