Round number to get the whole part
Hi, I have 2 columns: Y is a decimal number, and "#maint. needed" should tell me how many actions I need to do in base on the number before decimals of the Y column #maint. needed = LEFT(ZMPF[Y], 1) What I want is this result: y= 0,005 --> # maint =0 y= 0,9 --> # maint =0 y= 1,8 --> # maint =1 y= 2,99 --> # maint =2 But my maint column is doing, like the picture: y= 0,005 --> # maint =5 y= 0,03 --> # maint =3 I suspect it does that because of the scientific terminology, but I don't know how to fix it.
