Forum Discussion
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?...
hi Anonymous - 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 columnPlease mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!
hi Anonymous - 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!
Thank you, worked!!