Forum Discussion
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 per Container]]>=50,"High")))
But I am trying to change it to display text like this.
I tried changing to make it work in to this but it doesn't seam to work.
IF([@[Items per Container]]<=25,TEXT("1""-""25")& "Low",IF(AND([@[Items per Container]]>=26,[@[Items per Container]]<=50),"Medium",IF([@[Items per Container]]>=50,"High")))
Anyone know how I need to change the formula to get the outcome shown in the picture?
Thanks
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
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....
