About 1,889,546 results (3,330 milliseconds)
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 ...
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 another if it is FALSE. Sample Usage: IF(A2 = "foo","A2 is foo")
If...then statements in spreadsheets?
https://groups.google.com/g/tinspire/c/xHzIAiLGAko Feb 18, 2009 ... Does the spreadsheet in the Nspire accept If...Then statements, similar to the way that Excel does? I've tried variations of the formula with ...
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 can't see what you are doing in your spreadsheet so I am just going to make a guess. Assuming the Checkbox is in cell A4 then the formula ...
if greater than/equal to 10 return 10, if less than 10 return calculated ...
https://support.google.com/docs/thread/19876526/if-greater-than-equal-to-10-return-10-if-less-than-10-return-calculated-value?hl=en Nov 14, 2019 ... Second version of the formula returns a parse error. Here's the sharable file with the two formulas & what my desired result would be: https:// ...
If(AND matches then check next row - Google Docs Editors Community
https://support.google.com/docs/thread/20535445/if-and-matches-then-check-next-row?hl=en Nov 19, 2019 ... The formula will work in Sheets, but I doubt it will work in Excel if you're trying to edit the Excel file directly. You can use the Filter ...
If/then-Formula to add +1 every time a certain word appears in cell ...
https://support.google.com/docs/thread/62834244/if-then-formula-to-add-1-every-time-a-certain-word-appears-in-cell?hl=en Aug 5, 2020 ... In column B (among others) I mark the date when a coaching with an employee took place. Now I need a formula that adds +1 to cell B2 ...
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 ... ... formula, and "==" if the cells show any cell value. ... If you use that then Isblank() will work, and actually so will counts and the like.
Detect If Formula Was Invoked Via F2+{Enter} Or Double-click+{Enter}
https://groups.google.com/g/exceldna/c/LUYIvHED1RM Apr 19, 2023 ... In a standard Excel function, one can manually refresh a single cell via keying F2+{Enter} or double-clicking into a cell and then keying {Enter}.
Inserting an image if another cell is not blank - Google Docs Editors ...
https://support.google.com/docs/thread/35326824/inserting-an-image-if-another-cell-is-not-blank?hl=en Mar 24, 2020 ... Wondering if there is an easy formula to use so that when A5 is not ... If cell C6 contains the number 5000 then the image will fill in ...
I'm not sure if I need to use VLOOKUP, IF/THEN or a combination for ...
https://support.google.com/docs/thread/240665327/i-m-not-sure-if-i-need-to-use-vlookup-if-then-or-a-combination-for-google-sheets?hl=en Oct 24, 2023 ... I haven't used these formulas in Excel/Google Sheets in a while and I'm rusty. Based on this fictional Google Sheet, I thought maybe I ...
Using Array Formula for If/then function and NOT lose data from ...
https://support.google.com/docs/thread/110555641/using-array-formula-for-if-then-function-and-not-lose-data-from-previous-row-down-a-column?hl=en May 20, 2021 ... I wrote an if/then function and it worked, but I cannot get the formula to copy down the column without losing the data from the previous row. I ...
Help?I cannot figure out how to formulate an if/then with complex ...
https://support.google.com/docs/thread/8260191/help-i-cannot-figure-out-how-to-formulate-an-if-then-with-complex-logic-and-multiple-outcomes?hl=en Jun 18, 2019 ... I know that I may not be able to do this BUT in a previous file that was created excel and then converted into google sheets the following ...
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 ... When adding up large columns of numbers unless it is absolutely huge (WAY larger than Sheets can handle) this is rarely a problem. Like in your ...
Sum function not working on values returned from if statement ...
https://support.google.com/docs/thread/39856270/sum-function-not-working-on-values-returned-from-if-statement?hl=en Apr 13, 2020 ... It is necessary to get the summation of each rows point value based on the if statement. It appears to assign the value (the numbers are not in quotations) but ...
Leaving Cell Blank in a IF(and) Statement - Google Docs Editors ...
https://support.google.com/docs/thread/121722801/leaving-cell-blank-in-a-if-and-statement?hl=en Aug 17, 2021 ... The first one that's true returns the result. I assume it's always blank or 0 to 99 based on your formula. If it isn't less than 5, it's greater ...
Using formula within nested IF statement - Google Docs Editors ...
https://support.google.com/docs/thread/195805399/using-formula-within-nested-if-statement?hl=en Jan 4, 2023 ... Using formula within nested IF statement. Hi all, I am trying to dive into formulas within Google Sheet to automate aspects of various ...
If all checkboxes are checked in a row, I want an automatic ...
https://support.google.com/docs/thread/177314560/if-all-checkboxes-are-checked-in-a-row-i-want-an-automatic-strikethrough-on-the-name-in-the-row?hl=en Aug 30, 2022 ... Then copy and paste cell A3 down the column. See the Solution sheet. The downside of using a formula is that you can no longer manually tick the ...
formula not working - Google Docs Editors Community
https://support.google.com/docs/thread/175171659/formula-not-working?hl=en Aug 15, 2022 ... When converting Excel file to a Google Sheet file then a lot of formulas created in Excel will not work in Google Sheets.
Use conditional formatting rules in Google Sheets - Computer ...
https://support.google.com/docs/answer/78413?hl=en&co=GENIE.Platform%3DDesktop and then Conditional formatting. Under the "Format cells if" drop-down menu, click Custom formula is. If there's already a rule, click it or Add new rule and ...