Application to update if statement bins/buckets from user input

Hi - I have attached an example of a process to create limits profiles out of of values. Essentially the formula tool uses an if statement to "bin" or "bucket" the limits into several categories/ranges. However, if a user wants to update this they will need to manually do so in the formula.

I'm familiar with creating applications and have made a few, but I'm wondering if there's a way to create an application that allows a user to input an excel file that has a list of the ranges they would like, and to have that update the formula tool accordingly.

Any help would be greatly appreciated.

Thank you!

test_limitsprofiles.yxzp

Apps

Accepted answers

ArtApa

Hi @aweldon1 - Please find attached app that will read ranges from a file that then are used to apply conditions. I'm not a big fan of long "if-then-else" statements though.

test_limitsprofiles AA.yxzp

All comments

ArtApa

Hi @aweldon1 - Please find attached app that will read ranges from a file that then are used to apply conditions. I'm not a big fan of long "if-then-else" statements though.

test_limitsprofiles AA.yxzp

aweldon1

This is perfect, thank you! I have a couple questions, if you don't mind:

How would you handle a category like "Greater than 500,000". Would you have to set the Limit End to an extremely large number to fit into the if statement, or is there a way to work in some sort of "infinite" Limit End?
What do you not like about the "if else" statements? Is there an alternate route you would take?

Thanks again, this was so helpful!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703