Nested If-Then statement with number range.

  • Thread starter Thread starter ladeewzl
  • Start date Start date
L

ladeewzl

This is what I want to do.

If cell K184 is less than 165, multiply cell K182 by .5
If cell K184 is 166-300, multiply cell K182 by .55
If cell K184 is greater than 300, multiply cell K182 by .6

This is the formula that has returned the most results so far...
=IF(K184<165, K182*0.5, IF(OR(K184>165,K184<300), K182*0.55, IF(K184>300,
K182*0.6)))

It works for the first and second IF statements. However, if cell K184 is
more than 300 it still multiplies it by .55. What am I missing?
 
Try this:

=IF(K184<=165,K182*.5,IF(K184<=300,K182*.55,K182*.6))

You don't need to specify so many conditions, since the FALSE portion of an
IF Statement only evaluates if the condition is false. So, by the time it
gets to K182*.6, we've already established that K184 is greater than 300.

HTH
Elkar
 
TYVM!!!

Elkar said:
Try this:

=IF(K184<=165,K182*.5,IF(K184<=300,K182*.55,K182*.6))

You don't need to specify so many conditions, since the FALSE portion of an
IF Statement only evaluates if the condition is false. So, by the time it
gets to K182*.6, we've already established that K184 is greater than 300.

HTH
Elkar
Click to expand...
 
Hi,

Try this

=vlookup(K184,A2:C4,3)*K182. In A2:A4, you have 0,166 and 300. In B2:B4,
you have 165,300 and blank. In C2:C4, you have 0.5, 0.55 and 0.6

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
Back
Top