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, )
- Python if/else/elif
- Ternary conditional operator in Scala
- Does the java compiler understand conditions given in if statements?
- Allow simple if statement without else to have no braces in codestyle
- Is using if (0) to skip a case in a switch supposed to work?
- Multiple Condition IF Statement in ARRAY formula EXCEL
- Condition if-else
- Use of inline if/then/else in Javascript
- Python If Statement definition error
- Else-statement after while-statement, and string comparison with a list of strings?
- If statement with or (||) argument does not work with in_array method
- If loop with two conditions
- Using or in if statement (Python)
- Evaluate boolean environment variable in Python
- Flake8 error: E712 comparison to True should be 'if cond is True:' or 'if cond:'
- IF/OR Formula, Compound to Simplified | I want to simplify, narrow down, and have an evolving cell as information is updated on the Excel sheet
- Excluding Named Worksheets from a Loop
- How to comment an obsolete else-case?
- break out of if and foreach
- Is there a better method than nested if/then to evaluate if cells in one set of columns has data, and then populate a different set of columns
- Using table of same dimensions
- Python Todo List not Adding New Todo in New Row, Rather It Is Appending on the Same Line as Previous Todo
- Array Formula to omit certain values
- Using If statement, to get one String, to pass into API call
- I want to show the available times as bold and unavailable times (strike) in label with corresponding to API data
- How to set "safeAreaInset" under a condition (if clause)
- R If then do - how to create variables based on the condition
- How to sum up checkboxgroupinput objects in R shiny?
- How to check if an object is within an array's objects values?
- Read multiple excel files to dataframes using for loop by reading the month in each filename