Help

The Community will be undergoing maintenance on Friday January 10 at 2:00pm - Saturday January 11 at 2:00pm EST, and will be "read-only." For assistance during this time, please visit our Help Center.

Re: Compound IF statement

675 0
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sean_Finnigan
4 - Data Explorer
4 - Data Explorer
See Solution in Thread

‎May 01, 2018 08:16 PM

I am trying to write a statement that can assign a value to the cell by evaluating content value from another column (PM), and this is what I’ve got:

IF(PM= “value1”, 1, IF(PM= “value2”, 2, IF(PM= “value3”, 3, IF(PM= “value4”, 4, IF(PM= “value5”, 5, IF(PM= “value6”, 6, “”)))))

I’m getting an error. Can someone help me debug this? THANKS

0 Kudos
Reply
1 Reply 1
Jeremy_Oglesby
14 - Jupiter
14 - Jupiter
See Solution in Thread

‎May 01, 2018 10:33 PM

Looks like you were just missing one closing parenthesis at the end:

IF(PM="value 1", 1, IF(PM="value 2", 2, IF(PM="value 3", 3, IF(PM="value 4", 4, IF(PM="value 5", 5, IF(PM="value 6", 6, ""))))))
0 Kudos
Reply
Copyright © 2025 Khoros, LLC