CHOOSE command for arithmetic sign
 

Hello: would like to use the CHOOSE() function to select either * or /.

However, if I enter the equation:

=G10&CHOOSE(G$5,"*","/")&G12

I end up getting an output in the cell of "234*7", versus actually
multipling 234*7.

Simply syntax error, or something else I need to do?

CHOOSE command for arithmetic sign
 

You would either need some evaluation function written (UDF) or change the
formula to

=CHOOSE(G$5,G10*G12,G10/G12)

--
Regards,

Peo Sjoblom

(No private emails please)


"Native" wrote in message
oups.com...
Hello: would like to use the CHOOSE() function to select either * or /.

However, if I enter the equation:

=G10&CHOOSE(G$5,"*","/")&G12

I end up getting an output in the cell of "234*7", versus actually
multipling 234*7.

Simply syntax error, or something else I need to do?