Forum Discussion
Solved
IF function to include numbers in displayed result
Morning, I have this function that creates new category's for my data. IF([@[Items per Container]]<=25,"Low",IF(AND([@[Items per Container]]>=26,[@[Items per Container]]<=50),"Medium",IF([@[Items pe...
JustasG All you want is to return a text like "1-25 Low" rather than just "Low", so change the formula to part to:
IF([@[Items per Container]]<=25, "1-25 Low", IF etc....
JustasG All you want is to return a text like "1-25 Low" rather than just "Low", so change the formula to part to:
IF([@[Items per Container]]<=25, "1-25 Low", IF etc....