| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiply Cell Values which include text units
I have a formula in cell G13 that shows "=B13*C13". Is there a way that i
can multiply cell B13 which has a number format and reads "61 Units" to cell C13 which has a currency format and contains "34.23 / Ea" to get a value of $2,088.03 shown in cell G13? I don't know if I can show text in the cell that is being referenced in a formula. Can you show text in a cell that is being referenced in a formula without receiving the "#value!" in the formula cell? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF function results to include both text and cell value | Excel Discussion (Misc queries) | |||
| How do I include part of a cell in text (string?) in another cell? | Excel Worksheet Functions | |||
| How do I include TEXT in the same cell with a FORMULA? | Excel Discussion (Misc queries) | |||
| Convert units should include USFt (39.37/12) | Excel Worksheet Functions | |||
| Multiply all values by 10 | Excel Discussion (Misc queries) | |||
Threaded Mode
