positive

So most charts plot a positive X and positive Y and look kinda like this: Others have negatives - so the zero point is in the center, where the X and Y axes intersect: Do these two different graphs have different names? Like, if I said I wanted a "transgential interspecular graph", a...

Hey I'm wondering what formula to enter into a cell where I want it to return the value 1 when the cell it is looking at is a negative number? Also.. if the cell it is looking at is positive I want it to do -Q25/R21.. if that's possible!? Thanks!

Hi Just a quick question I have a simpe formula =GT274+GY272 but i want to return a "0" if GY272 =0, GT274 will have a value which will be either positive of negative. Thanks Stephen

Hello I have a column of data and I would like to count the number of cells containing only positive numbers. Also some cells have parentheses, brackets, less than symbols. I would like to exclude all these and only count cells with a positive number. Below is a typical column I would...

Hi, Appreciate any help here. I'm looking for a formula that searches a column and runs a count of positive numbers after the appearance of the last zero or negative number in that specific column. Essentially it's looking for a positive trend. If for example the current trend is 2 (2 positive...

Good morning :) , I need a formula which could lead to below, If the cell P9 has a negative value, the cell W9 will calculate (M9+N9+ABS(P9)+S9+U9). And If the cell P9 has a positive value the cell V9 will calculate (T9-J9)*1440. Thank you in advance :)

Hi Forum I would like to change a few cells that appear as negative numbers to positive numbers.

I'm trying to modify this field which currently gives a positive result if over or = to 3, then minus 2%. I want it to give a positive result for 3 or over, and equal if exactly 2 with no minus 2%. =IF(ISBLANK(I5),"",IF(K5>=3,(M5*(G5-1))*0.98,-M5)) I would be really grateful for assistance as...

I have a list of stores and some amount transactions that took place at those stores in excel. Store 1 name (bolded) 45 -45 34 68 16 88 89 66...

Hi there, I have a sheet that shows the number of hours above or below a standard working day a person has worked. I need to then sum these. The formula I have (column R) is fine if the outcome is positive (row 3) but not when negative (row 4). Any ideas please...

Hello, I m trying to add SUMIF, there are positive and negative numbers, I would like to sum only positive numbers. I tried this : "=SUMIF($F$1:$BR$1;1;IF(F4:BR4;">0"))" it show #VALUE! I tried many some others way but still unsuccessful thank you )) Excel file ...

Hi I did write only this code [red]#,### now when I type positive or negative numbers they will show as expected but when I type 0 nothing appears? and when I type Text, text will be shown but in black color Why the above code applied to negative numbers? I thought it would apply on...

Hello, I have a formula that is kind of working but is out. <tbody> Responses Positive 93% Need Neutral Negative 100 93 92% 0 6 1 </tbody> The responses are Positive + Neutral + Negative and the results are calculated by Positive(B2) - Negative(F2) / Responses(A1). The Formula for that...

This is the formula I have now: =Sumifs(p2:p10,g2 :g10,"x",f2:f10, "male") How do I add only positive values in p2:p10? Thanks in advance Kelly

I have a worksheet that starts from column D1 to column S1 down. Column D contains IDs that I use to look up the data to this sheet. Column O contains values which may be positive, negative or blank. I now wanna separate the positive and negative numbers to different sheets. So with the...

Good morning all, I have in an Excel sheet a long vertical list of ~random positive and negative numbers. Starting from the first number at the top, I'm looking to average 2 consecutive numbers downwards, and flag them if they average to a positive number. I also want to check if either or...

Any help would be greatly appreciated. I have figured out everything, but there is a slight curveball now. Here is the situation: If the DEAL GROSS is a positive number and FINANCE is a positive, then the max finance Commission that can be awarded 5% of Finance, not to exceed 100...

I have formulas in in Col O If the data in say B3:M3 are negatives, the formula to use =large(B3:M3,12) . if positive values then use large(B3:M3,1) The values in the row will either all be positive or will be negative I have tried to use the formula below , but get #value ...

Hello Forum, We are trying to determine the minutes spent for a number of rows per device, but only when the minutes spent is categorized as a "true positive." So our logic looks like this: add minutes if (device name) and (true positive) then subtract (start time) from (end time) device name =...

Is there a quick way to get the sum of only positive or negative numbers. I have 21 columns, some cells will be positive and some will be negative, but none will be zero. In column 22 I would like the sum of all the positive numbers and in column 23 the sum of all the negative. Thank you.