positive negative numbers

  1. D

    Absolute Value with SumIFS

    Hey All, I'm trying to get a 90 day total from a set of data, using the absolute values of the data, as some of the data comes back as negative numbers; column A is the date the data was entered, column C is the data values. I have a formula to get the 90 day total (shown below*) but I'm...
  2. H

    VBA Loop Until Positive Balance is Achieved

    <!--StartFragment-->Hi ExcelVBA Gurus, I hopeyou guys are doing well. I am trying to create a code using IF statement for myFunding file. Where ina Vendor is paid if Invoice (positiveamount) is > Credit Memo (negative amount) on a particular due date. If thenegative amount is greater than...
  3. R

    Convert every cell of numbers to positive numbers in an entire excel file

    Hi Guys, Im trying to change every single number in an excel file to a positive number, no matter if its negative or positive, every single number should be shown as positive, is there any quick form to do this without needing to click every cell manually and writting the amount without a -...
    • riverad
    • Thread
    • convert numbers positive negative numbers transform
    • Replies: 1
    • Forum: Excel Questions
  4. J

    Macro to highlight Positive and Negative Numbers

    Hello, Does anyone know of a macro that will search a column in Excel and highlight duplicates positive and negative numbers. Any assistance is greately appreciated. <COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY> Values A 100 200 300 400 500 600 700 800 -100 -200...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top