negative

Hi Mr Excel, How do find Number Pattern in data which is : 1. Starting a Negative value ( - ) 2. Follow by at least a Zero ( 0 / 00 / 000 / 000..... ) 3. Follow by a Positive value ( + ) 4. End with a Negative value ( - ) Number Pattern : - 0 + - When Number Pattern found, assign "1" at...

Hi, I'm trying to work out the percentage increase from a negative number (-21) to a positive number (941) but I'm very confused...can anyone help please? Thanks Richard

Hi, Does it possible to generate result in Column H? From the past data, the max positive value appear (>=0) is below 100 row. My data range between 250k-750k row...

Hi Excel Experts ? Sample of 20k row data I face weekday : BCDEF1Sum of Negative Sum of Positive2ValueExclude 0Include 0Exclude 0Include...

When calculating the difference between two dates and one date has not occurred you can get a negative number. How do I turn that negative into N/A?

Hello guys, This query is quite specific to a model I'm putting in place but I hope you can provide me with a solution to make it work. With the table below, I'm trying to come up with a formula that gives me the avg number of quarters that takes a balance to switch from negative to positive...

Hi, Column A // Column B -0.1 // 1 0.1 // 2 -0.1 // 3 0.3 0.7 0.2 // 1 -0.2 // 2 -0.2 // 1 0.2 // 2 0.7 // -0.5 // 1 0.5 // 2 -0.5 // 3 0.5 // 4 0.5 // 0.3 // Rule: 1. The starting value can be negative or postive 2. Reset the count if :- i- value is...

I have the following problem: I have a number of data entries with following fields ID, Name, Category, Amount - currently in Excel columns. The aggregate of Amount will equal zero, ie there are positives and negatives - but it will not necessarily equal zero for each Category. I need an...

Hi, I'm sure this is quite simple but I'm not getting it. I want to subtract to time values where the result (in this case) will be negative: Time A is entered manually as e.g. 13:30 Time B is a result of a calculation and shows as 16:00 The result should be -2:30?? I've tried different ways but...

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

Hi! Hoping someone can give me some help here. I have a spreadsheet for tracking jobs and work hours. I have a sheet to archive projects to have a running track of all of them. I'm looking for a way to move a whole row from my working sheet to the archive sheet when the days from job reaches a...

Hello all, Bit of an amateur trying to learn more on the use of Macros. Hoping for some assistance with this issue: I want to be able to search through my data to find rows where Column D displays "Negative".If it doesn't display "Negative", just move on to the next row. If it does display...

Good morning all! I need a formula that does the following: If one cell is negative and the other is positive return NA, but if both are positive or both are negative D4 (for example) I know it should be something along the below, but not sure how to write it to function properly. Thank you...

Hi, I have the following code in N2 =(E2*0.1)-35 And it is showing a negative number which is correct. The issue is, I want it to show 0 if the number is negative, how can I achieve this please? Thanks again.

Hi Everyone, I’m trying to create a formula that uses both negative and positive percentages and doesn’t have any false statements. I would like it to be if cell G10 is >= -30% then G12 should display “partial response”, if G10 is <-30% then G12 should display “stable disease” or if G10 is >+20%...

Dear professionals, when a cell result in ANY positive value, example such as "10%", I would like the very same cell to display as "Underestimate 10%" on the other hand a cell result in ANY negative value, such as "-5%", i would like the very same cell to display as "Overestimate 5%" Please...

Hi All, I have a data of all positive and negative values like -400 200 200 -100 100 -500 250 250 300 -150 -150 I have multiple formulas to identify the matching numbers but all i want is modifications I have data in A1:A100 I use the B1...

Dear community, I need to match up a negative number with a positive number that would make the value zero. I tried to use the COUNTIF formula (e.g. =COUNTIF($Q$2:$Q$30210;Q2)<>COUNTIF($Q$2:$Q$30210;-Q2)) but it doesn't work at all. Any suggestions? I would like to run a macro, because i have...

hello, I have a table I would like to sum the largest negative sums and also the largest positive sums within a column, the table will illustrate below; <tbody> A B B 1 1 =a1 1 2 3 =a1+a2 4 3 -2 =a2+a3 2 4 -3 =a3+a4 -1 5 7 =a4+a5 6 6 -3 =a5+a6 3 7 Largest Positive Sum 6 8...

I have a Worksheet, which includes a stack of cells, that contains positive and negative values. I could really use a code that revers alle the number into positive, that i eventually could run every time. Please help Best regards Solaiman