negatives

  1. P

    Negative Values Not Showing as Negatives

    I am working on a time tracking spreadsheet. If a Leave balance goes over the available leave minutes the Balance should show has negatives. While my formula works if the Days (D) or Hours (H) are negatives... the minutes (M) does not show the values as negatives, it shows the absolute value...
  2. T

    Double Negative and If statements

    I have the following formula in cell A13 IF(AND(H6>0,J8<-0.02,L6>-0.02),"MANAGEMENT SIGN-OFF IS NEEDED",""). If the value of J8 is -.01 the true statement appears but -.01 is not less than -.02. I know it has to do with comparing double negatives. The problem is sometime the result in J8...
  3. R

    Formula to find 2nd largest in a range including negatives, ignoring zeros

    Hi I'm looking for a formula to find the 2nd largest in a range including negatives, but ignoring zero values. eg, range of values is 8 0 -2 0 -6 -8 -9 I have tried to calculate a formula which gives me -2 as the second largest value, but had no luck. Can anyone kindly assist? Kind...
  4. S

    How to graph data which is widely distributed (both neg and pos values)?

    Hi, I have a dataset which is widely distributed. A log chart can display the pos values fine, but I need the same treatment for neg values also which obviously rules out log. My values for example range from -5 to +5 for both axes. There are a lot of data points in the 0 to .03 range and -.03...
  5. P

    How can I display the pivot table display of a calculated field as an absolute value

    I have a pivot table in Excel 2013/Office 7 that is calculating a change in our operating income from year-to-year and showing the difference as a percentage. In my Value Field Settings it is: *Show Value as a % Difference, Base Field is Fiscal Year and Base Item is Previous Year. In the...
    • PSU145
    • Thread
    • abs function abs in pivot table result negatives pivot calculated field
    • Replies: 0
    • Forum: Excel Questions
  6. R

    Difference between positive negative (any variation)

    <colgroup><col style="width: 75px"><col width="75"><col width="75"><col width="75"><col width="75"><col width="75"><col width="75"><col width="75"><col width="75"><col width="75"><col width="75"></colgroup><tbody> Score Yards/Point Yards / Play Offense Defense +/- Offense Defense +/-...
  7. andrewb90

    eliminating negative numbers in a cell

    Hello, I have a daily worksheet where the grand total sales will carry from day to day. (cell B3) in cell B2 I put in the new grand total amount that I got from my register report. With that put in, B6 calculates the total sales for the day (B2-B3). My problem with this, is that until a...

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