Try this one:
=IF(or(and(B1>43%, B1<57%, A1=2016),and(B1 >57%, A1=2016,istext(E1))), "ID",)
Google
docs.google.com › spreadsheets › create
Google Sheets: Sign-in
Access Google Sheets with a personal Google account or Google Workspace account (for business use).
Google Support
support.google.com › docs › answer › 3093301
AND function - Google Docs Editors Help
The AND function returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false. Sample Usage AND(A2 = "foo", A3 = "bar") AND(TRUE,
Inline operators such as "&" or "+"
You can see a list of "operators" in google sheets at: https://support.google.com/docs/table/25273?hl=en In the filter section, go to 'Narrow By' and select "Operator". Then do a browser search for "Equivalent to" to find all the operators that have an inline symbol equivalent. Unfortunately, I suspect you won't find anything particularly novel. But I agree that the inline symbols are often easier to read than the function style operator. (And, sorry to not answer your question, I don't have a wonderful search term for you ...) Also, I asked gemini for you: what inline operators work in google sheets expressions There's actually only one inline operator that works directly within Google Sheets expressions for basic operations: Concatenation (& symbol): This operator allows you to join multiple strings together. For instance, ="Hello" & " World" will return "Hello World". While there are other operators used in formulas (like +, -, *, / for math), these aren't considered inline operators and require specific functions for string manipulation. Here's a quick recap: Inline Operator: & (ampersand) for string concatenation Functions needed for other operations: Functions like LEFT, RIGHT, MID, FIND, SEARCH, REPLACE, UPPER, LOWER, etc. are used for tasks like extracting text, searching/replacing within strings, or case manipulation. More on reddit.com
9
2
June 5, 2024if statement - combining IF, AND, OR expressions in Google Sheets - Stack Overflow
Bring the best of human thought and AI automation together at your work. Explore Stack Internal ... Save this question. Show activity on this post. I have written the following function in google sheets in order to add "ID" to a column: More on stackoverflow.com
What are things like " ' & * % $ called in Google Sheets?
Yes, notation or syntax. They have different characteristics in different situations. That reference a value in a cell A1 business in QUERY() is tricky. Try some examples from a web search and you'll pick it up quick enough, also how QUERY() handles dates would be well worth studying. One key to understanding QUERY() is the query has its own language and it is created as a string. So a series of text linked with the & would be valid. Or any other way you can put strings together, like CONCATENATE() or JOIN() More on reddit.com
5
1
June 16, 2022How to use AND in Google sheets? - Stack Overflow
I am currently having hard time creating a formula for my sheet to record values when the following conditions will be met: I want to give 15% discount from the original price if a Person purchased... More on stackoverflow.com
How to Use AND Function in Google Sheets [2026 Full Guide]
30:31
Google Sheets Basics - AND/OR in Functions | Technology Education ...
03:43
How to Use AND and OR in Google Sheets | Logical Function Tutorial ...
03:42
Google Sheets AND() Function Tutorial: How to Use the AND Function ...
04:25
Google Sheets | IF | AND | Function | Use Multiple Conditions | ...
Google Workspace
workspace.google.com › products › sheets
Collaborative, AI-powered spreadsheets | Google Workspace
3 days ago - Build spreadsheets, visualize data in mini-apps, and fill data in seamlessly. Take your data beyond the grid with Sheets canvas.
Ben Collins
benlcollins.com › home › the and function in google sheets
The AND Function in Google Sheets
March 18, 2022 - The AND function in Google Sheets is a logical function that outputs TRUE if all of the inputs are TRUE, and FALSE otherwise.
Reddit
reddit.com › r/googlesheets › inline operators such as "&" or "+"
r/googlesheets on Reddit: Inline operators such as "&" or "+"
June 5, 2024 -
Apologies for this being a bit more meta than most posts, but I've run into these a couple times and was wondering if there was a better, more SEO-friendly name for them than "in-line operators", and if there was a list of them somewhere that I could bookmark/reference rather than comb through all the documentation.
for those less familiar, & is in-line concatenation so
-
CONCAT("cat","dog") -> "catdog"
-
+"cat"&"dog" -> "catdog"
and + is in-line ... range merging? set joining? I'm not sure, I only use it in "FILTER" to make logical-or combos of constraints (so "copy the rows where col A is 'R' or 'C'" gives the formula +FILTER(A2:Z,(A2:A = "R")+(A2:A = "C") )
Anyhow:
What's the official, searchable name for these operators? Is there a list of them somewhere?
Top answer 1 of 3
3
You can see a list of "operators" in google sheets at: https://support.google.com/docs/table/25273?hl=en In the filter section, go to 'Narrow By' and select "Operator". Then do a browser search for "Equivalent to" to find all the operators that have an inline symbol equivalent. Unfortunately, I suspect you won't find anything particularly novel. But I agree that the inline symbols are often easier to read than the function style operator. (And, sorry to not answer your question, I don't have a wonderful search term for you ...) Also, I asked gemini for you: what inline operators work in google sheets expressions There's actually only one inline operator that works directly within Google Sheets expressions for basic operations: Concatenation (& symbol): This operator allows you to join multiple strings together. For instance, ="Hello" & " World" will return "Hello World". While there are other operators used in formulas (like +, -, *, / for math), these aren't considered inline operators and require specific functions for string manipulation. Here's a quick recap: Inline Operator: & (ampersand) for string concatenation Functions needed for other operations: Functions like LEFT, RIGHT, MID, FIND, SEARCH, REPLACE, UPPER, LOWER, etc. are used for tasks like extracting text, searching/replacing within strings, or case manipulation.
2 of 3
1
I believe the term you are looking for is "operator overloading". I wouldn't categorize that usage the + as the same as the &. That's more about being a "trick" to emulate OR() because boolean values are just 0 or not-0.
Google Play
play.google.com › store › apps › details
Google Sheets - Apps on Google Play
1 week ago - Create and edit online spreadsheets with Google Sheets, part of Google Workspace
YouTube
youtube.com › watch
How to Combine Logic with the AND Function in Google Sheets | Gaille Reports - YouTube
How to Combine Logic with the AND Function in Google SheetsUnlock the full potential of Google Sheets by mastering the AND function! 💡 In this tutorial, you...
Published: February 3, 2025
Google Support
support.google.com › docs › table › 25273
Google Sheets function list - Google Docs Editors Help
You can change the language of Google Sheets functions between English and 21 other languages.
Softr
softr.io › home › blog › 100 google sheets formulas that actually work: a cheat sheet
How to use AND in Google Sheets - Guide
July 23, 2026 - Combines "Hello" and "World" into "Hello World". Using CONCATENATE in a Google Sheet.
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 - The AND formula in Google Sheets is used to evaluate multiple conditions and return TRUE only if all the conditions are met. It’s a logical function that helps you test whether multiple criteria are simultaneously true.
W3Schools
w3schools.com › googlesheets › google_sheets_or.php
Google Sheets OR Function
GS Sort GS Sort Sheet GS Sort By Range GS Sort Range GS Conditional Formatting GS Single Color Formatting GS Color Scale Formatting · AND AVERAGE AVERAGEIF AVERAGEIFS COUNT COUNTA COUNTBLANK COUNTIF COUNTIFS IF IFS MAX MEDIAN MIN MODE OR STDEV.P STDEV.S SUM SUMIF SUMIFS VLOOKUP XOR ... The OR function is a premade function in Google Sheets, which returns TRUE or FALSE based on two or more conditions.
Sheetgo
sheetgo.com › home › how to use the google sheets and function
How to use the Google Sheets AND function - Sheetgo
March 17, 2017 - The AND function in Google Sheets accepts logical expressions as input arguments, then evaluates them as TRUE or FALSE.
Reddit
reddit.com › r/googlesheets › what are things like " ' & * % $ called in google sheets?
r/googlesheets on Reddit: What are things like " ' & * % $ called in Google Sheets?
June 16, 2022 -
Want to read up on the functions of these things, to really understand when and why to use ""A1"" in a sumif like this or '"&A1' like that in a query formula to look up data that contain the text in A1 - for example.
I know that ? * ~ are called wildcards. But what are " ' & % $ called?
Top answer 1 of 5
3
Yes, notation or syntax. They have different characteristics in different situations. That reference a value in a cell A1 business in QUERY() is tricky. Try some examples from a web search and you'll pick it up quick enough, also how QUERY() handles dates would be well worth studying. One key to understanding QUERY() is the query has its own language and it is created as a string. So a series of text linked with the & would be valid. Or any other way you can put strings together, like CONCATENATE() or JOIN()
2 of 5
2
I’ve always referred to it as syntax I guess.
Google Support
support.google.com › docs › answer › 6000292
How to use Google Sheets - Computer - Google Docs Editors Help
Google Sheets is an online spreadsheet app that lets you create and format spreadsheets and work with other people.
Top answer 1 of 2
2
Your formula is almost correct except for the AND operator, the syntax for using AND is as follows: AND(logical_expression1, [logical_expression2, ...]).
I have replicated your data and fix the formula. Please see formula and desired output below
Formula:
=IF(AND(B2=TRUE,D2>50),(E2*0.85),E2)
Data and Output:
References:
https://support.google.com/docs/answer/7014145 https://support.google.com/docs/answer/3093301?hl=en
2 of 2
0
use:
=INDEX(IF(B2:B="",,IF((B2:B=TRUE)*(D2:D>50), (E2:E*0.85), E2:E))
Google
essentials.withgoogle.com
Google Sheets
Google Sheets helps you track, organize and analyze your data on any device. Format and polish data with a few clicks, collaborate in real-time and input accurate, rich data using smart chips for names, files, dates, dropdown menus, events and more.
Reddit
reddit.com › r/googlesheets › if, and function problems in my spreadsheet
r/googlesheets on Reddit: IF, AND function problems in my spreadsheet
March 18, 2023 -
Hi,
Im hoping someone might be able to point me in the right direction to make my formula work.>>>
___________________
If (C2 is NOT EMPTY) and (C2-I2 is =>0) then (make A2 green) and (uncheck D2) and (make E2 Empty) and (B3=C2-I2) and (A3=C2+I2)
___________________
The above is what I want to happen, but i'm not sure which cells have to have which functions...
Thanks
Stack Overflow
stackoverflow.com › questions › 74723062 › if-if-or-and-if-statements-google-sheets
IF & IF OR & AND IF Statements (Google Sheets) - Stack Overflow
Trying to create an automated checker. If people choise the rights answers from a Dropdown box they will see the msg: "You May Now Consult" if not they will see "You shall not pass&q...
Google Support
support.google.com › docs › thread › 132394436 › google-sheets-query-how-to-use-and-and-or-at-the-same-time
Google Sheets QUERY - how to use AND and OR at the same time - Google Docs Editors Community
Skip to main content · Google Docs Editors Help · Sign in · Google Help · Help Center · Community · Google Docs Editors · Terms of Service · Submit feedback · Send feedback on