About 1,958,179 results (3,354 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 ...
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 ... Similar to Excel, when you drag a formula down it auto-updates to apply the logic to the next row. Issue 1. If you want all the boxes to change ...
use form data to fill sheet cell if true - Google Docs Editors Community
https://support.google.com/docs/thread/157598847/use-form-data-to-fill-sheet-cell-if-true?hl=en Mar 28, 2022 ... The formula below is one I feel is best suited to get you the sum of Monday Cash Sales if Column A is checked. =SUMIF('Form Responses 1'!$A:$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 ... I cannot replicate this in google sheets. I've tried using CONCAT, CONCATENATION, JOIN without success and this <=TEXTJOIN(",",TRUE,VLOOKUP(H160 ...
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, ...
I want use a formula, only if a check box is checked. - Google Docs ...
https://support.google.com/docs/thread/232249681/i-want-use-a-formula-only-if-a-check-box-is-checked?hl=en Aug 27, 2023 ... Otherwise, leave the field at "0". Something like: =SUM(D4-H4)+(E4-F4)-C4 -> if B4 is "true", ...
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.
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 ... Could you quickly explain the use of the LEN(A2:A) formula nested inside the IF() function? ... If TRUE then do this", If FALSE do this" ). If A1 ...
Excel Solver: Can't interrupt if UDF is marked IsExceptionSafe=True
https://groups.google.com/g/exceldna/c/W7pVEyrNf9o May 26, 2015 ... Putting the xlAbort at the start seems to work better then putting it at the end of the function. Check inside the main iteration loop also ...
Automate Copy+Paste to Cell Only Once Based On An If Function ...
https://support.google.com/docs/thread/52714066/automate-copy-paste-to-cell-only-once-based-on-an-if-function?hl=en Jun 10, 2020 ... ... function that can perform the True statement in the If function. When I was searching the web, I couldn't find a function that could do so ...
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.
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 ... IF(. AND($A1:$A=$E$1, $D1$D<>$F$3),. [formula if true],. [formula if false]. ) ) In my worksheet I can select the array formula for cell G1 ...
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 ... As you can see, now the formula returns TRUE. Even though, in ... A rule like this might work, if they were typing into cell I5. =MOD ...
How to use IF() where the value_if_true is a formula.. - Google Docs ...
https://support.google.com/docs/thread/166695807/how-to-use-if-where-the-value-if-true-is-a-formula?hl=en Jun 9, 2022 ... I want the value_if_true to be "=NOW()" so that when people enter a value in column D, column E is dated/timestamped automatically.
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 ... I have a spreadsheet that calculates my budget. I split some expenses with my husband. In each row, I have a cell with the original amount, followed by a cell ...
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).
IFS function - Google Docs Editors Help
https://support.google.com/docs/answer/7014145?hl=en IF : Returns one value if a logical expression is `TRUE` and another if it is `FALSE`. ... Learn to work on Office files without installing Office, create ...
SUMIF - Google Docs Editors Help
https://support.google.com/docs/answer/3093583?hl=en SUMIF can only perform conditional sums with a single criterion. To use multiple criteria, use the database function DSUM . See Also. SUMSQ : Returns the sum of ...
Lookup and Vlookup return results if value isn't found. I need to ...
https://support.google.com/docs/thread/46261703/lookup-and-vlookup-return-results-if-value-isn-t-found-i-need-to-show-an-error?hl=en May 12, 2020 ... How do i write a formula that gives me an error when the value that ... !$A$1:$C$16,3,True),"FIX") - same. Any help can be provided ...
Google Sheets IF Statement with Numbers and Text - Google Docs ...
https://support.google.com/docs/thread/120398679/google-sheets-if-statement-with-numbers-and-text?hl=en Aug 8, 2021 ... ... TRUE * TRUE results in a TRUE for the outer IF(). Here's the same formula using the AND() function. Use the one you prefer: =ARRAYFORMULA( IF(.