Average Children and Round Down

Anthony Barthelemy

Good Day All:

Can someone help me Structure this Formula so when I Calculate the Average for all Children it is Rounded Down?

Existing Formula Yield 0.00%:

=ROUNDDOWN(AVG(CHILDREN()))

Thanks

Paul Newcome

Ah. Ok. Percentages are actually calculated as decimals (a percentage of 1). So 6% is actually .06 which does round down to zero. You will want to leverage the second portion of the ROUNDDOWN function to include the number of decimal places. Try starting with a 2.

=ROUNDDOWN(AVG(CHILDREN()), 2)

Paul Newcome

What should it be? Are you able to provide a screenshot of the source data?

Anthony Barthelemy

I want it to Round down to 6%

Paul Newcome

Ah. Ok. Percentages are actually calculated as decimals (a percentage of 1). So 6% is actually .06 which does round down to zero. You will want to leverage the second portion of the ROUNDDOWN function to include the number of decimal places. Try starting with a 2.

=ROUNDDOWN(AVG(CHILDREN()), 2)

Anthony Barthelemy

Missing the Value 2. That worked , Thanks

Paul Newcome

Happy to help. 👍️