About 1,320,575 results (1,032 milliseconds)
Formula to return if cell is blank (no visible text) vs contains formula ...
https://support.google.com/docs/thread/168620875/formula-to-return-if-cell-is-blank-no-visible-text-vs-contains-formula-value?hl=en Jun 24, 2022 ... I am trying to use a simple function to return one value if true and another if false. I have a few columns, all containing a formula.
Conditional formatting, highlight row if cell contains substring ...
https://support.google.com/docs/thread/7025381/conditional-formatting-highlight-row-if-cell-contains-substring?hl=en May 29, 2019 ... ... put the custom formula in conditional formatting as =$C2="Apples". However, I want the rule to apply to any row in which the C column contains ...
how to determine whether a cell contains a formula
https://groups.google.com/g/exceldna/c/87Qi8Q5sVq4 Oct 5, 2010 ... return "Formula: " + XlCall.Excel(XlCall.xlfGetFormula, arg) + ... For example, if a cell, say cell A3, contains a function, "=ABS(B6) ...
How to write a formula that will check whether a cell contains ...
https://support.google.com/docs/thread/261465984/how-to-write-a-formula-that-will-check-whether-a-cell-contains-reference-to-the-current-month?hl=en Feb 29, 2024 ... sample bird spreadsheet. Here's the formula: =Filter(ArrayFormula(iferror(if(FIND("Feb",Sheet1!$C$2:$C$50)>0,{Sheet1!$A$2:$A$50,Sheet1!$D$2 ...
Sheets QUERY (Select, Where, Contains, Limit) that works, except ...
https://support.google.com/docs/thread/22302561/sheets-query-select-where-contains-limit-that-works-except-when-blank-cell?hl=en Dec 8, 2019 ... Sheets QUERY (Select, Where, Contains, Limit) that works, except when blank cell. Hi all,. I have a google sheets QUERY formula that pretty much ...
Use conditional formatting rules in Google Sheets - Computer ...
https://support.google.com/docs/answer/78413?hl=en&co=GENIE.Platform%3DDesktop Cells, rows, or columns can be formatted to change text or background color if they meet certain conditions. For example, if they contain a certain word or a ...
Conditional formatting formula '=if contains' - Google Docs Editors ...
https://support.google.com/docs/thread/187820549/conditional-formatting-formula-if-contains?hl=en Nov 9, 2022 ... Conditional formatting formula '=if contains'. Hey! I have column A containing product name. Range B1:F1 contains notes about product ...
excel - How to SUMPRODUCT cells that contain formulas - Stack ...
http://feedproxy.google.com/~r/microsoft/pTwW/~3/jCRC5kQ2F0k/how-to-sumproduct-cells-that-contain-formulas Feb 17, 2013 ... So, what I need is to show SUMPRODUCT of two cell ranges? Both of these cell ranges, that is, each cell contains formula in it. From this ...
Sheets trying to "If A1 contains XYZ, write B1 to F1" - Google Docs ...
https://support.google.com/docs/thread/180394622/sheets-trying-to-if-a1-contains-xyz-write-b1-to-f1?hl=en Sep 21, 2022 ... So... any help on the magic formula that I can put into F1 to accomplish this, and then I can just formula copy it to F2, F3, etc ...
Conditional formatting > custom formula that "contains" a string of ...
https://support.google.com/docs/thread/32678750/conditional-formatting-custom-formula-that-contains-a-string-of-characters?hl=en Mar 7, 2020 ... ... match of a string of characters. For example, the formula should still match any of the following: "X. text goes here". "0. text goes here ...
Replace Text with Exact Text if it Contains Target Text - Google Docs ...
https://support.google.com/docs/thread/180678307/replace-text-with-exact-text-if-it-contains-target-text?hl=en Sep 23, 2022 ... Try the following formula (I entered the formula into cell C1 in your spreadsheet) ... I've edited the example spreadsheet so you can see an ...
Use FILTER Formula to Exclude Any Cells Containing Specific Text ...
https://support.google.com/docs/thread/57887789/use-filter-formula-to-exclude-any-cells-containing-specific-text-but-exact-match?hl=en Jul 8, 2020 ... ... contain any text with "cert" in it. For example, a cell with "Certifications Type 1" would be excluded/filtered out. Thank you in advance ...
Need a formula that if cell E2 is Yes, then divide another column by ...
https://support.google.com/docs/thread/5187180/need-a-formula-that-if-cell-e2-is-yes-then-divide-another-column-by-2-and-enter-result-in-e6?hl=en Apr 30, 2019 ... ... contains Yes, I'd like to have the next cell display half the amount ... spreadsheet with some data. As you can see, I entered in H1.
Cell formula to display different text based off text in another cell ...
https://support.google.com/docs/thread/158958439/cell-formula-to-display-different-text-based-off-text-in-another-cell?hl=en Apr 7, 2022 ... E.g. if cell D2 contains /02/ then show Ball, but if it contains ... Your example spreadsheet is not accessible (Access denied). Please ...
Filter by condition / Text contains -> combination of and/or formulas ...
https://support.google.com/docs/thread/63180001/filter-by-condition-text-contains-combination-of-and-or-formulas?hl=en Aug 6, 2020 ... Please create your own post so it has its own thread. In the new post, please ask your question again and also share an example mockup ...
How do I sum values if the cell next to them contains certain text ...
https://support.google.com/docs/thread/72577613/how-do-i-sum-values-if-the-cell-next-to-them-contains-certain-text?hl=en Sep 22, 2020 ... See the new Data sheet in your sample spreadsheet for an illustration. ... =arrayformula( { "Month"; if( len(A2:A), text(A2:A, "yyyy-mm ...
If cell contains a specific dropdown selection, select data range from ...
https://support.google.com/docs/thread/25020428/if-cell-contains-a-specific-dropdown-selection-select-data-range-from-another-sheet?hl=en Jan 8, 2020 ... I am trying to pull specific units from named ranges on another sheet. I have tried to use the Data Validation with a custom formula =IF(C2="Food and Drink", ...
How to write a formula using the month only from a cell containing a ...
https://support.google.com/docs/thread/217695059/how-to-write-a-formula-using-the-month-only-from-a-cell-containing-a-full-date?hl=en May 25, 2023 ... If I format the date to show the month only, then use the month in the formula, It is not recognized as a match. So I can't figure out how to ...
Highlight entire row if cell in specific column contains any of multiple ...
https://support.google.com/docs/thread/64633105/highlight-entire-row-if-cell-in-specific-column-contains-any-of-multiple-words?hl=en Aug 13, 2020 ... ... formula. =SEARCH("NEUROLOGY", $F2) I want to be able to use one ... if Sheets CF rules would apply when you open the Excel file. If you ...
Does index(importrange work with "contains" certain text - Google ...
https://support.google.com/docs/thread/8496179/does-index-importrange-work-with-contains-certain-text?hl=en Jun 22, 2019 ... I have a formula and I will cut out everything that is not relevant to us: ... if that makes any sense). I apologize if this seems like ...