| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i sum of decimal digit in absolute terms
I am not 100% sure what you are after
If you are looking for just the whole portion of the number ? You could use a formula like =INT(YourNumber) As example 10.24524569 when above formula is applied returns 10 HTH "dhir" wrote: 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 |
|
#3
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.... If I understand you correctly, use this formula against EG-1 (assumed to be in the range A1:A3 for this example)... =SUMPRODUCT(INT(A1:A3)) You could also use this array version... =SUM(INT(A1:A3)) but you must commit the array version (only) with Ctrl+Shift+<Enter. Rick |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i sum of decimal digit in absolute terms
Try Tools/ Options/ Calculation:
Precision as displayed. -- David Biddulph "dhir" wrote in message oups.com... 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 |
| Reply |
| 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) | |||
Linear Mode
