Forum Discussion
Truncating a numeric result
I have a formula (=G2*0.96) that results in a number such as 35.17243. How do I truncate that result to 35.1 without it rounding up to 35.2?
Hi Steven,
It is
=TRUNC(G2*0.96,1)
I have a formula (=G2*0.96) that results in a number such as 35.17243. How do I truncate that result to 35.1 without it rounding up to 35.2?
Hi Steven,
It is
=TRUNC(G2*0.96,1)
