=Rounddown( not rounding down

Jason P

Hi All.

I have two cells Text/Number each and looking for the average of, but regardless of how I construct the formulas I end up with 35.700%, What I want is 35.7%. Results cell is formatted to % and to the lowest allowable decimal. Have I missed something?

=AVG([Total Activations Yr24]@row, [Completed design tasks]140)

=ROUNDDOWN(AVG([Total Activations Yr24]@row, [Completed design tasks]140) * 100, 1) / 100

=ROUND(AVG([Total Activations Yr24]@row, [Completed design tasks]140) * 100, 1) / 100

Thanks for any help.

SSFeatures

Hi @Jason P,

I just tested this out on my sheet and I think I got it to work the way that you want it.

Incorrect:

=AVG(Value@row, [Value 2]@row) / 100

Now using ROUNDDOWN with 1 decimal place:

=ROUNDDOWN(AVG(Value@row, [Value 2]@row) / 100, 1)

This was bad it made everything after the decimal "00". So I went back to the first formula and adjusted my column's decimal position:

=AVG(Value@row, [Value 2]@row) / 100

I think this 3rd screenshot is what you want? Is this correct?

Jason P

Hi @SSFeatures

Sorted - thank you

SSFeatures

You're welcome!