| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Performing arithmetic functions to cells with number and text
These 2 may be of use:-
Divides the bits after the / =MID(A1,(FIND("/",A1,1)+1),99)/MID(B1,(FIND("/",B1,1)+1),99) Divides the bits before the / =LEFT(A1,((FIND("/",A1,1))-1))/LEFT(B1,((FIND("/",B1,1))-1)) Mike "Arithmetic functions with embedded text" wrote: 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
