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...
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...
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)...
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...
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...
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...
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...
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...
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...
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...
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...
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!
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...
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...
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
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...
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...
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...
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 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.