positive

  1. M

    How to handle percentage to goal with 0 and a negative number

    Hello! In my day to day job, we have goals set (for each month) that can be either positive or negative "net adds", and I can reach negative or positive actual net adds by the end of the month. I am having issues getting excel to populate my percent to goal under the following parameters: My...
  2. wadergirl

    Formula - Sum only Positive Amounts but display as a Negative

    I'm currently using this formula in cell B7 =SUMIF(A1:A7,">0") to sum only the positive amounts in my data set, but I need it as a NEGATIVE. I know I could use =B7*-1 to turn that positive result into a negative, but I'm having trouble combining the two into a single formula. This is what I'm...
  3. J

    Creating a pivot chart to show survey results

    Good morning all, I have a problem I've been trying to solve for a while and I can't seem to find a good way to do it. I have survey data which needs to be visually represented in charts. Participants are asked a number of questions and can answer 1-6 (1 being the lowest, 6 the highest)...
  4. C

    Average of Count of Positive Values in a Row - with Gaps

    Hi all If I want to find the average of the count totals of consecutive positive values in a row, with gaps of zeros, what formula could I use? An example would be: 1 1 1 1 2 2 2 3 1 1 0 0 0 0 0 0 0 1 2 5 3 3 2 There are two consecutive rows of positive values within the row. The first is...
  5. M

    Formula for Summing A Streak and Restart The Sum after Streak Ends

    Hello, I want to try and sum a streak for both positive and negative numbers, but once the streak stops, it will restart a new sum. As you can see in row B2, If I input a positive number, I want a formula to sum it in B3, if it is a negative number, it will sum it in B4. In cell D3, it sums a...
  6. M

    Sum A Streak and Restart Sum after Streak Ends Question

    Hello, I want to try and sum a streak for both positive and negative numbers, but once the streak stops, it will restart a new sum. As you can see in row B2, If I input a positive number, I want a formula to sum it in B3, if it is a negative number, it will sum it in B4. In cell D3, it sums a...
  7. Leicester City Fox

    Recording positive and negative time formula

    Hi There I have two columns stating time Column A, Planed Time Column B Actual Arrived time. For Example, planned time: 08:35, Arrived time 08:36 = (Difference) 00:01 But when it a negative time ie earlier than planned time it will not work this out. Also I notice the actual arrival Time has...
  8. P

    Power Bi how to meke continuous exceed 4 days (positive), will automatic show total Positive days

    Hi all At Power Bi how to make it? If the customer have positive for continuous 4 days, will automatic show how many days.No matter on which day, as long as continuous 4 days. example 1: kent continuous already exceed 4 days (positive) , he total got 6 days (positive). then automatic show me...
  9. S

    Find the first positive number after deducting from a range of numbers VBA

    Hi all I have to find a way to solve this problem. I have a column with different numbers for example x1 x2 x3..x1000, and a specific range of 125 y1 y2 y3.. y125 numbers. i want to find which x number is closest to a y number. So i was thinking to do y1-x1= and y2-x1= and y3- x1= and so on. the...
  10. B

    Calculated Field based on results of another field.

    Good afternoon. As basic as possible: I have a field (Response) with 5 different possible results (V Likely, Likely, Neither, Unlikely, V Unlikely), coming in by month (01/mm/ccyy). In a pivot table, I am representing these as percentages of parent column (month), so for example I have those 5...
  11. M

    If statement issue

    I need help please, I have various conditions and got this far =IF(AND(W687>0;X686>0);(W687*Y687*G687)+X686*Y687*G687;0) only problem is that if cell W687 is negative it should still perform the calculation for X686 if this cell is positive. How can I change the formula to do this. Thank...
  12. J

    deleting all rows with positive numbers in vba

    hi i have an exel list with a column with both positive and negative numbers. ive recorded a macro to delete lots of columns and rows but the last step is to delete the rows with positive numbers. what code can i use? i cant write code, only record macros!! thank you!
  13. O

    How to combine two formatting together..

    Hey everyone! I have Number Formatting done on selected cells that will output + or - signs along with the numerals. For instance if number is 25 this will be shown as +25 the formatting code is as such +0;-0;0 However I would also like for the 0 values to appear as blank alongside the above...
  14. N

    Format Cells custom set up

    I am looking to use format cells options to have a prompt that shows up in the cell to give direction such as "Enter Work Code Here" or " Work code Here" when there is nothing in the cell. Once its been entered, the messages is not long displayed unless the number and letters are entered...
  15. S

    Negative result add and positive subtract

    Good morning, I have a doubt that I do not know how to solve, I need that when the result of a cell is negative add up and when it is positive I subtract it. I attach an example. Thank you. https://we.tl/t-CpPDWGBKLDhttps://we.tl/t-CpPDWGBKLD
  16. A

    multiplying a product by a different percentage based on a positive or negative number

    Hello, i have a spreadsheet that i use to compare projected costs to actual costs. Column C are projected costs, column B are my actuals, and i want column D to have the difference multiplied by a certain percentage based off of a positive or negative return. I would like the difference in these...
  17. xeven_

    What is going on here?

    <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody> 2012 $13,641 4% 2013 $13,057 -4% 2014 $15,233 17% 2015 ($6,145) -140% 2016 $6,845 -211% 2017 ($8,920) -230% 2018 ($22,802) 156% </tbody> I am using...
  18. D

    Pivot Table - Top 10 positive

    Hi there, I have a pivot table where I want to filter the top 10 value (gap of 2019 vs 2018) and I am not able to do it properly due to mix of positive and negative value. If I use the Value Filters --> Top 10, I get the top 10 absolute value, but I want only the positive one. I will get so far...
  19. L

    Small macro to convert value

    Hi all I have a recurring need to convert a large number values that come in from another system and it would be helpful to be able to do this by way of a small macro. What I would like if possible is for a macro to run on a range of cells selected by me at run time and then convert all of the...
  20. M

    Positive / Negative numbers (with brackets) align right

    Hi, I currently have a listing of positive and negative numbers (ranging from numbers in the tens to hundreds to thousands to millions) and am looking to have all numbers aligned right excluding the ending ")" for all negative numbers. In other words, would like the alignment of all numbers and...

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