greater than

Hi, In this scenario, I need a formula to return a specific value based on (1) a criteria with an exact match, and (2) a range criteria where there is not always an exact match. Table 1 contains the criteria of the lookup (Year and Number), as well as the value I want the formula to return...

I am working with an exported spreadsheet from an application. I also copied and pasted to a new sheet as text only, but problem still occurs. When I highlight the column range of c2:c100 and set the cell highlight to fill in values greater than 19 (>19) The results are that the cell shading...

Hi all, I'm doing some analysis of data from two measurement systems, I want to see if the two processes are getting results within 10% of the allowed tolerance. The below link is what I'm dealing with in excel. Imgur: The most awesome images on the Internet I'd like to use conditional...

Hi All, I have a challenging formula I am trying to create. It essentially incorporates a threshold on profitability. Below I've laid out a simplified version of the data I am working with to help illustrate my problem. <colgroup><col><col span="2"><col><col span="6"></colgroup><tbody>...

I'm working on an employee schedule. I have folks start and end times as well as break and lunch times. I'm trying to create 1/0 for working/not working in 15-minute intervals throughout the day. My equation looks to say if the interval is less that the person's start time, greater than the...

Need guidance to how to make this formula read = 0 and Less than 5.00 but greater than -5 so -5><5 Also is there a way to have it label the ones summing to 0 "Zero" and label the ones less than 5 but greater than-5 "Less 5" =ROUND(SUMIFS([Amount],[Financial Complex],[@[Financial Complex]]),2)=0

Hi folks! Hoping your Friday is going well! Today's question is: Under the total column, I want an if/then statement to provide the greater of the two columns, 25. Can someone help me with this please? <tbody> A B Total 25 15 =formula to give me 25 </tbody> Thank you so much!

Hi - I have thousands of rows of data and I want to get the difference between the GTE Amount and the LY Award amount, but ONLY where the GTE Amount is greater than the LY Award. I'm using all named ranges. I get a value returned but it's not correct. Can I not do this with named ranges for...

Good afternoon, I'm trying to build an equation that will assign a particular value to a data set depending on if that value is <, between, or > than a certain value. Disregard flows for now, that will be coming from a separate spreadsheet. The remaining five categories are all on one...

Hello All, I am trying to use the xlfiltercopy action with the .advancedfilter function in vba to filter through some data and copy it to another sheet. The criteria for the filter, however, will be all values between two variable values that will change on every iteration of the filter, i.e a...

I need to count up all the machines that are less than 181 days old and older than 149 days. I can do this with sumifs, but not countifs. The sumifs formula I used that worked is below. I just need a count and not a sum...

I have two columns. Column A (Price) Column B (New Price). I want to highlight Column B cells that are Greater Than Column A cells. How is this done? <tbody> Price New Price $26.52 $30.00 $80.00 $80.00 $80.00 $80.00 $80.00 $80.00 $195.00 $200.00 $370.16 $390.00 </tbody>

i am setting up a report where the user can set certain inputs. These are then used to highlight entries in a report. How can i get something like indirect to bring each of the values from the input cells into my report? as an example: A1=6 A2=< A3=8 I can get the value for a1 and the value...

Hello, I am using an Index/Match formula and at the last function when I don't want to match the exact value (0 - because it rarely would) or take the lesser value (1 - because it is not as accurate) the formula usually outputs an #N/A! error when I have the input as -1 as to take the greater...

I have a fluctuating data in column A:A, a Fast MA in column B:B, Slow MA in C:C. I'm going to start with the first formula to compute in Column E:E, which 1. needs to display a prior value repeated at least 3 times consecutively (not in order of occurrence just needs to be in the formula...

Hi there! I'm working on a spreadsheet (using excel 2007) and I want to apply a conditional formatting rule that will change the cell colour if the H:MM is greater than 5:59. Because I'm going to be dumping info into the spreadsheet every day from another spreadsheet so I don't want to have...

I'm trying to use conditional formatting to format the columns (see below) [/IMG] I used the following formulas... (just using row Q for sake of example) Applies to: =$Q$4:$Q$24,$Z$4:$Z$24,$AI$4:$AI$24,$AR$4:$AR$24,$BA$4:$BA$24 Formula 1: =OR($Q4>$G$3,$Q4<$G$4,$AI4>$Z4) Formula 2...

I am trying to find the row number for a specific value where the value in the list equals or is greater than the value I am searching for. When looking for the exact value in a list, the following works: <tbody> A 1 4/15/2015 2 3 4/14/2015 4 4/15/2015 5 4/16/2015 </tbody>...

Having a brain lapse on how to do this formula where one of 3 results will be return.. =IF(AND(M1>N1,M1<N1,M1=N1),"GREATER","LESS","EQUAL") The abv formula obviously doesn't work -- too many arguments -- but I don't want to combine and EQUAL TO with a > or <. I want each response separate...

Hi, I'm trying to get this IF function to work, it's not giving out an error message but using the wrong figure to do the calculation. Checked all the reference cells and can't work out what is going on with it! =IF(H3=1, G3*T3, IF(H3=2, U4*U3, IF(H3=3, V4*V3, IF(H3=4, W4*W3, IF(H3=5, X4*X3...