higher

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

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

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

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

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

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

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

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

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

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

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

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

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

disregard pls..thx

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

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

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

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

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

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