Hello sir,

It seems that you know what you're doing so I'll ask you. I'm trying to
create a formula to determine how much break time to deduct from employees
hours by using the amount of hours the employees have. For example, cell A2
has 10 hours for john smith. B2 is where I would like the formula. My ranges
are as follows: if A2 is greater than or equal 8, it'll result in 1.0, if A2
is less than or equal to 7.9 but greater than or equal to 4, it'll result in
..5, if A2 is less than or equal to 3.9, it will result in 0.

Thank you very much for your time

"Pete_UK" wrote:

What is the range of the second criteria? 50-100 or 50-200? How many
criteria ranges will you have, and what are they? (Excel doesn't
understand "... and so on ...").

Pete

On Apr 24, 2:24 pm,
wrote:
I'm trying to set a value that depends on another value being between two
values. For example: IF A1 is between 0-50, then A2 is B2*C2. If A1 is
greater then 50, but less then 100 but less then 200, then A2 is B2*C3. If A1
is greater then 200 but less then 300, then A2is B2*C4. And so on.