About 1,166,674 results (1,855 milliseconds)
Change negative to positive value when importrange - Google Docs ...
https://support.google.com/docs/thread/93811527/change-negative-to-positive-value-when-importrange?hl=en Jan 17, 2021 ... Is there a way to accomplish what I am trying to achieve, whether Using IMPORTRANGE or another function? Thanks! Details. Sheets,Mac OS,Personal ...
Transitioning from Negative to Back to Positive numbers - Google ...
https://support.google.com/docs/thread/288060374/transitioning-from-negative-to-back-to-positive-numbers?hl=en Jul 29, 2024 ... Attached proposal, the formula includes a header and with a single flame to the range to be able to easily change the range. Propusal: Formula ...
Turn manually added values to negative, based on content of ...
https://support.google.com/docs/thread/189295841/turn-manually-added-values-to-negative-based-on-content-of-another-cell?hl=en Nov 19, 2022 ... There is a column of manually added positive values, and i want some of them to be negative based on another cells value in the same row.
Query data and return positive or negative value but not both ...
https://support.google.com/docs/thread/12887169/query-data-and-return-positive-or-negative-value-but-not-both?hl=en Aug 26, 2019 ... You mentioned "maybe this is not how this should be done", so i decided to slightly change ... Here is formula using the FILTER function that ...
How do I convert a range of positive numbers to negative numbers ...
https://support.google.com/docs/thread/100093271/how-do-i-convert-a-range-of-positive-numbers-to-negative-numbers-in-sheets-and-vice-versa?hl=en Feb 27, 2021 ... In an empty range, for example, D2:D10, insert the below formula in the first row (here D2) =ArrayFormula(C2:C10*-1) This will convert the +ve numbers to -ve.
how to return a zero when a number is negative - Google Docs ...
https://support.google.com/docs/thread/19885345/how-to-return-a-zero-when-a-number-is-negative?hl=en Nov 14, 2019 ... How can I make these instances of negative returns appear as 0? Tried number and conditional formatting but no luck. C8*(formulas!G6*5*5)-( ...
Im trying to count the number of positive and negative numbers in a ...
https://support.google.com/docs/thread/92271968/im-trying-to-count-the-number-of-positive-and-negative-numbers-in-a-column-and-not-the-totals?hl=en Jan 6, 2021 ... For example, Id like to know how many of the numbers in column A are positive numbers and how many numbers in column A are negative numbers.
how to make a column negative in google sheets - Google Docs ...
https://support.google.com/docs/thread/102858812/how-to-make-a-column-negative-in-google-sheets?hl=en Mar 18, 2021 ... ... positive number on the rest of the spreadsheet. It´s just a visually ... formula where you find your total... Sum(Sales) - Sum(Expenses) ...
Excel to Sheets; #NUM! and imaginary problems - Google Docs ...
https://support.google.com/docs/thread/180114393/excel-to-sheets-num-and-imaginary-problems?hl=en Sep 20, 2022 ... Any ideas how I can convert this file, or change the formulas to work in google spreadsheets? ... negative result for the primary part of your ...
Turn cells negative based on content of another cell - Google Docs ...
https://support.google.com/docs/thread/18990130/turn-cells-negative-based-on-content-of-another-cell?hl=en Nov 8, 2019 ... Thank you to anyone willing to help; this is my first time trying to use formulas. I'm trying to turn the numbers in the cells in column D ...
make an array negative (ie change sign) - using index() or similar ...
https://support.google.com/docs/thread/132310162/make-an-array-negative-ie-change-sign-using-index-or-similar?hl=en Oct 24, 2021 ... Currently a formula in column A:A returns a row to look up. Then in B:B have this formula. =index(sheet 2!A1:M50), A1, 0).
How, when using QUERY in Google Sheets, can I return the ...
https://support.google.com/docs/thread/119035539/how-when-using-query-in-google-sheets-can-i-return-the-negative-of-the-values-in-the-column?hl=en Jul 28, 2021 ... ... negative of the values in the column? This is my ... In the process, I learned that the LABEL function must come after the WHERE function.
Automatically make column negative numbers? - Google Docs ...
https://support.google.com/docs/thread/14294681/automatically-make-column-negative-numbers?hl=en Sep 13, 2019 ... Thank you for replying. It changed the numbers to negative but the Sum column (G) did not change. It still calculated column B as positive.
How to disable annoying log warnings?
https://groups.google.com/g/microsoft.public.excel.charting/c/YPCJmsAIB0s Aug 22, 2000 ... Negative or zero values cannot be plotted correctly on log charts. Only positive values can be interpreted on a logarithmic scale.
Google Sheets function list - Google Docs Editors Help
https://support.google.com/docs/table/25273?hl=en Rounds a number up to the nearest integer multiple of specified significance. If the number is positive or negative, it is rounded up. Learn more. Math, COMBIN ...
Deriving a percentage from two time values - Google Docs Editors ...
https://support.google.com/docs/thread/258226830/deriving-a-percentage-from-two-time-values?hl=en Feb 11, 2024 ... But this gives me the error, "Function HOUR parameter 1 value is negative. It should be positive or zero." Can anybody help? Details. Sheets ...
Sheets: How do i input a negative value? - Google Docs Editors ...
https://support.google.com/docs/thread/15019973/sheets-how-do-i-input-a-negative-value?hl=en Sep 22, 2019 ... But if I change the locale to Norway from windows, then open it from my iPad, negatives go in as text.
Solver not working
https://groups.google.com/g/microsoft.public.excel.charting/c/4XSvGlJwCdU Dec 1, 2009 ... Microsoft MVP Excel 2000-present www.tushar-mehta.com. Excel and ... turn into: C1 =(A1-B1). This creates negative and positive number, where
How to set a "Data validation" for cell expecting a number? - Google ...
https://support.google.com/docs/thread/200771014/how-to-set-a-data-validation-for-cell-expecting-a-number?hl=en Feb 6, 2023 ... ... formulas =isnumber(indirect((ADDRESS(ROW ... By this, the cells will allow any positive and negative numbers greater than -1000000.
EDATE - Google Docs Editors Help
https://support.google.com/docs/answer/3092974?hl=en months - The number of months before (negative) or after (positive) start_date to calculate. Notes. Ensure that the start_date input to the function is ...