| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i sum of decimal digit in absolute terms
I want to add
EG-1 10.4356900 12.4356847 25.2579655 the sum is 48 when i decrease the decimal into absolute by decreasing the decimal then it is like this EG-2 10 12 25 the sum is 47 now what i wanted that from EG.-1 I want sum 47 with showing visibility of EG-2 means showing value without decimal all i want sum of absolute value....by reducing decimal no background decimal sum.... thanks i think i made clear my point dhir thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I stop decimal being placed in a 3 digit whole number | Setting up and Configuration of Excel | |||
| Display a digit before or after the decimal point in another cell | Excel Worksheet Functions | |||
| extract decimal place digit | Excel Worksheet Functions | |||
| In excel, how can i delete 1 digit and the decimal point? | Excel Worksheet Functions | |||
| When we enter a 16 digit number (credit card) the last digit chan. | Excel Discussion (Misc queries) | |||
Threaded Mode
