formula excel 2007

[john]

=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

 

[T. Valko]

What static figure did you have in mind?

 

[Sheeloo]

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

 

[john]

cheers,works well

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