between numbers

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

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

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

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

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