Thread: Nested If-Then statement with number range.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ladeewzl ladeewzl is offline
external usenet poster
  
Posts: 2
Default Nested If-Then statement with number range.
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?
Reply With QuoteReply With Quote