Multiple dropdown selection and perform some operation

i am having 3 field
Stipend Amount | Semester(dropdown with multiple selection) | value(want formula)
1)25000 | fall,spring(have selected multiple option in dropdown) | 2500(stipend amount/10) and if there is only one selection than (stipend/5)
2)25000 | fall(single value selected) | 5000(stipend amount/5)
need help to get value
Answers
-
So you want to divide the Stipend Amount by (5,000 * number of selections)?
Give this a try:
=[Stipend Amount]@row / (5000 *COUNTM(Semester@row))
-
no i have solve it but if there is any alternative way for this formula
=IF(AND(HAS(Semester@row, "Fall"), HAS(Semester@row, "Spring"), HAS(Semester@row, "Summer I"), HAS(Semester@row, "Summer II")), [Stipend/Award Amount]@row / 12, IF(AND(HAS(Semester@row, "Fall"), HAS(Semester@row, "Spring"), HAS(Semester@row, "Summer I")), [Stipend/Award Amount]@row / 11,Β
IF(AND(HAS(Semester@row, "Fall"), HAS(Semester@row, "Spring"), HAS(Semester@row, "Summer II")), [Stipend/Award Amount]@row / 11,Β
IF(AND(HAS(Semester@row, "Fall"), HAS(Semester@row, "Summer I"), HAS(Semester@row, "Summer II")), [Stipend/Award Amount]@row / 11,Β
IF(AND(HAS(Semester@row, "Fall"), HAS(Semester@row, "Spring")), [Stipend/Award Amount]@row / 10,Β
IF(AND(HAS(Semester@row, "Fall"), HAS(Semester@row, "Summer I")), [Stipend/Award Amount]@row / 6,
IF(AND(HAS(Semester@row, "Fall"), HAS(Semester@row, "Summer II")), [Stipend/Award Amount]@row / 6,Β
IF(AND(HAS(Semester@row, "Fall")), [Stipend/Award Amount]@row / 5, 0))))))))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 205 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!