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