ExcelBanter - formula excel 2007

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - formula excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/211842-formula-excel-2007-a.html)

John

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

T. Valko

formula excel 2007

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

Sheeloo[_3_]

formula excel 2007

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

"john" wrote:

=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

John

formula excel 2007

cheers,works well

"Sheeloo" wrote:

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

"john" wrote:

=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

All times are GMT +1. The time now is 12:49 AM.