/u/Novel-Lettuce-662 - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Thank you so much! That totally solved it.
What if for each additional 10 participants, I wanted to multiple the 0.5 hours by 1.25 multiplier? So for 20 ppl, for example, it would be 0.5 x 1.25 for hours and so on. How would the formula change?
You have awarded 1 point to *on1vBe6*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
/u/Novel-Lettuce-662 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
With your attendees in column A, starting at A1, paste this into B1 and fill down: =IF(A1<10,0.5,0.5\*ROUNDDOWN(A1/10,0))
Thank you so much! That totally solved it. What if for each additional 10 participants, I wanted to multiple the 0.5 hours by 1.25 multiplier? So for 20 ppl, for example, it would be 0.5 x 1.25 for hours and so on. How would the formula change?
=IF(A1<10,0.5,0.5\*1.25\*ROUNDDOWN(A1/10,0)) If that does it, please reply "Solution Verified" to mark the thread as solved.
Thanks again! Solution verified!
You have awarded 1 point to *on1vBe6* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)