Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

If statement to give value when between two numbers.

Hi everyone,    Can someone help me come up with a formula to give a categorised value for between numbers.    Rating Ranges: 1-5, 6-10, 11-15, 16-20, 21-25 Categories: Insignificant, Minimal, M...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi danextian 

 

Thank you solved 🙂 

 

danextian's avatar
danextian
Icon for Super User rankSuper User
4 years ago

Hi Anonymous ,

That happens when you're comparing a number against a text  (or vice versa( or using < operator against a text.  What formula did you input?  Have you checked on the PBIX in my other comment?