My goal is to create a list that when data is inputted it will break down the list to show >100/>500/<500 instead of the standard numbers. When I say the standard numbers I mean that every different value becomes a list option, I want to group certain sections. The data inputted will range from $50-$8000+. My question is, what parameters do I input into the list function to allow me to view 3 options which will give me the value specified within those options. 
I know I might have to input two or three “IF” or “logical” formulas into one list option. I hope someone understands my question, thank you for your time. If there is a different way to solve this without adding cells please let me know.
I know I might have to input two or three “IF” or “logical” formulas into one list option. I hope someone understands my question, thank you for your time. If there is a different way to solve this without adding cells please let me know.
