Average Children and Round Down
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
Best Answer

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)
Answers

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

I want it to Round down to 6%

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)

Missing the Value 2. That worked , Thanks
Help Article Resources
Categories
Check out the Formula Handbook template!