| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculation based on mixed entries of another cell?
I have one column with dimensions like this:
21.9" x 17.6" x 8.9" I'd like to calculate the multiplication of the first 2 numbers. Right now, I have to manually enter =21.9*17.6 in another cell. I wonder if it's possible to write something that automatically picks up 2.19 and 17.6 and multiplies the 2. The text in the column has the same format. Thanks in advance for the help, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to go to cell based upon a calculation | Excel Discussion (Misc queries) | |||
| How can cell entries be based on word entries in another cell ? | Excel Worksheet Functions | |||
| Can I display a cell based on a calculation (eg M(14/2)? | Excel Worksheet Functions | |||
| Selecting rows based on cell entries | Excel Worksheet Functions | |||
| Selecting rows based on cell entries | Excel Discussion (Misc queries) | |||
Threaded Mode
