# between numbers

1. ### Match if between 2 values (i.e. multiple criteria)

I have this input table tracking time spent on various activities over a year (first table below). I want to show it in an output table with rows as days and time slots as columns (see 2nd table below) to get an overview of how time was spent. I can use IndexMatchMatch in I2 for the Aug 3 type...
2. ### collating data, minimum interval

Hi everyone, I'm hoping I am not repeating a previous question (I did try to check). I am trying to collate data from multiple sheets based on the minimum interval with a key identifying field. I think this is best demonstrated with the example below: <tbody> sheet 1 ID attribute 1 attribute...
3. ### Using if statement, for a number between two values.

I crated random numbers between 0 and 100, and I want to convert those numbers to have a specific value from 1-6 depending on the random number value. Those specific values are the following: 0-30 should output a 1 30-40 should output a 2 40-60 should output a 3 60-70 should output a 4 70-75...
4. ### Help completing formula

I am pretty new to formulas and I'm hoping someone can help me... I am trying to create a formula that assigns a rate of 1% for revenues between \$350,000- \$750,000 2% for \$750,000 - \$1,449,000 and 3% for \$1,500,000 - \$2,500,000. I did =IF(AND(G14>350000, G14<750000)1.00), (AND(G14>750001...
5. ### Find in a range

Hi everybody im new here and I already have a question for you guys So I gotta find mif a cell is between a range of numbers Something like IF a1>=100 but <400 then 50, if a1<400 but <600 then 100, if a1 <600 but >800 then 150 Hope you guys understand I just need that Excel give me a number...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back