Rounding Down Formula

L

Lilbit

I have the following formula: =sum(J24/S24). The answer is 22.25%. Once
I've decreased the number of decimals to 1, I need it to read 22.2%. How
do I do this? Thanks!!
 
D

David Biddulph

To start with, why have you used SUM()? What numbers are you trying to add?
If you are dividing, then the formula is =J24/S24.

If you want to round down, rather than round to the nearest, then
=ROUNDDOWN(J24/S24,3)
 
Top