positive

  1. rjbinney

    What's This Graph Called (Not Really an Excel Question)

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

    If result if negative then return value 1

    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!
  3. T

    Dont Sum if Zero found

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

    Search thru range of cells and count cells containing only positive numbers

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

    Conditional running total

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

    IF Function (Negative/Positive values)

    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 :)
  7. S

    Negative to Positive

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

    Coulkd someone help me correct this please?

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

    get specific numbers from a list of numbers

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

    Calculating 'Negative' Time

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

    SUMIF Nth cell with only positive numbers

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

    [red]#,### format is not displaying 0

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

    Round up formula

    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...
  14. kelly mort

    Adding only positive values with sumifs

    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
  15. kelly mort

    Look up Formula Challenge

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

    Identifying consecutive data that average to a positive number

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

    Help, help, help!

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

    USING iF WITH LARGE FORMULA

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

    Time Spent When Two Variables Are Present

    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 =...
  20. wallyxl

    Sum of positive or negitive values only from a list

    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.

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