Truncation formula help needed

[colleenmquinn]

I need help to multiply the contents of 2 cells and display result truncated to 5 decimal places. I want to do this in a single cell not multiple cells/steps

 

[Veritan]

Are you talking about merely displaying the result to 5 decimal places or actually changing the value so that it doesn't have any more than 5 digits? If you're just displaying it, you can use the Increase/Decrease Decimal buttons in the Number group under the Home tab. If you're wanting to limit the result to 5 decimals, you could use the ROUND, ROUNDUP, or ROUNDDOWN functions. For example:

=ROUND(3.14159*RAND(),5)

The 5 at the end forces the result to be rounded to 5 digits or less.

 

[colleenmquinn]

I need help to multiply the contents of 2 cells and display result truncated to 5 decimal places. I want to do this in a single cell not multiple cells/steps

I need truncation to 5 decimal places not rounding. If I use the increase / decrease decimal places that rounds your result.
Thanks for trying.

 

[Peter_SSs]

Welcome to the MrExcel board!

Do you need this?
=TRUNC(A1*B1,5)

If not, please provide some sample data and the expected results with any further explanation.