Average Children and Round Down

Options
✭✭✭✭✭✭

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

• ✭✭✭✭✭✭
Options

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)

• ✭✭✭✭✭✭
Options

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

• ✭✭✭✭✭✭
edited 01/28/21
Options

I want it to Round down to 6%

• ✭✭✭✭✭✭
Options

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)

• ✭✭✭✭✭✭
Options

Missing the Value 2. That worked , Thanks

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!