IF Function help

✭✭✭✭
edited 12/09/19

I am attempting to use a nested IF statement that assigns a number based on a dropdown selection.

Example: User chooses "Medium" in the Impact column, and I'd like to assign a value to that selection in the next column.

=IF([Care Training Impact]1 = High, "60", IF([Care Training Impact]1 = Medium, "35", "2"))

I receive an 'unparseable' error. Any thoughts on what can be done to return what I am looking for?

• ✭✭✭✭✭✭

High and Medium should be in quotes like this:

=IF([Care Training Impact]1 = "High", "60", IF([Care Training Impact]1 = "Medium", "35", "2"))

Also, if you want those values to be actual numbers... remove the quotes around the numbers like this...

=IF([Care Training Impact]1 = "High", 60, IF([Care Training Impact]1 = "Medium", 35, 2))

That way the numbers won't be converted to text and will be able to be summed or used in calculations without converting them back into numbers.

• ✭✭✭✭✭✭

=IF([Care Training Impact]1 = "High", 60, IF([Care Training Impact]1 = "Medium", 35, 2))

• ✭✭✭✭

Thanks, I finally have a number showing!

Issue now: When I change the dropdown value from Medium to High, Low or None, the number doesn't change. Anything I'm missing?

• ✭✭✭✭✭✭

=IF([Care Training Impact]@row = "High", 60, IF([Care Training Impact]@row = "Medium", 35, 2))

It might be that your formula is still looking at row 1 but you've placed it in a different row.

• ✭✭✭✭✭✭

Adding @row instead of a specific row number will look at the columns for the current row you are on.

• ✭✭✭✭

This worked perfectly, thank you!!

• ✭✭✭✭✭✭

Great! I'm glad I could be of assistance.