| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
round figures
If I enter the numbers as follows
1 2 2.5 3.4 6 it should only add up 1,2 and 6 as it are full figures and not .5 and .4 figures Thanx |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
round figures
Hi,
What would you like to achieve, why you don't include 2.5 and 3.4 in your sum "ekkeindoha" wrote: If I enter the numbers as follows 1 2 2.5 3.4 6 it should only add up 1,2 and 6 as it are full figures and not .5 and .4 figures Thanx |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
round figures
With your numbers in A1:A10 try the below; please note that this is an array
formula. Within the cell in edit mode (F2) paste this formula and press Ctrl+Shift+Enter to apply this formula. If successful in 'Formula Bar' you can notice the curly braces at both ends like "{=<formula}" =SUM(IF(INT(A1:A10)=A1:A10,A1:A10)) If this post helps click Yes --------------- Jacob Skaria "ekkeindoha" wrote: If I enter the numbers as follows 1 2 2.5 3.4 6 it should only add up 1,2 and 6 as it are full figures and not .5 and .4 figures Thanx |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
round figures
One way:
=SUMPRODUCT(--(INT(A2:A6)=A2:A6),A2:A6) -- David Biddulph "ekkeindoha" wrote in message ... If I enter the numbers as follows 1 2 2.5 3.4 6 it should only add up 1,2 and 6 as it are full figures and not .5 and .4 figures Thanx |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
round figures
Or a variation on the same theme:
=SUMPRODUCT(--(MOD(A2:A6,1)=0),A2:A6) -- David Biddulph "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... One way: =SUMPRODUCT(--(INT(A2:A6)=A2:A6),A2:A6) -- David Biddulph "ekkeindoha" wrote in message ... If I enter the numbers as follows 1 2 2.5 3.4 6 it should only add up 1,2 and 6 as it are full figures and not .5 and .4 figures Thanx |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
round figures
excellent - thanks
"David Biddulph" wrote: One way: =SUMPRODUCT(--(INT(A2:A6)=A2:A6),A2:A6) -- David Biddulph "ekkeindoha" wrote in message ... If I enter the numbers as follows 1 2 2.5 3.4 6 it should only add up 1,2 and 6 as it are full figures and not .5 and .4 figures Thanx |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
round figures
Just to show you there are usually more than one way to solve a problem...
=SUMPRODUCT(A2:A6*(MOD(A2:A6,1)=0)) -- Rick (MVP - Excel) "ekkeindoha" wrote in message ... excellent - thanks "David Biddulph" wrote: One way: =SUMPRODUCT(--(INT(A2:A6)=A2:A6),A2:A6) -- David Biddulph "ekkeindoha" wrote in message ... If I enter the numbers as follows 1 2 2.5 3.4 6 it should only add up 1,2 and 6 as it are full figures and not .5 and .4 figures Thanx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to round figures? | Excel Discussion (Misc queries) | |||
| Changing positive figures to minus figures | Excel Worksheet Functions | |||
| I want to get brackets round my figures not minus signs | Excel Discussion (Misc queries) | |||
| how do i add figures exactly, do not round up. | Excel Discussion (Misc queries) | |||
| Why does Excell round-off figures when adding them? | Excel Discussion (Misc queries) | |||
Linear Mode
