| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| -ve no with -1; positive with sign+ and 0 no sign? Tks. | Excel Worksheet Functions | |||
| # sign in a cell | Excel Discussion (Misc queries) | |||
| How do you sign up for courses at Office Online? | Excel Discussion (Misc queries) | |||
| Missing = sign button in excel XP and 2003 | Excel Discussion (Misc queries) | |||
| Show = sign | Excel Discussion (Misc queries) | |||
Linear Mode
