IF Formula Issue

Nicole Hodges · 03/27/20

Hey all!

This is so simple but having issues. I want to show "1" "2" or "3" for "Low" "Medium" "High"

=IF([Level of Change]@row, = Low, "1", IF([Level of Change]@row, = Medium, "2", IF([Level of Change]@row, = High, "3")

What am I missing?!

Debbie Sawyer · 03/27/20

Try

=IF([Level of Change]@row = "Low", 1, IF([Level of Change]@row = "Medium", 2, 3)

That should work :)

Kind regards

Debbie

Paul Newcome · 03/27/20

@Debbie Sawyer is correct. You need to put quotes around the specified text.

"Low"

"Medium"

"High"

Nicole Hodges · 03/27/20

Worked!! I Knew it was something small - thank you SO MUCH!

Debbie Sawyer · 03/30/20

@NBudd You're Welcome - Sometimes you try so many ways of writing the syntax that you forget which bits needs "" and which don't. ;)

Easily done - happy to have helped.

Kind regards

Debbie

Answers