About 1,648,750 results (1,711 milliseconds)
How can I search in a cell for a word in a sentence, and if it find it ...
https://support.google.com/docs/thread/147050478/how-can-i-search-in-a-cell-for-a-word-in-a-sentence-and-if-it-find-it-then-write-a-certain-word?hl=en Jan 21, 2022 ... So if it search and finds "Pencil" then I want it to write a certain word, for example: "Yes there is a pencil". Is that posible? What formula ...
Adding the MID formula to ARRAYFORMULA to extract data ...
https://support.google.com/docs/thread/102469798/adding-the-mid-formula-to-arrayformula-to-extract-data?hl=en Mar 16, 2021 ... If I could tease your brain one more time, I added a second sample sheet to the one you replied on. I was given a new spreadsheet similar to ...
ISERROR - Google Docs Editors Help
https://support.google.com/docs/answer/3093349?hl=en Checks whether a value is an error. Sample Usage ISERROR(A2) ISERROR(A1/A2) IF(ISERROR(VLOOKUP(B1, A1:A100, 1, FALSE)), "Result not found", VLOOKUP(B1, ...
Summing range with if error values, sum not including if error value ...
https://support.google.com/docs/thread/11102017/summing-range-with-if-error-values-sum-not-including-if-error-value?hl=en Aug 1, 2019 ... What formula would you use to ensure that it's including the "iferror" value. ... I tried this formula, =ArrayFormula(SUM(IF(ISERROR(P3:P36) ...
Create & use named functions - Google Docs Editors Help
https://support.google.com/docs/answer/12504534?hl=en If you want to take in various inputs to your function, when you write a named function, you must define argument placeholders. ... Definition: =IF(ISERROR(FIND(" ...
How to list all staff names that are contained in a list - Google Docs ...
https://support.google.com/docs/thread/82348915/how-to-list-all-staff-names-that-are-contained-in-a-list?hl=en Nov 11, 2020 ... =if(iserror(ARRAYFORMULA(TEXTJOIN(", ",1,QUERY({B$6:B$14},"where ... For example, if the staff name is Doe, Jane would you want all of ...
IFERROR - Google Docs Editors Help
https://support.google.com/docs/answer/3093304?hl=en Sample Usage. IFERROR(A1,"Error in cell A1 ... value_if_error - [ OPTIONAL - blank by default ] - The value the function returns if value is an error.
Conditional formatting across all sheet tabs. - Google Docs Editors ...
https://support.google.com/docs/thread/7895637/conditional-formatting-across-all-sheet-tabs?hl=en Jun 12, 2019 ... Format cells if... Custom Formula is... Formula: =NOT(ISERROR(SEARCH(INDIRECT("Info!A1",A1,1))). Format: <format of your choice, purple in ...
How to create a current streak formula for checkboxes - Google ...
https://support.google.com/docs/thread/205966250/how-to-create-a-current-streak-formula-for-checkboxes?hl=en Mar 13, 2023 ... I have managed to do so for daily habits, using this formula: =if(iserror(match(true,D5:D369,0)),0 ...
Compare 2 sheets for similarities and differences even if on different ...
https://support.google.com/docs/thread/10262301/compare-2-sheets-for-similarities-and-differences-even-if-on-different-rows?hl=en Jul 20, 2019 ... Check C formula. ={{"Row","No Match C"};ArrayFormula(. query(if(Sheet1!C1:C="",,if(iserror(. vlookup(Sheet1!C1:C,Sheet2!C1:C,1,false)),. {row ...
REGEXMATCH string against column/range of data - Google Docs ...
https://support.google.com/docs/thread/159773469/regexmatch-string-against-column-range-of-data?hl=en Apr 13, 2022 ... =if(iserror(MATCH(CONCAT(B2,"`"),Sheet2!A4:A13,0)),"No it doesn't ... If you move the formula over to cell B4, you should see the ...
Copying values with checkboxes causes missing inputs. - Google ...
https://support.google.com/docs/thread/262971589/copying-values-with-checkboxes-causes-missing-inputs?hl=en Mar 8, 2024 ... This way, contributors can test their formulas and see if their formula results match your desired results. Cheers --Hyde. Original Poster ...
How to disable annoying log warnings?
https://groups.google.com/g/microsoft.public.excel.charting/c/YPCJmsAIB0s Aug 22, 2000 ... =IF(ISERROR(LOG([my formula])),NA(),[my formula]). The NA() produces ... > If there are only zeros, and no blanks, you can write a couple
Deleting a referenced range does not refresh formula - Google Docs ...
https://support.google.com/docs/thread/87070782/deleting-a-referenced-range-does-not-refresh-formula?hl=en Dec 5, 2020 ... It should simply properly evaluate the ISERROR formula since that should catch the error. And i know the formula works, because when i force re- ...
IFERROR showing 12 for blank cells (month) - Google Docs Editors ...
https://support.google.com/docs/thread/63056568/iferror-showing-12-for-blank-cells-month?hl=en Aug 5, 2020 ... Thank you for the sample sheet. When it comes to dates blank cells are seen as 0 date or 12/30/1899 so then with the MONTH() formula you will ...
FILTER returning #REF! error when theres is no results - Google ...
https://support.google.com/docs/thread/292198613/filter-returning-ref-error-when-theres-is-no-results?hl=en Aug 21, 2024 ... LucasOliveira wrote: The actual formula is longer, this is a sketch with 3 tables. The formula in my answer shows how ...
Strikethrough based on if other cells say "No"? - Google Docs ...
https://support.google.com/docs/thread/172033131/strikethrough-based-on-if-other-cells-say-no?hl=en Jul 21, 2022 ... Example Spreadsheet: https://docs.google.com/spreadsheets/d ... Use conditional formatting > custom formula =NOT(ISERROR(MATCH("No ...
How do I create a cell that displays a 1 if a row of cells contains a ...
https://support.google.com/docs/thread/13140713/how-do-i-create-a-cell-that-displays-a-1-if-a-row-of-cells-contains-a-value-0-if-not-contained?hl=en Aug 30, 2019 ... =IF(ISERROR(MATCH(A1;B1:B10;0));"Not found";"Found"). I changed the ... sample and someone might provide an array style formula. Else ...
Returning all but the first entry of a sorted, filtered range - Google ...
https://support.google.com/docs/thread/7101940/returning-all-but-the-first-entry-of-a-sorted-filtered-range?hl=en May 31, 2019 ... Its formula is =IF(NOT(ISNA(VLOOKUP(1,A3:A,1,FALSE))),MIN ... if(iserror( vlookup(D3:D,(B1+B3:B)&A3:A,1,false)),. {A3:A,B3:B+1},{A3 ...
Set up conditional formatting that is also case sensitive - Google ...
https://support.google.com/docs/thread/225325361/set-up-conditional-formatting-that-is-also-case-sensitive?hl=en Jul 13, 2023 ... C2:F, and formulas from other places refer/lookup/query this data. I've noticed query is case sensitive, so if a name doesn't exactly match ...