Apr 16 2020 01:24 PM
Example
Cell 1B is empty. Cell 1C has one of 5 text values.
Very Satisfied |
will equal 1
Satisfied |
Will equal exc...
I can do an if with one value. How do I get all five values?
Apr 17 2020 01:21 AM
@Peter61965 Perhaps something like in the attached file. If not, please clarify your needs. What combination of IF and OR did you have in mind?
Apr 17 2020 05:49 AM