Hello, complete newbie here.
I want to build a formula for reading a chart and automatically updating a field according to the chart.
For example, if number is between 1 and 5, use field1.
If number is between 6 and 15, use field 2.
If number is between 16 and 30, use field 3.
etc.
If number is greater than 100, use this formula.
I know this can be done, I just don't know how to do it. Please help!
Thank you.
Bookmarks