About 1,751,731 results (1,225 milliseconds)
IF function - Google Docs Editors Help
https://support.google.com/docs/answer/3093364?hl=en 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 ...
Using IF Function to Search Entire Column - Google Docs Editors ...
https://support.google.com/docs/thread/65148450/using-if-function-to-search-entire-column?hl=en Aug 16, 2020 ... ... sheet? Also, it would be great if I didn't have to delete the class info or have an exact match. For example, not all students take Honors ...
Google Sheets function list - Google Docs Editors Help
https://support.google.com/docs/table/25273?hl=en Google Sheets supports cell formulas typically found in most desktop spreadsheet packages. Functions can be used to create formulas that manipulate data and ...
IF Function not registering true - Google Docs Editors Community
https://support.google.com/docs/thread/108559317/if-function-not-registering-true?hl=en May 3, 2021 ... (fig 1)However, the IF registers the value as false, even when it's not. For example, when cell=1, "built", "not built", and even when the value ...
IFS function - Google Docs Editors Help
https://support.google.com/docs/answer/7014145?hl=en Evaluates multiple conditions and returns a value that corresponds to the first true condition. Sample Usage IFS(A1>90, "A", A1>80, "B", A1>70, ...
if function with indirect cells. - Google Docs Editors Community
https://support.google.com/docs/thread/16247325/if-function-with-indirect-cells?hl=en Oct 7, 2019 ... Would you also please show examples of what your are envisioning for your file? It is unclear how you are wanting the sheet to work. Thanks ...
Nested If function stops operating. - Google Docs Editors Community
https://support.google.com/docs/thread/186317632?hl=en&msgid=186342132 Oct 30, 2022 ... Thank you for your quick response, I am very grateful. I am happy to share the spreadsheet here, as trying to put it into the Sample Spreadsheet ...
How can I make Google Sheet evaluate my if function continuously ...
https://support.google.com/docs/thread/74622920/how-can-i-make-google-sheet-evaluate-my-if-function-continuously?hl=en Oct 2, 2020 ... My Product Codes section has "Y" or "N" restriction for each product. This changes everyday. For example, Product A can have "Y" restriction ...
Google Sheets: IF function and conditional formatting - Google Docs ...
https://support.google.com/docs/thread/317529901/google-sheets-if-function-and-conditional-formatting?hl=en Jan 8, 2025 ... If you need more help, please share a sample spreadsheet that shows realistic-looking sample data and manually enter an example of the ...
How to nest 'IF' function within Query function? - Google Docs ...
https://support.google.com/docs/thread/71940506/how-to-nest-if-function-within-query-function?hl=en Sep 18, 2020 ... So I need the query function to include a function that searches through the BV column. Hi Clayton,. Thank you for sharing a sample spreadsheet.
Trying to use an IF function with multiple check boxes. - Google ...
https://support.google.com/docs/thread/272135998/trying-to-use-an-if-function-with-multiple-check-boxes?hl=en Apr 30, 2024 ... Using the Custom formula is option. =H3="NOT CLEARED". Click here to see my example in your spreadsheet. I hop this helps,. Ben Liebrand. 5 More ...
Nest If Function Into Query with Multiple Perameters? - Google Docs ...
https://support.google.com/docs/thread/342740566/nest-if-function-into-query-with-multiple-perameters?hl=en May 6, 2025 ... I'm also getting stuck on the query aspect, as I need it to match the rate with the role. Any help would be appreciated, here is my sample ...
False Return on IF Function - Google Docs Editors Community
https://support.google.com/docs/thread/46178559/false-return-on-if-function?hl=en May 12, 2020 ... Make sure that your sheet has a good example of your question and does NOT have any confidential or personal information in it. From within the ...
Help with the IF function and returning a value based upon two ...
https://support.google.com/docs/thread/156908440/help-with-the-if-function-and-returning-a-value-based-upon-two-criteria-being-met?hl=en Mar 23, 2022 ... I am using Google Sheets and I need to create a formula that returns ... Use your sample sheet to demonstrate what you'd like the sheet to do!
sum values of multiple if functions - Google Docs Editors Community
https://support.google.com/docs/thread/199191356/sum-values-of-multiple-if-functions?hl=en Jan 27, 2023 ... But when I SUM these cells, all I get is 0 (instead of 26 in the example). I think because of the If function, the output is seen as text ...
Result of an IF formula is greyed out & underlined & add into SUM ...
https://support.google.com/docs/thread/37302557/result-of-an-if-formula-is-greyed-out-underlined-add-into-sum-as-an-empty-cell?hl=en Apr 1, 2020 ... If you'd like help entered directly on a Google Sheet, from me or ... As Lance noted, please share an editable sample sheet highlighting your ...
Nested If Statement with 3 or more Named Ranges Used, AND ...
https://support.google.com/docs/thread/148751878/nested-if-statement-with-3-or-more-named-ranges-used-and-adding-rows-after-array-entry?hl=en Jan 31, 2022 ... There is no such limit in Google Sheets formulas or named ranges ... See the new Solution sheet in your sample spreadsheet for an illustration.
Help with IF and IFS functions ? - Google Docs Editors Community
https://support.google.com/docs/thread/4247625/help-with-if-and-ifs-functions?hl=en Apr 15, 2019 ... Example: Cells A# will be for units and B# will be for fix prices ... I tried several options using IF function, IFS, but I cannot make it work.
Trouble using the IF function with text - Google Docs Editors ...
https://support.google.com/docs/thread/283240292/trouble-using-the-if-function-with-text?hl=en Jul 2, 2024 ... For example, if I have a cell that says Boston, MA; New York, NY then I want another cell to show as EC. I am wondering if I can put in a ...
replicating excel's textjoin with an IF function - Google Docs Editors ...
https://support.google.com/docs/thread/201897402/replicating-excel-s-textjoin-with-an-if-function?hl=en Feb 14, 2023 ... ... sheet. Use your sample sheet to demonstrate what you'd like the sheet to do! Here are some tips to help you get a great answer quickly ...