Does the formula for approximating down exists on adalo?
yes
I tested the Round function in Adalo with 8.43 and 8.46 and they both were rounded down to 8, 8.66 rounds to up. So rounds down or up to Integer using scientific notation.
Here is more detailed information about the math formulas: How to Create a Custom Math Formula - Adalo Resources
“Round” will round the number up or down based on the integer.
With Round:
4.3 would round down to 4
4.4 would round down to 4
4.5 would round up to 5
4.6 would round up to 5
I believe the function you’re looking for is Integer (INT). Integer removes any values beyond the decimal point.
With Integer:
4.3 would round down to 4
4.4 would round down to 4
4.5 would round down to 4
4.6 would round down to 4
This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.