higher

  1. W

    How to use nested IF statement with a running total?

    I am trying to use a nested IF statement but I can't get it to work. <tbody> Year 2012 2013 2014 2015 2016 2017 Amount 0 15 34 54 67 88 Running total 0 0 2 3 4 </tbody> In cell H34 (running total for 2013 = 0): =IF(G34<>0;0; IF(G33+H33>50;1; IF(H33+G33>70;2; IF(H33+G33>150;3...
  2. R

    [VBA] Do Until range ("W1").value >= TGT (0.2)

    Hi all, Have a value in W1 that started at 0.13 (or 13%) I'm trying to execute a loop up until the point where the value in W1 exceeds the TGT, which is set as "0.2" At the bottom of the loop, the value in W1 updates to be higher or lower. Currently, starting at 0.13 and aiming to be equal...
  3. B

    Count Repeated Numbers

    Hello All, I need help with a formula to count the repeating for each number in multiple columns as shown the table in data range A1:X1. The result that I am looking for is as in the range Z1:AE1 where the number with higher repeating count on the left. For example Z1=5-3 where #3 with higher...
  4. O

    INDEX / MIN Issues

    Hi. Please see ‘Example’ file via the link, below. https://1drv.ms/x/s!AtIvkRgReIvwgRcNSvXr5zlzQZXA My problem relates to columns BF and BG in certain cases. In cases where the finishing position is the same in column BB and BE (sub-event #1 and sub-event #2: green highlighted area), I...
  5. D

    Conditional Formatting with multiple formula/criteria

    Hi Everyone, I am having a bit of trouble with conditional formatting. I feel like I am losing my mind! What my boss wants is the value in cell E to be a certain colour depending on the value. If H is higher then E, color it green If H is higher than E by 500 then color it yellow If H is...
  6. E

    Formula for highlighting number that decrease cell by cell and percentage difference of each cell

    This is a little hard to explain but I have two things i would like to achieveI am an extreme newbie so any help even written formulas for me to try would be wonderful 1. What I would like to achieve is starting from cell A2 and working to the right of the cell---> to the next cell B2 if the...
  7. H

    Sum of last 5 values higher than zero

    Hi, I am trying to sum the last 5 non zero values in row 241. . Please help. Also posted here https://www.excelguru.ca/forums/showthread.php?9989-Sum-of-last-5-values-higher-than-zero
  8. A

    Percent of a number from a total number

    Hello, I am trying to figure out how to calculate a percentage by taking a total number and figuring out what percent of it is another number. Example: <colgroup><col width="56" style="width:42pt"> </colgroup><tbody> 31 20 19 17 15 15 15 14...
  9. M

    Assign numbers in block of 10 starting from lower to higher

    Hello,</SPAN></SPAN> In the column "D" I got the numbers disordered, they can be from 0 to 3000 max. </SPAN></SPAN> I need to assign them in column "E" in blocks of 10 (1-10, 11-20...etc.) starting from lower to higher as per example shown below.</SPAN></SPAN> <COLGROUP><COL...
  10. D

    Complex Bullet POint Addition

    I know how to add bullet points generally to and excel cell. The problem I am having is I already have multiple lines of text in one cell in a giant spreadsheet someone else made. We want to use bullet point to show where the new line of text is in each cell And I have not been able to figure...
  11. Z

    Move Row to different work sheet if condition is met

    Have Column P that contains amounts from .01 to 20000 but also can contain blanks, 0, $-, # N/A, possibly others If a cell in Column P has a value of .01 higher, I would like nothing to happen and then review the next cell in P. If it doesn't contain a value of .01 or higher, I would like to...
  12. D

    Closest Value

    Hi, Please help me, i need to get the closest number from the value from the Lower/Higher column. Let say value 5, the closest is the Lower number which is 7. Thanks <colgroup><col><col><col><col></colgroup><tbody> Value Lower Higher Result 5 7 11 7 7 9 13 9 4 5 9 4 15 17 21 17 32...
  13. U

    function

    Hello and sorry for my bad English. I want to create a formula or logical function that will set lower or higher valuses in range of 10 and 15.... so the thing that i need is when i pick values under 10 and the fromula will set the lower range number ( 10 ) and if i pick values higher than 15...
  14. L

    SUMPRODUCT combining two and more criteria for check

    disregard pls..thx
  15. G

    Formula for larger numbered mode if 2 modes are equal

    Hi all - new here but have been searching out answers for a grading program I'm using at school. For this program, we calculate the most common number but also the 2nd most common number. If those are equal, it typically spits out the first number in the sequence - when I'd like it to spit out...
  16. L

    multiple lookup question

    Hi I would like to find out those days that either NY temperature of 29 or higher or LA had a temperature 26 or higher. I would like to know the date that it occurred and what the Price and Nextday-prices were. Any help would be very much appreciated. Thank you. Sample of the data...
  17. J

    Comparing three columns for the rank.

    I am way in over my head. I'm trying to make a spreadsheet for our future events that would automatically rank the people via the highest of three scores. In case of ties, it will then compare the other two scores to see who had the highest one there. If there are still ties, then whoever...
  18. J

    Formula for counting how many times value in cells above are higher.

    Hi I wonder if any of you experts could point me in the right direction please? I've tried with no success. I have a spreadsheet with staff names across various quarters, I also have a column that indicates which quarter was first and which last. I need to compare row with first and last...
  19. I

    What is wrong with this SUMIFS formula?

    I'm trying to calculate sales based the customer's start date, and between certain months. Every SUMIFS formula is giving me numbers higher than my data sheet. Formula below: =SUMIFS('[ConversionEnd Data.xlsx]Page1_1'!$D:$D,'[ConversionEnd Data.xlsx]Page1_1'!$A:$A,$B5,'[ConversionEnd...
  20. D

    Need a function that input a value and a range, output where the first cell value in that range is bigger than the value

    Details: A1 contains a number, range B1:K1 contain also numbers. The function will get both the value of A1 and the vales inside the B1:K1 range. It will check where is the first time a value inside that range (beginning value in B1) is higher than A1, and output a number that represents the...

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