Forum Discussion
Custom Column Help
Hi y'all, I am trying to create a custom column that will take the range of numbers from my column A and spit out a specific output. For example, everytime column A lists number between 1-10 I wa...
If you merely remove the "number" and the parentheses everywhere, it will work!
--Nate
You didn't ask, but your else if clauses could be more efficient; no need for "and":
if [A] = 100 then "100" else if [A] > 75 then "76-99" else if [A] > 50 then "51-75" else if [A] > 25 then "26-50" else if [A] > 10 then "10-25" else if [A] > 0 then "1-10" else if [A] = 0 then "0" else "Unknown"
--Nate
Watsky
Solution Sage
Solution SageHey Anonymous ,
It seems to be working fine for me using :
=if [Number] > 0 and [Number] < 11 then "1-10" else if [Number] > 10 and [Number] < 26 then "11-25" else if [Number] > 25 and [Number] < 40 then "26-40" else "NO"What are you listing the word number for in your code was it to say something along the lines of if this value is a number which is greater than 0...?
Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up! ?
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.