SOLVED

# IF function to include numbers in displayed result

Copper Contributor

# 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

2 Replies
best response confirmed by JustasG (Copper Contributor)
Solution

# Re: IF function to include numbers in displayed result

@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....

# Re: IF function to include numbers in displayed result

@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

1 best response

Accepted Solutions
best response confirmed by JustasG (Copper Contributor)
Solution

# Re: IF function to include numbers in displayed result

@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....