About 1,842,163 results (3,596 milliseconds)
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.
Fastest Way to Read a Range of Cells into C# - BUT I want the 'text ...
https://groups.google.com/g/exceldna/c/mYPaWZWTLfY Dec 6, 2015 ... I know Interop.Range.Value2 and ExcelReference.GetValue() but both return the 'value'. In most cases I could get away with it, ...
SHEETS: How to reference the Text/Value from one cell within a ...
https://support.google.com/docs/thread/137041108/sheets-how-to-reference-the-text-value-from-one-cell-within-a-formula-of-another-cell?hl=en Nov 24, 2021 ... Get link. Report abuse. SHEETS: How to reference the Text/Value from one cell within a formula of another cell? Hi, I've been struggling with ...
How to reference cells value and not it's formula - Google Docs ...
https://support.google.com/docs/thread/6274141/how-to-reference-cells-value-and-not-it-s-formula?hl=en May 16, 2019 ... ... get the 13 in that last picture. LEFT will return text instead of numbers and might include some non-graphic elements. Since your comparison ...
How do I ask a cell to return a value from another cell if another cell ...
https://support.google.com/docs/thread/156398958/how-do-i-ask-a-cell-to-return-a-value-from-another-cell-if-another-cell-contains-certain-text?hl=en Mar 22, 2022 ... I've created a spreadsheet of English premier league football (soccer) teams and am trying to work out how I can get a cell to fill in a value based on the the ...
How can I get cells w/ formulas to show the full value rather than the ...
https://support.google.com/docs/thread/115366223/how-can-i-get-cells-w-formulas-to-show-the-full-value-rather-than-the-formula-when-double-clicking?hl=en Jun 29, 2021 ... I'd like to be able to double click into the cells and have the entire values show in the pop up window like if the cell was only just a text value.
Reference cell data from another Google spreadsheet (not a ...
https://support.google.com/docs/thread/8274394/reference-cell-data-from-another-google-spreadsheet-not-a-different-tabbed-sheet?hl=en Jun 18, 2019 ... Is there a way to do this without typing the whole formula? What I mean is, say I have document A and B in Excel. If I want to copy a value in a ...
Query Formula return error #VALUE when cell is text - Google Docs ...
https://support.google.com/docs/thread/34107494/query-formula-return-error-value-when-cell-is-text?hl=en Mar 18, 2020 ... Query Formula return error #VALUE when cell is text ... I am wondering what is wrong with this formula because when the cell L44 is in number ( ...
How do I sum values if the cell next to them contains certain text ...
https://support.google.com/docs/thread/72577613/how-do-i-sum-values-if-the-cell-next-to-them-contains-certain-text?hl=en Sep 22, 2020 ... This should be the other way around: you should have all the data for all the months in a row-oriented data sheet, and use formulas to extract ...
How to take text from a cell to use as a reference inside another ...
https://support.google.com/docs/thread/200744477/how-to-take-text-from-a-cell-to-use-as-a-reference-inside-another-formula?hl=en Feb 6, 2023 ... I want to see if it's possible to use another formula inside of the COUNTIF to take the text from the cell, and have it reference to the sheet.
Class Range | Apps Script | Google for Developers
https://developers.google.com/apps-script/reference/spreadsheet/range Returns the text styles for the cells in the range. getValue(), Object, Returns the value of the top-left cell in the range. getValues() ...
Update different columns based on text value of other cells. - Google ...
https://support.google.com/docs/thread/7826333/update-different-columns-based-on-text-value-of-other-cells?hl=en Jun 11, 2019 ... We are trying to tie the part and quantity to an inventory column so we can track inventory in multiple locations. We are able to find the value ...
Conditional Formatting: Getting "If cell is bold, change formatting" to ...
https://support.google.com/docs/thread/60892094/conditional-formatting-getting-if-cell-is-bold-change-formatting-to-work?hl=en Jul 24, 2020 ... Conditional Formatting can't tell if a cell is bold or not. CF rules are based on the value in the cell, like text or numbers or dates or checkboxes.
Google Sheets drop down: choose text from list, return number in cell
https://support.google.com/docs/thread/13293015/google-sheets-drop-down-choose-text-from-list-return-number-in-cell?hl=en Aug 31, 2019 ... Use a drop down list to choose data in text format so I can read it, but I need it to return the numerical value that is assigned to the text value.
Change text in a cell based on value - Google Docs Editors ...
https://support.google.com/docs/thread/185285304/change-text-in-a-cell-based-on-value?hl=en Oct 22, 2022 ... I understand this cannot be done with conditional formatting - I was able to achieve what I wanted with Excel and this worked well.
how to convert an imported number which is stored as text and ...
https://support.google.com/docs/thread/5964457/how-to-convert-an-imported-number-which-is-stored-as-text-and-cannot-be-coerced-to-a-number?hl=en May 11, 2019 ... ... :44 PM. Get link. Report abuse. without seeing data - best route not available. =value( cell ) should change text to number? 1 More.
Copy formula value from one spredsheet to another - Google Docs ...
https://support.google.com/docs/thread/160180464/copy-formula-value-from-one-spredsheet-to-another?hl=en Apr 17, 2022 ... When I paste the cell information in a text editor or email, it pastes only the value, but when I paste it in another spreadsheet, it pastes the ...
Using TEXT formula, blank cell adds data and skews reporting ...
https://support.google.com/docs/thread/120071718/using-text-formula-blank-cell-adds-data-and-skews-reporting?hl=en Aug 5, 2021 ... ... value it returns is just an empty character but it is not blank. That is, it looks blank but does not return "TRUE" when you check with ISBLANK.
Is there a way to paste multiple lines of text into one cell and keep ...
https://support.google.com/docs/thread/221785335/is-there-a-way-to-paste-multiple-lines-of-text-into-one-cell-and-keep-the-formatting?hl=en Jun 20, 2023 ... ... Values only" to get the content into one cell, but that does not preserve the formatting. Even when I paste by selecting one cell and ...
Spreadsheets: Copy a cell value into another cell (event-triggered ...
https://support.google.com/docs/thread/52548929/spreadsheets-copy-a-cell-value-into-another-cell-event-triggered?hl=en Jun 10, 2020 ... To best get help, please share a representative copy of your spreadsheet ... value in E3 is read and copied to F3 as text. Is it possible to ...