About 1,909,690 results (1,171 milliseconds)
Using MAXIFS with a criteria that is greater than or equal to a cell ...
https://support.google.com/docs/thread/79983233/using-maxifs-with-a-criteria-that-is-greater-than-or-equal-to-a-cell-reference?hl=en Oct 30, 2020 ... The formula works fine without the 'greater than' but in that case only returns a result if ... 0, where I want it to return the highest ...
Conditional Formatting when the value in a cell is greater than the ...
https://support.google.com/docs/thread/5900027/conditional-formatting-when-the-value-in-a-cell-is-greater-than-the-value-in-another-cell?hl=en May 10, 2019 ... If I replace the number with D4, then it is unable to recognize that as the reference to the cell. I tried using the custom formula option but ...
using arrayformula - Google Docs Editors Community
https://support.google.com/docs/thread/162112990/using-arrayformula?hl=en May 2, 2022 ... ... if the length is greater than 0 and, if so, do something. For instance, this formula will subtract C from D if A has value: =ARRAYFORMULA(IF ...
Find last value in a column (that's greater than 0) - Google Docs ...
https://support.google.com/docs/thread/195952285/find-last-value-in-a-column-that-s-greater-than-0?hl=en Jan 5, 2023 ... ... conditional formatting so that it doesn't show anything if I haven't put the data in yet. So my ArrayFormula is picking up on the "0.0"s on ...
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:// ...
Conditional Formatting Based on Greater Than a Time Value ...
https://support.google.com/docs/thread/107307114/conditional-formatting-based-on-greater-than-a-time-value?hl=en Apr 23, 2021 ... So this formula =if($G$3>="0:01", 1, "") equates to FALSE, since none of the values in row 3 are text strings, even if they look like it. But if ...
Conditional formatting based on the value of a cell in another sheet ...
https://support.google.com/docs/thread/54176088/conditional-formatting-based-on-the-value-of-a-cell-in-another-sheet?hl=en Jun 18, 2020 ... I am trying to create a custom formula that would highlight a cell red, if a cell on another sheet was greater than 0.
Conditional Formatting: Very Simple "Value Greater Than" Format ...
https://support.google.com/docs/thread/157090738/conditional-formatting-very-simple-value-greater-than-format-not-applying-to-a-single-row?hl=en Mar 24, 2022 ... Apply to range: E3:E6 ; Format cells if... Custom Formula is... ; Formula: =ROUND(E3,3)>0 ; Format: <format of your choice>.
Google Sheets - Conditional Formatting Rules - Want "Custom ...
https://support.google.com/docs/thread/299380936/google-sheets-conditional-formatting-rules-want-custom-formula-to-change-to-pasted-cell?hl=en Sep 29, 2024 ... Column C is where I'd like to see the cell gray if empty, red if 0, yellow if greater than 0 but less than the cell in Column B, and green if ...
How to get if formula to check for if the cell is greater than a number ...
https://support.google.com/docs/thread/2234862/how-to-get-if-formula-to-check-for-if-the-cell-is-greater-than-a-number-but-also-not-null?hl=en Mar 10, 2019 ... I am trying to make the formula check if a student's grade is >79.5 AND the cell is not blank then return yes, if less than 79.5 no.
I applied conditional formatting to turn cells red if it is greater than ...
https://support.google.com/docs/thread/139259097/i-applied-conditional-formatting-to-turn-cells-red-if-it-is-greater-than-another-cell-in-the-previou?hl=en Dec 7, 2021 ... But some are still red even when they are not greater than the value, such as 50,000 and 0. ... Your original formula used >= (greater than or ...
HOW TO V LOOKUP GREATER THAN OR ANY OTHER FORMULA ...
https://support.google.com/docs/thread/121959926/how-to-v-lookup-greater-than-or-any-other-formula?hl=en Aug 19, 2021 ... Let me know if this is what you're looking for. Also note that I modified the formulas in E2 and E3 to return values where H>=0 instead of H>0 ...
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. =(E2+0)*if((E2+0)<(B2+0),(A2+0),(D2+0)). I have keyed-in this formula in cell H2 of your spreadsheet. drag this formula down as far as ...
I'd like to change the colour of a cell, if there is data in another cell ...
https://support.google.com/docs/thread/11837482/i-d-like-to-change-the-colour-of-a-cell-if-there-is-data-in-another-cell-but-not-in-the-original?hl=en Aug 12, 2019 ... ... if N3 is greater than 0, but M3 is empty. If both cells (or neither) ... Formula: =OR(AND(N3="",M3>0),AND(M3=0,N3<>"")). Format: <red ...
Conditional formatting = trying to highlight if "Greater Than" - Google ...
https://support.google.com/docs/thread/33289598/conditional-formatting-trying-to-highlight-if-greater-than?hl=en Mar 12, 2020 ... Hello, in my spreadsheet I have a formula in cell E3 that calculates a percentage (e.g. answer is "4.00%"). I change this formula ...
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 ...
I'd like to change the colour of a cell, if there is data in another cell ...
https://support.google.com/docs/thread/11837482?hl=en&msgid=11842871 Aug 12, 2019 ... N3 is a cell, which can contain data inputs from users. I'd like to change the background colour of N3 if M3 is greater than 0, and N3 is empty; ...
Sumif formula does not work in Google Sheets - Google Docs ...
https://support.google.com/docs/thread/168978270/sumif-formula-does-not-work-in-google-sheets?hl=en Jun 27, 2022 ... Goal: I need to evaluate a range (C4:N4) every time a cell in that range contains a value greater than 0 I need it to add 50. ... In Excel my ...
Conditional Formatting if cell is greater/less than cell above - Google ...
https://support.google.com/docs/thread/40734495/conditional-formatting-if-cell-is-greater-less-than-cell-above?hl=en Apr 17, 2020 ... I can get it to work on a single cell no problem with the drop down options and the custom formula (e.g. =G3<G2). As soon as I try to apply ...
Greater than or equal to "but" less than or equal to in google sheets ...
https://support.google.com/docs/thread/149366436/greater-than-or-equal-to-but-less-than-or-equal-to-in-google-sheets?hl=en Feb 4, 2022 ... I have the following formula in A173: =IF(A170=0,0, IF(A170<=1000, 0, IF(A170>=1001,A170-1000))). So, now, when I type 5000 in A170, it ...