Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

IF function to include numbers in displayed result

Copper Contributor

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.

JustasG_0-1705912853400.png

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

@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

1 best response

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

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

 

 

View solution in original post