greater/less than

Hello, I am hoping someone can help me with figuring out a formula to check if the last value in a row is greater than the first value in the same row then yes else no. There are only 4 cells in the row and they may have blanks. If the first cell is 2 and the next is 3 but the next is 2, then...

Hi, I'm using a VBA code that copy reports. but the code have 2 conditions Condition 1 -> If greater or less than Condition 2 -> Sort report by descending Date (*) Condition 2 means that for example: if perhaps i've copy yesterday report (is going to have yesterday date) So when i run the code...

Hello, I have seen this answered before, however I have not been able to get the function to work correctly for me. I really appreciate any help that can be given and apologize if this is too similar to something else. I am looking for a formula that will look between ranges to return a value...

Hi all, Hoping you can help. I have a 2 variable data table that has 10 rows of data and 8 columns. I have a value that I want to look up in the array and return the lowest value that is greater than or equal to the number that I want to look up. I found a way to do this within a column, but...

Hello. I have an excel sheet where I have a column(A) with hours, displayed in decimals e.g. 2,2 hours. I need a formula which can check whether the amount is less than or equal 3,00 and if so just transfer the cell value from column(A) to column(B). If the amount is greater than 3,00, it just...

I have a workbook (named Pay Ranges) with pay grades 1 -25 and 3 pay rates for each grade based on years in title. In another workbook (named Scenarios) I am running scenarios based on data in the Pay Ranges workbook. The scenario workbook contains the employee name, current pay grade and...

I have 2 columns of asending numbers (Column A and B). Numbers in Column A and B provide a set range within each row. Each row of numbers are numbered accordingly (1,2,3,4....) in Column C. I have a cell on a separate page that contains a typed value (Number x). The formula must: Find the...