| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Performing arithmetic functions to cells with number and text
I have data entered in one cell in this format: 80/60
and I would like to find the difference of that cell with one of similar format...75/57 by subtracting 75-80 and 57-60. How can I do this with the / embedded within the cell. Perhaps just entering the data with a "," instead would help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Performing calculations on only cells with data | Excel Worksheet Functions | |||
| Performing a function on visible cells only in a range | Excel Discussion (Misc queries) | |||
| All arithmetic functions return Zero as result | Setting up and Configuration of Excel | |||
| Performing Multiple Functions in a Column | Excel Worksheet Functions | |||
| apply arithmetic functions on special multiple cells | Excel Worksheet Functions | |||
Threaded Mode
