About 1,829,897 results (2,328 milliseconds)
DATE in IF Function showing as FALSE when it should be True, why ...
https://support.google.com/docs/thread/40506913/date-in-if-function-showing-as-false-when-it-should-be-true-why?hl=en Apr 16, 2020 ... Format > Conditional Formatting · Choose your range of cells for which you want the formula to be applied · Select 'If Text Contains' = True, and ...
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 ...
DATE in IF Function showing as FALSE when it should be True, why ...
https://support.google.com/docs/thread/40506913?hl=en&msgid=40515471 Apr 16, 2020 ... I had this error in a spreadsheet so tried to simplify it as much as possible and can't get it to work under no circumstances, ...
How do I not include a false value in an "IF" function? - Google Docs ...
https://support.google.com/docs/thread/7274581/how-do-i-not-include-a-false-value-in-an-if-function?hl=en Jun 2, 2019 ... I can do this with an "IF" function, but (see 2nd picture) I get a bunch of blank rows when the value is false. Is there a way to not have a ...
Formula question - Cell text dependent on 3 separate True/False ...
https://support.google.com/docs/thread/20726612/formula-question-cell-text-dependent-on-3-separate-true-false-cell-values?hl=en Nov 21, 2019 ... Also, in cell M2 I simplified your formula from M1 using the VLOOKUP ... For example: if A1=TRUE, A2=FALSE, and A3=TRUE, display: CC BY ...
IF formula returns FALSE while comparing to equal numbers ...
https://support.google.com/docs/thread/193901389/if-formula-returns-false-while-comparing-to-equal-numbers?hl=en Dec 22, 2022 ... Or, where ever you use the values they've typed in, you round those to the nearest 0.01, so that your calculations are correct after that. I can ...
Countif for True/False not working if the cells being evaluated are ...
https://support.google.com/docs/thread/243889441/countif-for-true-false-not-working-if-the-cells-being-evaluated-are-from-a-query?hl=en Nov 14, 2023 ... I'm trying to use the Countif function to count the number of TRUE or FALSE values.. but the result always comes back zero.
Why is search function returning TRUE on FALSE values when ...
https://support.google.com/docs/thread/136537378/why-is-search-function-returning-true-on-false-values-when-searching-for-a-string-of-texts-from-list?hl=en Nov 21, 2021 ... I am trying to set a function to return true or false on strings of texts within a cell when matched to a value or string of texts from a ...
How to create a filter to exclude "False" results without using the ...
https://support.google.com/docs/thread/211969305/how-to-create-a-filter-to-exclude-false-results-without-using-the-manual-filter-feature?hl=en Apr 20, 2023 ... I have second tab that is usually a lot of "false"'s unless I change the value on another page. (I'm using the =IF function). When I update ...
AND function - Google Docs Editors Help
https://support.google.com/docs/answer/3093301?hl=en 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.
ArrayFormula IF statement evaluates to TRUE but still uses my ...
https://support.google.com/docs/thread/112846401/arrayformula-if-statement-evaluates-to-true-but-still-uses-my-false-argument-why?hl=en Jun 8, 2021 ... The value is first calculated with the same formula but for the false argument it is further multiplied by the exchange rate to give [formula if ...
Trying to get a true/false based on multiple variables in a sheet ...
https://support.google.com/docs/thread/18861523/trying-to-get-a-true-false-based-on-multiple-variables-in-a-sheet?hl=en Nov 7, 2019 ... I am running into one problem When trying to use the formula into my other sheet with a lot more data my E column only gives true and false, but ...
Checking against two columns with IF and IFS to apply different ...
https://support.google.com/docs/thread/158089405/checking-against-two-columns-with-if-and-ifs-to-apply-different-sums?hl=en Mar 31, 2022 ... That column is used whether the answer to the first was True OR False. If True, the formula checks whether the value of the second column is 0, ...
Values in cell populating another cell if checkbox is true or false ...
https://support.google.com/docs/thread/98769069/values-in-cell-populating-another-cell-if-checkbox-is-true-or-false?hl=en Feb 18, 2021 ... Where the "0" is after the "I14" I need that to be a formula which adds to the value of another cell and uses the same calculation that is found ...
Checkboxes are appearing TRUE and FALSE when downloaded ...
https://support.google.com/docs/thread/213838303 May 2, 2023 ... I know that I have to do the Format Control function for each checkbox in Excel which is a bit time consuming. I'm thinking if there is a ...
Need a formula that checks today's month against a table and ...
https://support.google.com/docs/thread/116819417/need-a-formula-that-checks-today-s-month-against-a-table-and-returns-a-corresponding-value?hl=en Jul 11, 2021 ... I'm glad I was able to help. LEN() FUNCTION USED AS A LOGIC TRUE OR FALSE ... If TRUE then do this", If FALSE do this" ). If A1 is equal to "Test ...
Conditional IF statement not working - Google Docs Editors ...
https://support.google.com/docs/thread/59831408/conditional-if-statement-not-working?hl=en Jul 19, 2020 ... I've tried both of the following formats. Whatever I use, I get invalid formula. =IF($P11 = “No”, True, False).
OR function - Google Docs Editors Help
https://support.google.com/docs/answer/3093306?hl=en The OR function returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false. Sample Usage.
Sum Based on Other Cells True/False - Google Docs Editors ...
https://support.google.com/docs/thread/87727070/sum-based-on-other-cells-true-false?hl=en Dec 9, 2020 ... Location 4 and 5 should always be excluded from the count even if they're set to True. I am looking for one formula that would take into account ...
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.