About 1,410,016 results (5,593 milliseconds)
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.
Sum (product) only positive numbers in column where data is ...
https://support.google.com/docs/thread/88015074/sum-product-only-positive-numbers-in-column-where-data-is-grouped?hl=en Dec 10, 2020 ... I have positive and negative numbers in a column I. Data in the column is grouped. I used this formula but it doesnt work.
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 ... Now with your array formula suggestion (Thank You!), I could import just the rates (B11:D12) which would convert them to positive numbers. But ...
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 ... You can automatically get all-positive numbers by inserting a new column Q and putting this formula in cell Q1:
Calculating Positive and Negative Numbers across Sheets ...
https://support.google.com/docs/thread/125665024/calculating-positive-and-negative-numbers-across-sheets?hl=en Sep 13, 2021 ... The rest of the formula is working perfectly, it's just the negative number from the ACP that's not being calculated. It is still part of the ...
Sum of positive and negative values - Google Docs Editors Community
https://support.google.com/docs/thread/18226557/sum-of-positive-and-negative-values?hl=en Oct 31, 2019 ... One of the tabs is a summary of all expenses, depreciation, principal paid, etc. My issue is that I can't figure out how to formulate a cell to ...
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 ... ... number and the value is still calculated as a positive number on the rest of the spreadsheet. It´s just a visually a negative number. How to ...
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 ... Two validation lists have been created one with postive numbers and the other for negative numbers. Now, maybe this is not how this should ...
Is there any way to put possitive numbers in a color and negatives in ...
https://support.google.com/docs/thread/10408874/is-there-any-way-to-put-possitive-numbers-in-a-color-and-negatives-in-other?hl=en Jul 22, 2019 ... This will require two conditional formatting rules one for the positive and one for the negative. To do this select the entire range you want this to apply to.
how to find the first positive/negative number based on a certain ...
https://support.google.com/docs/thread/239760285/how-to-find-the-first-positive-negative-number-based-on-a-certain-condition?hl=en Oct 18, 2023 ... The formula above is an array formula that fills all of the column ... Your sample spreadsheet is view-only. If you need more help ...
Sheet not showing negative numbers consistently - Google Docs ...
https://support.google.com/docs/thread/181677675/sheet-not-showing-negative-numbers-consistently?hl=en Sep 30, 2022 ... At first when I entered the number in parentheses, it did not calculate ... If you want to use positive numbers only then you will need an extra ...
Conditional formatting formula for Matching positive and negative ...
https://support.google.com/docs/thread/238755205/conditional-formatting-formula-for-matching-positive-and-negative-numbers-in-a-column?hl=en Oct 11, 2023 ... I know how to conditional format for duplicated numbers. What I need to do is match the positive and negative amounts in a columnand color them.
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 ... I have this formula which at times, based on what's in C8, will return a negative number. How can I make these instances of negative returns ...
subtract a positive from a negative
https://groups.google.com/g/microsoft.public.excel.worksheet.functions/c/0gi9nhx1DIA I need a formula that will subtract positive numbers from negative numbers "and" negative numbers from positive, with the answer in the correct form.
The Minus function is not working in my spreadsheet? - Google ...
https://support.google.com/docs/thread/87136123/the-minus-function-is-not-working-in-my-spreadsheet?hl=en Dec 6, 2020 ... For example, if you had a column of Credits and Debits, the Credits would be positive values and the Debits would be negative values and you ...
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.
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 ... I am continously entering data values into column A, sometimes the values i enter are negative values. I have a cell in column B that `Sum`s the ...
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 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 ... You can use Data Validation to do this and shouldn't need a formula. ... By this, the cells will allow any positive and negative numbers greater ...
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.