How to coerce text using IFS function in Google Sheets?
I have a text in the cell A3 =SCHOOL
I have built 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.
Solution
you can do:
=IF(A3="SCHOOL", "ST. XAVIER",
IF(A3="COLLEGE", "OXFORD", ))
or:
=SWITCH(A3, "SCHOOL", "ST. XAVIER", "COLLEGE", "OXFORD")
but you can always add (nest) more IF statements:
=IF(A3="SCHOOL", "ST. XAVIER",
IF(A3="COLLEGE", "OXFORD",
IF(A3="xxxxxxx", "yyy", )))
=IF(A3="SCHOOL", "ST. XAVIER",
IF(A3="COLLEGE", "OXFORD",
IF(A3="xxxxxxx", "yyy",
IF(A3="fkhfgkh", "gghjv", ))))
next you can use:
=XLOOKUP(A3, {"SCHOOL", "COLLEGE"}, {"ST. XAVIER", "OXFORD"}, )
or:
=VLOOKUP(A3, {"SCHOOL", "ST. XAVIER";
"COLLEGE", "OXFORD"}, 2, )
- How to combine multiple conditions in a PowerShell if-statement
- I get an error when I end the if statement with a concluding else statement
- Does PHP have short-circuit evaluation?
- Why is this code still adding 1 to i even when the if statment that does so isnt called in C?
- error compiling in c user input
- R Conditional IfElse With Random Values
- Can not get past illogical line pep8 error
- smarty help with if statement
- 'if' must have both main and 'else' branches if used as an expression
- What is the standard for choosing "when" vs "if/else" in Kotlin?
- Python script continuously repeats the first if - else statement
- Why does python use 'else' after for and while loops?
- Use of ternary operator instead of if-else in C++
- Evaluate boolean environment variable in Python
- How to use if/else statement in terraform for loop
- change number grade to letter grade
- How to debug this substring matching code?
- If condition is getting skipped even if the condition is true
- Assign value to all rows based on condition being fulfilled or not
- Looping through a list in Python
- Why does if (fork() || fork() || fork()) behave differently?
- Python if not == vs if !=
- Discord.py | If statement not working correctly
- Angular 17 - In @if syntax, how to store returned value from a function in a variable and use it in the same @if block
- Angular: ng-content doesn't render with *ngIf then else
- How to get the next Bi-weekly date based on a given start date and today's date in Google Sheets
- What is the best way to refactor an if else branch
- Unreachable code in if-else structure
- Python if/else/elif
- Ternary conditional operator in Scala