About 1,924,139 results (2,459 milliseconds)
How to see formula calculation steps in Google Sheets? - Google ...
https://support.google.com/docs/thread/7547557/how-to-see-formula-calculation-steps-in-google-sheets?hl=en Jun 6, 2019 ... In microsoft Excel there is an 'Evaluate Formula' button. Is there an equivalent in Google Sheets? What should be my approach when trying for figure out what's ...
I want to delete a TAB, but want to check and make sure no other ...
https://support.google.com/docs/thread/61520059/i-want-to-delete-a-tab-but-want-to-check-and-make-sure-no-other-tabs-uses-a-formula-on-the-data?hl=en Jul 28, 2020 ... I've so far just manually checked tabs, but I want to know if there is a more robust way to see I can see if any formulas on any other ...
Google Sheets function list - Google Docs Editors Help
https://support.google.com/docs/table/25273?hl=en Google Sheets function list ; Array, SCAN, SCAN(initial_value, array_or_range, LAMBDA) ; Array, SUMPRODUCT, SUMPRODUCT(array1, [array2, ...]) ; Array, SUMX2MY2 ...
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".
how to determine whether a cell contains a formula
https://groups.google.com/g/exceldna/c/87Qi8Q5sVq4 Oct 5, 2010 ... Dim formula As String If TypeOf input Is ExcelReference Then formula = XlCall.Excel(XlCall.xlfGetFormula, input) Return "Formula: " & formula
Spell Check function in an IF statement?
https://groups.google.com/g/microsoft.public.excel.worksheetfunctions/c/Qu6WVshjumc Feb 4, 2008 ... No text boxes. I need to split the data into 2 buckets: (a) cells where 100% of the text passes Excel spellchecker, and (b) ...
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 ... The downside of using a formula is that you can no longer manually tick the boxes in column A . If they need to be checkable, please post in a ...
Automatic Check Box fill based on Cell Value - Google Docs Editors ...
https://support.google.com/docs/thread/238893913/automatic-check-box-fill-based-on-cell-value?hl=en Oct 12, 2023 ... Example: Column A is budget value, Column B is spending, Column C is check boxes. I have the formula "=B2<=A2" as a reason to do something ...
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 ... ... test possible solutions, please create a sample sheet we can all work on. Learn More: Google Product Experts' TIPS FOR POSTING. And this ...
Have values in cells with checkboxes checked to subtract from ...
https://support.google.com/docs/thread/5461399/have-values-in-cells-with-checkboxes-checked-to-subtract-from-another-cell-and-then-be-summed?hl=en May 4, 2019 ... I have a column with numbers and next to them a column with check-boxes. I then have C1 with a value and in D2 I have this formula... =C1 ...
Parity Check formula for binary numbers
https://groups.google.com/g/microsoft.public.excel.worksheet.functions/c/DDI3OW23Ywk Need to use Excel to do a parity check on a binary number returning either a odd or even parity result. Does anyone have a formular or macro that can do this?
is there a formula to check if a cell contains certain text? - Google ...
https://support.google.com/docs/thread/296695635/is-there-a-formula-to-check-if-a-cell-contains-certain-text?hl=en Sep 14, 2024 ... The cell to test may contain variations of "Fix ...";. the result will all return the same value, so instead of entering each of many iterations ...
Set conditional formatting to use a checkbox to change row color ...
https://support.google.com/docs/thread/189010230/set-conditional-formatting-to-use-a-checkbox-to-change-row-color-individually-throughout-the-sheet?hl=en Nov 17, 2022 ... ... check box and change that rows color individually. I can get this to ... For red warning, add custom formula =$K2=TRUE() 4. For yellow ...
Please suggest a formula for show active or inactive status on MIS ...
https://support.google.com/docs/thread/60977438/please-suggest-a-formula-for-show-active-or-inactive-status-on-mis-c1?hl=en Jul 25, 2020 ... Thank you for your sample file but unfortunately it is in View Only mode and the forum volunteers cannot demonstrate or test formulas in your ...
Check Box: when a box is checked the info in the row automatically ...
https://support.google.com/docs/thread/13657644/check-box-when-a-box-is-checked-the-info-in-the-row-automatically-shows-in-another-sheet?hl=en Sep 5, 2019 ... I added similar formulas to the other sheets but instead of where Column F=True it uses the column corresponding to the sheet. I'll hang out on ...
Manually calculating part of the formula - Google Docs Editors ...
https://support.google.com/docs/thread/230638779/manually-calculating-part-of-the-formula?hl=en Aug 16, 2023 ... In MS-Excel, I would select the section and press F9. Not able to ... You need to highlight the section of the formula you want to check ...
Checking for duplicates across multiple tabs in one Google Sheet ...
https://support.google.com/docs/thread/216004482/checking-for-duplicates-across-multiple-tabs-in-one-google-sheet?hl=en May 16, 2023 ... I need help with a formula that can check for duplication in column B across all 3 tabs, and highlight all duplicates, wherever they appear.
Compare 2 sheets for similarities and differences even if on different ...
https://support.google.com/docs/thread/10262301/compare-2-sheets-for-similarities-and-differences-even-if-on-different-rows?hl=en Jul 20, 2019 ... I am trying to compare 2 sheets using the following formula on a 3rd checking sheet: =IF(Sheet1!A1<> Sheet2!A1, Sheet1!A1&" | "&Sheet2!A1, "")
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 ... But I want it to exclude blank cells (students who haven't taken the test yet) Right now, the score comes into the cell T2. My if formula if(T2> ...
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 ... Workaround: You can input the value you want to check against in ... Similar to Excel, when you drag a formula down it auto-updates to ...