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


"ladeewzl" wrote:

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(K184165,K184<300), K182*0.55, IF(K184300,
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?