Hi -
I have a column {Count of Amounts Paid of $250+} and I want to divide it by 9 because the number of scholarships available is determined at 1 after every 9 enrollments that are $250 and over. In an adjacent field - but because, for example, 51 divided by 9 is 5.6666666667 I want also want to ROUNDDOWN so that the scholarship fiel doesn’t display more scholarships than are actually available (only when it gets to numbers evenly divisible by 9. For the scholarshps field I tried:
ROUNDDOWN({Count of Amounts Paid of $250+}/9)
but I get an error message. I imagine my syntax is off in someway but I can’t figure it out. Thanks for any help you can offer!
Solved
ROUNDDOWN of field with simple division
Best answer by Justin_Barrett
Welcome to the community, @EduCareDo! :grinning_face_with_big_eyes: The ROUNDDOWN() function requires two arguments, but yours only has one. The second one is supposed to be the precision (i.e. how many decimal places) to use for the rounding operation. In your case, you want it to round to whole numbers, so your formula would be:
ROUNDDOWN({Count of Amounts Paid of $250+}/9, 0)
+20Welcome to the community, @EduCareDo! :grinning_face_with_big_eyes: The ROUNDDOWN() function requires two arguments, but yours only has one. The second one is supposed to be the precision (i.e. how many decimal places) to use for the rounding operation. In your case, you want it to round to whole numbers, so your formula would be:
ROUNDDOWN({Count of Amounts Paid of $250+}/9, 0)
Justin_Barrett wrote:
Welcome to the community, @EduCareDo! :grinning_face_with_big_eyes: The ROUNDDOWN() function requires two arguments, but yours only has one. The second one is supposed to be the precision (i.e. how many decimal places) to use for the rounding operation. In your case, you want it to round to whole numbers, so your formula would be:
ROUNDDOWN({Count of Amounts Paid of $250+}/9, 0)
Ah, that’s it, thank you! I’m at the beginning of of my airtable and formula-making journey as you can probably tell from my question. Thanks so much!
+20Glad to know that you got the answer you were seeking! If you would, please mark my answer above as the solution to your question. This helps others who may be searching with similar questions. Thanks!
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.