View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John John is offline
external usenet poster
 
Posts: 2,069
Default formula excel 2007

=F4*CHOOSE(MATCH(F4,{-1E+300,5,10,20,30,40}),12,13,7,6,5,4)

hi all can somebody include a static figure if f4 is less than 5 in the
formula above
thanks
mike