What static figure did you have in mind?


--
Biff
Microsoft Excel MVP


"john" wrote in message
...
=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