If an or function to write a number value from a text in a cell next to it

%3CLINGO-SUB%20id%3D%22lingo-sub-1313993%22%20slang%3D%22en-US%22%3EIf%20an%20or%20function%20to%20write%20a%20number%20value%20from%20a%20text%20in%20a%20cell%20next%20to%20it%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1313993%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%26nbsp%3B%3C%2FP%3E%3CP%3ECell%201B%20is%20empty.%20Cell%201C%20has%20one%20of%205%20text%20values.%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22119%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22119%22%3EVery%20Satisfied%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3Ewill%20equal%201%3C%2FP%3E%3CTABLE%20width%3D%22119%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22119%22%3ESatisfied%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3EWill%20equal%20exc...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can%20do%20an%20if%20with%20one%20value.%20How%20do%20I%20get%20all%20five%20values%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1313993%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1315147%22%20slang%3D%22en-US%22%3ERe%3A%20If%20an%20or%20function%20to%20write%20a%20number%20value%20from%20a%20text%20in%20a%20cell%20next%20to%20it%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1315147%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F625234%22%20target%3D%22_blank%22%3E%40Peter61965%3C%2FA%3E%26nbsp%3BPerhaps%20something%20like%20in%20the%20attached%20file.%20If%20not%2C%20please%20clarify%20your%20needs.%20What%20combination%20of%20IF%20and%20OR%20did%20you%20have%20in%20mind%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

 

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? 

 

 

2 Replies
Highlighted

@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?

Highlighted

@Riny_van_Eekelen  I did not think of a table. This will work for what I want. 

 

Thank you.