Truncating a numeric result

Copper Contributor

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?

1 Reply

Hi Steven,

 

It is

=TRUNC(G2*0.96,1)