greater than less than

Hello! I am calculating hours a customer is using my facility. Billing schedule is as follows- 4 hours the rate is $1000, less than 4 hours is $300/h, 8 hours the rate is $2000. Over 8 hours it is $2000 plus $300 for every hour over. I have the formulas for all of them. I now need a formula...

Hi, I have 2 Sheets(workbooks in reality but I made the test sample in 2 sheets). DATA sheet: All text/numbers. No formulas in this sheet. RESULT sheet: CFGMNOP1IDItemBalanceMatch Failed (Accessorials)Invoice Rejected (Accessorials)Approval Failed (Accessorials)Amount Due233283896Stop-off...

Hello all, I look into previously answered questions but they were not the same as mine so I was not able to use those formulas for my help. I need help creating a simple formula which does the following If sales are above 149.99 then the commission should be calculated at 10% of the total...

I have tried a number of formulas but don't get it right. I'm after: iF A1 is greater than 0 but less than 29, 1 IF A1 is greater than 30 but less than 100, 2 IF A1 is greater than 100 but less than 200, 3 etc Assistance certainly appreciated Thanks

Hi Guys, Working on a piece of code and not getting the desired results. My code is looking in column C for a specific cell with text and giving me a row number, I am using the row number to dynamically set how many pages to make the worksheet print too (i.e small amount of data print to 1...

I have a worksheet set up as a schedule for 8 people, for the entire month. Z6 & Y6 have the start time & end time of this persons shift on a specific date (if they are not working it's left blank). If there are work times in the cells, I want it to subtract the end time from the start time...

I am looking to create a formula to identify values (counts and sums), using a Greater than, Less than scenario. Example: =SUMIF(COMPANY!Z:Z,">0.0%","<50.0%",COMPANY!M:M) is what I am trying to accomplish, but I know that formula is wrong. How can I make this work properly?

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

Excel 2013 Issue: the first textbox value is compared to if it is greater than the total value of textbox 2. The issue is, only the first number (left to right) of each box is evaluated...likely reading it as a text. Suggestions? The closest posting I have found is here...

I have two columns of data (A dates and B currency amounts). The task I am trying to accomplish is simple: I want to sum up the transactions amounts (formatted as currency) in column B if they fall within a certain date range (dates are found in column A). I have two date fields: E4 and F4...

Hi i need to create a formula to return the following: score 0 to .9 result A1.1 1 to 1.9 result A1.2 2 to 2.5 result A2.1 2.6 to 2.9 result A2.2 3 to 3.5 result B1.1 Thanks

In column A, I have the numbers 1, 2, 3, 4 going down In column D, I have the numbers .8, 1.1, 1.2, 1.3 going down In column E, I have the numbers 5, 10, 15, 20 going down In cell G1, I want to have a vlookup, looking for the value in column A and finding the appropriate match in column D...