I have a text in the cell A3 =SCHOOL
I have build a formula in the cell B3
=IFS(A3= “SCHOOL”, “ST. XAVIER”, A3=”COLLEGE” , “OXFORD”)
But the problem is that, the error is coming that ‘SCHOOL’ is a text and cannot be coerced to a number. I want to change the values conditionally. Please help me.
B3 should be OXFORD when the value is in A3 as COLLEGE.
New contributor
Ranjan Kumar Singh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.