Concat With Format

[aspnetlearning]

Hi,
I want the formula in concat result with 2 digits after comma. But all zeros are coming. How can I do it?

x1=0
d3=83.40
c3=6.85
result= 76.55000000000001 g/l add
<input type="text" data-format="0,0[.]00" data-cell="A3" data-formula='IF(X1> 0,IF(D3<C3,"Techinal",CONCAT(D3*X1*0.001-C3*X1*0.001,"kg. add ")),IF(D3<C3,"Techinal",CONCAT(D3-C3," g/l add")))'></input>

Thanks

[ikhsan017]

Hi @aspnetlearning

Maybe you can combine it with ROUND ?

like CONCAT(ROUND(D3-C3, 2)," g/l add")

Regards,
Ikhsan