CHOOSE command for arithmetic sign

N

Native

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?
 
P

Peo Sjoblom

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)
 
Top