positive

Hi All, I have created a set of bubble charts. The 'Z' value has positive and some negative values. When positive, the bubbles look fine. But when negative, the bubble disappears and no negative values are shown. How do I fix this? Thank you in advance.

I can't quite figure out the formula for the following scenario - We are looking at counts and adjustments so we want to see positive and negative % differences. The problem is if the book quantity is 0 and the count quantity is 0 and the book quantity is 0 and the count quantity is anything...

Hello, I have a table with 40 rows and depending on input the values change from positive to negative. So with an inflation rate of 2.5% then row 23 will be the first row in negative numbers, if I change inflation rate to 1% then row 28 will be the first row in negative. How do I conditionally...

I am trying to add negative time, hours and minutes (-1:32) to positive time (0:34). These are totals for hours worked above 40 hours. I have changed to the 1904 date system but my formulas aren't working. I'm not very familiar with Excel. I'm trying the formula =SUM(A1+A2) with A1 and A2 being...

Hi all I have 3 columns of data. In the first and second columns I have a series of values and in the third column I need to use a formula which looks at the second column to see if there's any non-zero positive number there. If there is then it must use that number and it must thereafter look...

Good Afternoon :) I know that Speedometers are not everyone's cup of tea, but I was after some assistance, please. I've searched this forum for an answer but nobody has asked the question, so here goes... I have managed to put a speedometer together but am stuck on negative and positive %...

I have thousands of rows of data that I have to look through to see if there are matching positive and negative numbers matching by ID and then move the matching pair to a different tab. (Or at the very last highlight I have been trying to find an easer way to do this then having to manually do...

Hello there, I have problem with my formula my brain is stuck and cant find a way to continue. Atm my formula looks like this: =--IF(G6>2999,99;(G6*0,03);IF(G6>1999,99;(G6*0,02);IF(G6>999,99;(G6*0,01);IF(G6>0,01;0)))) In G6 I have positive numbers I wanna make it keep going that way if the...

Hi and thanks in advance! I haver a huge table in a tab (coming from a Macro, CSV, a FOLDER with multiple files...) One othe Columns shows totals for account numbers The totals are some time Adjusted by someone, so the same deal may have positive values and negative values(Adjusted) I DO KNOW...

Hi I have the following code: With Worksheets("Daily Tracking") MsgBox "You have now run " & MlsYTDLessLastYr & "miles " & _ If(MlsYTDLessLastYr < 0, "less", "more") & _ " than this time last year ", vbInformation, "Mileage Compared To This Time Last Year" End If End With...

I have a file which shows monetary values in one column. The majority have a number format (positive values - these are correct). Others have a custom format which shows them as - numbers eg -36.50 (but these numbers are actually positive). How can I easily make the negative ones actually...

Morning all I have a problem with my SUMPRODUCT formula. I have one column in my spreadsheet which contains P&L expressed as -£1.00 or £1.00 the columns are formatted as currency. However I want to get the total P&L from these columns based on Month and Year (though that is not important in...

Hi all, Here is my sheet: See the tab called top line https://docs.google.com/spreadsheets...it?usp=sharing Looking at my spreadsheet You can see in cells E3 and E4 there are amounts in the negative. This means I am owed money. For cells I2, I3, I4 and I5, the numbers are positive. Which...

There is a situation for which I am looking for a solution I receive a lot of data in an excel sheet, Let's say in column A and these are receipts(positive amount) and payments(negative amount) and these net to zero except few I already use a macro which matches positive to negative for...

Hi I am trying to work on a puzzle for my second grader to learn math. I am trying to dupelicate it in excel with rand number generator. Its a subtraction problem and sometimes the second number or third # is bigger than the first. Is there a way to program excel to hit F9 if the result is...

Hello, Is there a way to convert all negative numbers In a column to positive numbers? The thing is that, I am copying the value of cells with formulas to a different location with a vba script. So now I need a script that will convert any negative number to positive number. There may be...

I am struggling to solve the arithmetic and write an excel formula that can calculate the percentage of goal. The goal can be either positive or negative and the actual result can be positive or negative. Example -3 / -2 = -100% -2 / -2 = 100% - 1 / -2 = 200% 0 / - 2 = 300% 1 / - 2 = 400%

Hi, I have a set of data that is in wave format going from positive and negative numbers and positive numbers again.... (which I have marked "X") How do I get excel to identify these points between highest positives and lowest negatives...

Hello, Need some help with the data below with dates and numbers changing from positive to negative and positive again. At the point of change from positive to negative number, I would like to mark "X" and also from negative to positive number also mark "X" on third column. Can anyone...

Hello experts... I am trying to plot a stacked bar graph with 2 series. Series 1 is positive number Series 2 is a negative number but am using ABS to convert it to positive number When i plot the stacked bar graph, Somehow series 2 is still plotted as a negative series Does anyone knows what...