cancel
Showing results for
Did you mean:
Helper III

## IF statement comparing number and text

I want to create an IF statement that says if the value is greater than 90, then excellent, if it's 80-90, then good...etc.  But keep getting error can't compare numbers and text.  How can I do this?

1 ACCEPTED SOLUTION

Accepted Solutions
Memorable Member

hi @DaisySara - Follow the below steps to compare a %age value and assign a corresponding value

1. You would need to create a calculated column as below:

Check = IF ([%age] > 0.9, "Excellent!!", IF ( [%age] <= 0.9 && [%age] > 0.8 , "Good!!", "Better luck next time!!"))
Note: Ensure that the "%age" column is formatted as a numeric or %age column

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!

5 REPLIES 5
Super User I
you will not be able to compare numbers and text, they are different data types. You will need to convert one of them. Can you you post your if statement please.

Also can you share a screenshot of your data.

Proud to be a Super User!

Helper III

I have a calcuated field with a percentage, and I need to say if it is above this percentage, then assign them a status.  I don't see how I can convert say a percentage of 88.5% into a string and say if it is greater than 88.5 then.....Less than and greater than won't work with a string will it?

Compliance Status = IF(CONVERT([Overall Compliance], string)>"80" , "Excellent", "BOOOOOOOO")

Memorable Member

hi @DaisySara - Follow the below steps to compare a %age value and assign a corresponding value

1. You would need to create a calculated column as below:

Check = IF ([%age] > 0.9, "Excellent!!", IF ( [%age] <= 0.9 && [%age] > 0.8 , "Good!!", "Better luck next time!!"))
Note: Ensure that the "%age" column is formatted as a numeric or %age column

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!

Resolver I

I am able to compare a number and text.

Column = IF('Table'[Percentage] >= 88.5, "Excellent", "Bad")

Helper III

Thank you, worked!!

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Power Platform October Community Highlights

Check out the top community contributors across all of the communities

#### Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors