View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mansoor Mansoor is offline
external usenet poster
 
Posts: 1
Default how to use if statement for range steps?

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?