nested if and ranges

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good Morning All,

I need a nested IF statement that will give a different answer depending on the value of the cell D5.

This I understand how to do:
IF the value of D5 is < 10, the answer is .3

But the part that confuses me is the FALSE.
IF the value of D5 is between 10 and <24.99, the answer is .55
IF the value of D5 is between 25 and 49.99, the answer is 1.1
IF the value of D5 is between 50 and 199.99, the answer is 2.2
IF the value of D5 is >199.99, the answer is 3.3

I don't know what the operator is for "between" and I don't know how to connect the IFs.

Here's another IF statement:
IF you can help, THEN my sister will leave me alone and let me use the pc, OTHERWISE I'll have to wait until she leaves for work -in 4 hours!

~Teri
 
Hi Binky,

try this formula

=VLOOKUP(D5,{0,0.3;10,0.55;25,1.1;50,2.2;200,3.3},2)

or maybe this amendment id D5 is empty

=IF(D5="","",=VLOOKUP(D5,{0,0.3;10,0.55;25,1.1;50,2.2;200,3.3},2))



--

Regards,

Peo Sjoblom


BinkyABT said:
Good Morning All,

I need a nested IF statement that will give a different answer depending on the value of the cell D5.

This I understand how to do:
IF the value of D5 is < 10, the answer is .3

But the part that confuses me is the FALSE.
IF the value of D5 is between 10 and <24.99, the answer is .55
IF the value of D5 is between 25 and 49.99, the answer is 1.1
IF the value of D5 is between 50 and 199.99, the answer is 2.2
IF the value of D5 is >199.99, the answer is 3.3

I don't know what the operator is for "between" and I don't know how to connect the IFs.

Here's another IF statement:
IF you can help, THEN my sister will leave me alone and let me use the pc,
Click to expand...
OTHERWISE I'll have to wait until she leaves for work -in 4 hours!
 
Here's another option for your nested if statement. I
have set up this formula to give you a zero if the value
is below 10 and that's why you see the zero after the
last comma.

=IF(D5>199.99,3.3,IF(D5>50,2.2,IF(D5>25,1.1,IF
(D5>10,0.55,0))))


-----Original Message-----
Good Morning All,

I need a nested IF statement that will give a different
Click to expand...
answer depending on the value of the cell D5.
This I understand how to do:
IF the value of D5 is < 10, the answer is .3

But the part that confuses me is the FALSE.
IF the value of D5 is between 10 and <24.99, the answer is .55
IF the value of D5 is between 25 and 49.99, the answer is 1.1
IF the value of D5 is between 50 and 199.99, the answer is 2.2
IF the value of D5 is >199.99, the answer is 3.3

I don't know what the operator is for "between" and I
Click to expand...
don't know how to connect the IFs.
Here's another IF statement:
IF you can help, THEN my sister will leave me alone and
Click to expand...
let me use the pc, OTHERWISE I'll have to wait until she
leaves for work -in 4 hours!
 
Back
Top