Home

Truncating a numeric result

%3CLINGO-SUB%20id%3D%22lingo-sub-282289%22%20slang%3D%22en-US%22%3ETruncating%20a%20numeric%20result%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-282289%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20formula%20(%3DG2*0.96)%20that%20results%20in%20a%20number%20such%20as%2035.17243.%20How%20do%20I%20truncate%20that%20result%20to%2035.1%20without%20it%20rounding%20up%20to%2035.2%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-282289%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-282348%22%20slang%3D%22en-US%22%3ERe%3A%20Truncating%20a%20numeric%20result%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-282348%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Steven%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20is%3C%2FP%3E%0A%3CPRE%3E%3DTRUNC(G2*0.96%2C1)%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Highlighted
Steven Zlokovich
Occasional Visitor

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
Highlighted

Hi Steven,

 

It is

=TRUNC(G2*0.96,1)