between 2 values

Hey, I am trying to calculate a percentile of salleries in a table if they've worked between 24 and 60 MonthsWorked Sallery 22 12124 23 12462 24 12521 24 12523 28 125232 60 13542 62 13800 What I've done so far which actually works: 25% Percentile sallery Monthsworked <24...

I am trying to come up with a way to calculate the cost for a project. There is a sliding scale included with a lower percentage of cost for a higher value. For instance the first range is 0 to 500, so the first 500 would be multiplied by 1% to get a cost of 5, and so on. Starting, Ending...

I'm needing help with as time range IF statement I'm working on. I have in Row 1 (starting in Column D) time listed out in 15 minute breaks starting at 6 am. It is in military time currently. (06:00, 06:15, 06:30, 06:45, 07:00.... 23:45, 00:00, 00:15....) In Column B2 I have the start time...

I'm trying to make a formula that basically says if this number (4.57) is between B and C, then pull in A. Since there is more than 7 options, a regular IFTHAN statement won't work. I just can't think anymore and need help. <colgroup><col><col><col></colgroup><tbody> A B C 0 - 6 mo 0 0.5...

0 down vote favorite I want to loop and extract all the rows between two different words (For Example, 56050067 and 56050068) that repeat in a column. This code get me just the first range Thank you for intance Code: Sub copy() Dim rownum As Long Dim colnum As Long Dim startrow As Long Dim...

Hello. Thank you for the help you have given me over the years - this site is my number excel reference! This time, I just can't figure it out :-( I am trying to get right a small part of what will be a bigger formula. Can you tell me whats wrong with this: Excel gives me an error message about...

I am trying to get the numbers in between the "+" from data, except if there is a "(" then I want only the numbers between the "+" and the "(" here is an example of the data 5215983+14(BH)+XZD 5215983+13+DFG 0896458+2(YZ)+XZD 5215983+10+XZD 9874289+14+XZD 5215983+8+XZD 5215983+7(HF)+YZD...

This is the code that I have for conditional formatting. What I want to happen is as follows Cells that contain numbers between 0 and 1 to be red Cells that contain numbers greater than 1 and less than 100 to be yellow Cells that contain numbers equal to 100 to be green Here's the current code...

How do I make the form if: X = 1-50 then 81 X = 51-100 then 108 X = 101-200 then 158 I can only do the first one :( Please help. //: Dan

Hi all, apologies if this has been answered as the forum software won't allow searches for the word "between"! I need to check if a monetary value (2 decimal places) is between two numbers. I've been using the usual if(and()) approach but it's sooooo clunky. I found the MEDIAN approach and...

Hi All, I have been toying with some Excel 2010 data and I am trying to perform a lookup if the lookup value is between 2 other values. I have given an example of the lookup table below: Excel 2010 <colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead> A B C </thead><tbody>...