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 Peace be upon you, sir. I hope you are well. If you're interested in this formula, perhaps I can be of assistance? It is: =IF(C2<=25,"Low",IF(C2<=50,"Medium",IF(C2>50,"High"))). I would be grateful if you could remember me in your prayer