| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Decimals
do you only have two decimals all the time, if so:
if a1 8.46 a2 9.55 use =right(a1,2)+right(a2,2) if you have more than two decimal use =RIGHT(a1,LEN(a1)-SEARCH(".",a1,1))+RIGHT(a2,LEN(a2)-SEARCH(".",a2,1)) "Michael Brown" wrote: How do I add just decimals together? I want to take a number like 8.46 and 9.55 and add only the 46 and 55 together. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding Error when adding or subtracting two cells | Excel Worksheet Functions | |||
| Comma format button decimals | Excel Discussion (Misc queries) | |||
| How do I calculate without decimals in excel? | Excel Worksheet Functions | |||
| help neede with adding times | Excel Discussion (Misc queries) | |||
| Decimals separation by . or , | Excel Discussion (Misc queries) | |||
Hybrid Mode
