Rounding Down Formula
 

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!!

Rounding Down Formula
 

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)
--
David Biddulph

"Lilbit" wrote in message
lkaboutsoftware.com...
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!!

Rounding Down Formula
 

Perfect!! Thanks ever so much!!!