About 1,221,887 results (1,749 milliseconds)
IF function - Google Docs Editors Help
https://support.google.com/docs/answer/3093364?hl=en IF function. Returns one value if a logical expression is `TRUE` and ... Using Google products, like Google Docs, at work or school? Try powerful ...
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 ... I'm trying to use the IF Formula to put an "X" in a box, indicating that a student has completed a particular class.
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 ... The values are just too small to matter. When you are making comparisons, like for conditional formatting, using ROUND(xxx, 2) will be enough to ...
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 ... replicating excel's textjoin with an IF function. in excel, I have ... I've tried using CONCAT, CONCATENATION, JOIN without success and ...
Using logical operators as a cell reference in IF formula. - Google ...
https://support.google.com/docs/thread/44693980/using-logical-operators-as-a-cell-reference-in-if-formula?hl=en May 5, 2020 ... I have an IF formula in which I want to use the Logical operators (> ,=) from a cell. For example in Cell A1 there is > symbol typed.
Detect If Formula Was Invoked Via F2+{Enter} Or Double-click+{Enter}
https://groups.google.com/g/exceldna/c/LUYIvHED1RM Apr 19, 2023 ... We use reactive extensions and not ExcelRTDServer so a bit unsure if the below is useful. We created 2 different functions, one that returns RTD ...
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 ... Hence why I tried using the previous formula in the conditional ... Similar to Excel, when you drag a formula down it auto-updates to ...
Using Dates in the IF function to show on time or late - Google Docs ...
https://support.google.com/docs/thread/43165110/using-dates-in-the-if-function-to-show-on-time-or-late?hl=en Apr 28, 2020 ... I seem to have most of the IF function working but the one part I keep tripping on is - The date for the timeline has a 5 day grace period.
Use conditional formatting rules in Google Sheets - Computer ...
https://support.google.com/docs/answer/78413?hl=en&co=GENIE.Platform%3DDesktop Use advanced conditional formatting. Use custom formulas with conditional formatting ... Under the "Format cells if" drop-down menu, click Custom formula is.
Using IF function within QUERY formulas (Google Sheet) - Google ...
https://support.google.com/docs/thread/89041581/using-if-function-within-query-formulas-google-sheet?hl=en Dec 17, 2020 ... ... if it's $0, which I want to get rid of. I figured I should use an IF formula within the query formula (on cell G1) so that the if a cell ...
If...then statements in spreadsheets?
https://groups.google.com/g/tinspire/c/xHzIAiLGAko Feb 18, 2009 ... I know it's possible to create a function in the Program Editor, but I was hoping for a simpler use within a spreadsheet cell. Besides, I need ...
Google Sheets Count If formula works on it's own but not in an Array ...
https://support.google.com/docs/thread/81411630/google-sheets-count-if-formula-works-on-it-s-own-but-not-in-an-array?hl=en Nov 7, 2020 ... 241 - 3 for the third item on list 241) using another formula. The ... I'm pretty good with excel/google sheets formulas, but I'm ...
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.
How to use IF and ISBLANK to reference multiple cells in Sheets ...
https://support.google.com/docs/thread/188982124/how-to-use-if-and-isblank-to-reference-multiple-cells-in-sheets?hl=en Nov 17, 2022 ... I'm trying to use the IF and ISBLANK functions together to return the word "NUL" if 2 referenced cells are empty.
Help with IFERROR AVERAGE IF formula that WORKS on excel ...
https://support.google.com/docs/thread/42466792/help-with-iferror-average-if-formula-that-works-on-excel?hl=en Apr 25, 2020 ... ... using their spreadsheet documents. I have recently moved to google sheets from excel now that I have a business account, but one of the formulas ...
multiplying values using IF < and >= functions - Google Docs Editors ...
https://support.google.com/docs/thread/173312908/multiplying-values-using-if-and-functions?hl=en Jul 31, 2022 ... ... formula for that row any time that number changes. The formula that I'm using that works is: =H21 * IF(H21 < 10, D21, IF(H21 >= 10, G21, )).
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 ... I want to use a formula to calculate something, but only if the checkbox is checked. Otherwise, leave the field at "0".
Google Sheets: how to put image in the cell but with the IF formula ...
https://support.google.com/docs/thread/75597980/google-sheets-how-to-put-image-in-the-cell-but-with-the-if-formula?hl=en Oct 7, 2020 ... Your Images sheet contains in-cell images rather than web addresses of images, so you do not need to use the image() function.
IF function - how to write the formula to connect with another tab in ...
https://support.google.com/docs/thread/4562242/if-function-how-to-write-the-formula-to-connect-with-another-tab-in-the-same-sheet?hl=en Apr 20, 2019 ... I'm trying to figure out how to use the IF function across tabs in the same sheet. The formula i am using is =sumif(C$1:C$722, "=PF2",J$1:J$722)
How to simplify my if/query function - Google Docs Editors Community
https://support.google.com/docs/thread/18554404/how-to-simplify-my-if-query-function?hl=en Nov 4, 2019 ... Excel sheet is changed to reflect. E. Ed(Ohio). Diamond Product Expert ... I think that is why I was using the if and query. My apologies. I ...