Thread: how to use if statement for range steps?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mike Mike is offline
external usenet poster
  
Posts: 3,101
Default how to use if statement for range steps?
Case Is < 66
y = 2000

Case Is <= 100
y = 3200

Case Is <= 120
y = 4000

Case Else
y = 5000

End Select

"Mansoor" wrote:

If i want : X<66 then Y=2000 and if 66<X<100 then Y=3200 and 100<X<120 then
Y=4000 so on....... for X---- range (66,400), how to program it?
Reply With QuoteReply With Quote