About 1,264,879 results (3,143 milliseconds)
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 ... If so, that would let us see the issue ourselves, with very little effort on your part. I believe all of the relevant formatting for those two ...
Formula to display text based off a cell in another sheet - Google ...
https://support.google.com/docs/thread/285992087/formula-to-display-text-based-off-a-cell-in-another-sheet?hl=en Jul 18, 2024 ... I am looking for an IF formula that will display text from a cell in a 1 sheet that is based off an input in another cell on the same sheet, onto another cell ...
Is it possible for a plus sign to show as plain text and not create a ...
https://support.google.com/docs/thread/4057005/is-it-possible-for-a-plus-sign-to-show-as-plain-text-and-not-create-a-formula?hl=en Apr 12, 2019 ... I need the plus sign to show as plain text and not create a formula. ... So if you type this '+word+word it will come out as just +word+ ...
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 ... The formulas in the cells will either return a "" if false, or a specific cell value if true. Above these cells at the top row I want to display ...
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 ... Format > Conditional Formatting; Choose your range of cells for which you want the formula to be applied; Select 'If Text Contains' = True, and ...
SHEETS IF Function - change text in cell depending on the data in ...
https://support.google.com/docs/thread/18478561/sheets-if-function-change-text-in-cell-depending-on-the-data-in-two-other-cells?hl=en Nov 3, 2019 ... I am stumped! I have attached the spreadsheet and the formula I am struggling with is on the "Master Job List" sheet and is in Cell B. This ...
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 ... ... if the text in the other cell contains f.e. "text". I can explain it by something like this: IF A1cell's text = "text"; put image in the cell B1.
Function to display message if the sum of two columns do not match ...
https://support.google.com/docs/thread/51218061/function-to-display-message-if-the-sum-of-two-columns-do-not-match?hl=en Jun 4, 2020 ... I want to use an APPS script function to verify if the sum one column matches the other and display an alert if this condition is not met.
If function, CONCATENATE, and a line break in between two blocks ...
https://support.google.com/docs/thread/24891189/if-function-concatenate-and-a-line-break-in-between-two-blocks-of-text?hl=en Jan 6, 2020 ... Even when I do get text pulled in, the if function doesn't seem to ... see much point in an auto-expanding formula. If you can't get ...
in a concatenate formula, show number as am pm time - Google ...
https://support.google.com/docs/thread/282667133/in-a-concatenate-formula-show-number-as-am-pm-time?hl=en Jun 29, 2024 ... If you want the AM/PM lowercase, change it to "am/pm" instead. This also simplified the way you get the date to display, also using the TEXT ...
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 ... The formula <=TEXTJOIN(",",TRUE,IF(B$1:B$71=B74,H$1:H$71,""))> returns the chapter numbers from column H separated by commas against a ...
combine percentage value with text, have percentage appear ...
https://support.google.com/docs/thread/150191706/combine-percentage-value-with-text-have-percentage-appear-without-post-decimal-digits?hl=en Feb 9, 2022 ... ... if B1>B2 or to green if B2<=B1. Note that I also edited your formula in B3 because if you're looking to compare costs to budget, the budget ...
Conditional IF statement not working - Google Docs Editors ...
https://support.google.com/docs/thread/59831408/conditional-if-statement-not-working?hl=en Jul 19, 2020 ... I am trying to apply custom formula conditional formatting to the address column to turn the background red and the text white if the “Do Again” column ...
IF function - Google Docs Editors Help
https://support.google.com/docs/answer/3093364?hl=en See Also. IFERROR: Returns the first argument if it is not an error value, otherwise returns the second argument if present, or a blank if the ...
Conditional formatting if Cells have passed current time - Google ...
https://support.google.com/docs/thread/231842771/conditional-formatting-if-cells-have-passed-current-time?hl=en Aug 24, 2023 ... This is very close to a rule that was already in there (=L7<P7) but the $ signs mean that you can use the same formula for ALL rows instead of ...
How to do this: If a condition is true, add text to a cell. - Google Docs ...
https://support.google.com/docs/thread/139520255/how-to-do-this-if-a-condition-is-true-add-text-to-a-cell?hl=en Dec 9, 2021 ... Or this formula, in G2, fills the whole column automatically. ={"Output";ARRAYFORMULA(. IF(B3:B="","",.
How can I format text to be a different color if that text does not ...
https://support.google.com/docs/thread/75260108/how-can-i-format-text-to-be-a-different-color-if-that-text-does-not-appear-in-a-list?hl=en Oct 6, 2020 ... So in a typical MATCH formula it will either show a #N/A error or the place that value from column B is in the list of column C. I used this ...
Format "Today()" within a formula containing text - Google Docs ...
https://support.google.com/docs/thread/15874162/format-today-within-a-formula-containing-text?hl=en Oct 2, 2019 ... If you need to use the date from that cell in a formula later on you ... Use your sample sheet to demonstrate what you'd like the sheet to do!
Formula for text to be reflected as a note in other cell - Google Docs ...
https://support.google.com/docs/thread/37332042/formula-for-text-to-be-reflected-as-a-note-in-other-cell?hl=en Apr 1, 2020 ... If you expand this down, just copy the formula down to the ... formula and when I enter text, its automatically will display as a note.
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 ... I then have another cell that is using the IFS formula to see if the above cell equals a certain number. ... LEFT will return text instead of ...