=IF assistance (beginner/novice)

Question

Good afternoon. Trying to state, IF Communication Column is "5 - excellent", then communication rating is a 5. I've written the code below however '5' is not populating. Any thoughts to the formula or should I make Communication column read 'Excellent' only that then converts to a '5' rating?

=IF(Communication@row = "5-EXCELLENT", 5, IF(Communication@row = "4 - Good", 4, IF(Communication@row = "3 - Average", 3, IF(Communication@row = "2 - Poor", 2, IF(Communication@row = "1 - Very Poor", 1)))))

Hannah H · Accepted Answer

Hi Hilda,

It looks like your error is coming from your first IF statement. Your logical expression is for 5 - EXCELLENT however you have written it as "5-EXCELLENT" in your formula. Add in a space to either side  of the dash and the formula will work.

Best,

Hannah