Off the top of my head, this should do what you're looking for.
=IF(A1=1,100,IF(A1=4,200,IF(A1=6,300,IF(A1=10,400,0))))
Broken down into pseudo code:
IF
A1=1
THEN
100
ELSE
IF
A1=4
THEN
200
ELSE
IF
A1=6
THEN
300
ELSE
IF
A1=10
THEN
400
ELSE
0
To do it with IFS, this should do:
=IFS(A1=1, 100, A1=4, 200, A1=6, 300, A1=10, 400, true, 0)
SWITCH would be this:
=SWITCH(A1, 1, 100, 4, 200, 6, 300, 10, 400, 0)
Google Sheets functions:
- IF()
- IFS()
- SWITCH()
Google Support
support.google.com › docs › answer › 7014145
IFS function - Google Docs Editors Help
IF: Returns one value if a logical expression is `TRUE` and another if it is `FALSE`.
W3Schools
w3schools.com › googlesheets › google_sheets_ifs.php
Google Sheets IFS Function
GS Sort GS Sort Sheet GS Sort By ... The IFS function is a premade function in Google Sheets, which returns values based on one or more true or false conditions....
Simplify Data Organization with the IFS Function in Google ...
19:44
IF IFS LET Functions - Excel & Google Sheets - YouTube
How to Use the IFS Formula in Google Sheets
06:43
How to Use IF and IFS Functions in Google Sheets Fast! - YouTube
07:05
IFS Function in Google Sheets Explained Simply! - YouTube
Google Sheets IFS Function
Ben Collins
benlcollins.com › home › ifs function in google sheets
IFS Function in Google Sheets
June 20, 2024 - Google Sheets and Workspace Updates ... it) The IFS function in Google Sheets is used to test multiple conditions and outputs a value specified by the first test that evaluates to true....
Stack Overflow
stackoverflow.com › questions › 77157181 › how-to-combine-ifs-and-and-formula-in-google-sheets
if statement - How to combine IFS and AND formula in Google Sheets? - Stack Overflow
=IFS(A2="ABC","100",B2="ABC","50",C2="ABC","50",AND(B2="ABC",C2="CBA","100"))
Sheetgo
sheetgo.com › home › how to use the ifs function in google sheets
How to use the IFS function in Google Sheets - Sheetgo
December 3, 2020 - The IF function in Google Sheets enables logical decision making with a simple if-else structure. It checks whether a condition in a cell is true or false.
Owox
owox.com › blog › articles › google sheets tips › how to use the ifs function in google sheets for advanced conditional logic
Master Google Sheets IFS Function: Advanced Guide for 2025
May 14, 2026 - The IFS function in Google Sheets can be used to evaluate sales team performance based on predefined criteria, categorizing performance and assigning grades based on numerical thresholds.
Reddit
reddit.com › r/googlesheets › how can i combine an "ifs" and "and" statement to check for to conditions?
r/googlesheets on Reddit: How can I combine an "IFS" and "AND" statement to check for to conditions?
August 22, 2021 -
Hi I recently started using google sheets to make a travel plan budget cost. I was wondering if you could combine an IFS statement with an AND to test for two conditions (another cell and a checkbox). So basically it checks for a number on another cell and if a checkbox is checked. I want to check the conditions at the same time so it returns one value.
Ive tried to use the statement but it gives me a "formula parse error" (the F9 cell is a checkbox):
=IFS (E9=B2 AND F9=TRUE, C2*B2)
I've used other coding languages but I don't know if this is possible for google sheets. Does anyone have any suggestions or another operator I could use?
Top answer 1 of 3
4
The AND is a function. So =IFS(AND(E9=B2,F9), C2*B2) would work. If F9 is already a bool(TRUE/FALSE) no need to check if it is equal to TRUE.
2 of 3
2
Since AND is not supported by ArrayFormulas it's better to do this with boolean logic. TRUE * TRUE = TRUE TRUE * FALSE = FALSE IFS is not needed for multiple condition checks, IF will be fine. You can do it like this: =IF( (E9=B2) * F9, C2*B2 , ) Checked checkboxes returns TRUE, so '=TRUE' can be omitted. (Positive numbers will be treated as TRUE.)
Medium
medium.com › @gaillereports › google-sheets-full-overview-of-if-ifs-and-and-or-formulas-2e7f61c6b8e9
Google Sheets - Full Overview of IF, IFS, AND and OR formulas | by Gala Ivannikova | Medium
April 25, 2025 - That’s pretty much the formula ... OR formula in Google Sheets is used to test multiple conditions and returns TRUE if at least one of the conditions is met; otherwise, it returns FALSE....
Google Sheets
sheets-pratique.com › en › functions › ifs
Google Sheets Function: IFS
The IFS function evaluates multiple conditions and displays a value corresponding to the first true condition...
LiveFlow
liveflow.com › product-guides › how-to-use-ifs-function-in-google-sheets
How to Use IFS Function in Google Sheets | LiveFlow
The IFS formulas in Column D next to the Sales Amount test the Sales Amounts and drop them to the right place.
Google Support
support.google.com › docs › answer › 3093364
IF function - Google Docs Editors Help
Returns one value if a logical expression is `TRUE` and another if it is `FALSE`. Sample Usage IF(A2 = "foo","A2 is foo") IF(A2,"A2 was true","A2 was false") IF(TRUE,4,5) Syntax IF(logical_expre
Layer
golayer.io › home › if statement in google sheets: formula & examples
IF Statement in Google Sheets: Formula & Examples | Layer Blog
July 17, 2024 - For example, to return “Yes” or “No” depending on whether an amount is greater than or equal to $4000, you can use the following formula: =IF(B2>=4000,”Yes”,”No”). Open Google Sheets to the spreadsheet with your data. In the ‘Bonus’ column, type the IF function in the row for the first amount.
Facebook
facebook.com › muo.official › posts › these-5-excel-functions-are-silently-slowing-down-your-spreadsheets-use-these-in › 1398756922293746
These 5 Excel functions are silently slowing down your ...
MUO. 468,078 likes · 6,614 talking about this. MakeUseOf is a digital publication that launched in 2006. Our experts help teach readers to master everything from phones and laptops to software and...
Better Sheets
bettersheets.co › formulas › ifs
How to Use IFS() function in Google Sheets · Better Sheets
IFS() is a logical Google Sheets formula that Evaluates multiple conditions and returns a value that corresponds to th...
Sheetgo
sheetgo.com › home › mastering the ifs formula: simplify conditional logic in google sheets
Mastering the IFs formula: simplify conditional logic in Google Sheets - Sheetgo
June 3, 2025 - Learn to use the IFS formula in Google Sheets to simplify conditional logic for inventory, grading, sales, and more with practical examples.
The Bricks
thebricks.com › home › resources › how to use the if function in google sheets using ai
How to Use the IF Function in Google Sheets Using AI
April 22, 2025 - The logic is straightforward: IF a certain condition is true, THEN do one thing, otherwise, (ELSE) do something else. This is invaluable for automating tasks like categorizing data, calculating bonuses, or flagging items that need attention.
Sheetgo
sheetgo.com › home › how to use the if function in google sheets
How to use the IF function in Google Sheets - Sheetgo
December 17, 2025 - Again, in simple terms, I’m telling the function “Evaluate if B2 is 0, if it’s TRUE output ‘No experience’, if it’s FALSE continue to the next IF statement. Evaluate if B2 is less than 4, if it’s TRUE output ‘Some experience’, if it’s FALSE output ‘Lots of experience’ ”. The AND and OR logical functions in Google Sheets can be used in combination with the IF function.
LinkedIn
linkedin.com › pulse › how-use-ifs-function-google-sheets-engineering-news-learning-le8kf
How to use the IFS Function in Google Sheets
Login to LinkedIn to keep in touch with people you know, share ideas, and build your career.