if and roundup formulas

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

numfon_naka_0-1679971688098.png

 

0 1 49
1 REPLY 1

DECIMAL(CEILING(value * 100)) / DECIMAL(100)

 

Top Labels in this Space