Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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?...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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!

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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")

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you, worked!!