adding decimals into whole number

Hi,

I am using excel 2003
how can you add a 2 decimal number into the main number?

eg. 10.15 into 10+15?
csharp_learnerAsked:
Who is Participating?
 
Rory ArchibaldCommented:
=INT(A1)+SUBSTITUTE(TEXT(MOD(A1,1),"general"),".","")
should work I think, but is getting silly. ;)
0
 
cyberkiwiCommented:
So if A1 is 10.15, you want to get 10+15=25 as the answer?

=ROUND(A1,0)+INT((A1-ROUND(A1,0))*100)
0
 
cyberkiwiCommented:
Or

=ROUND(A1,0)+INT(MOD(A1*100,100))
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
AlanConsultantCommented:
Hi,

If you have 10.15 in A1 then use this:

=INT(A1)+((A1-(INT(A1)))*100)

Alan.
0
 
barry houdiniCommented:
If you have 10.15 in A2 try this formula in B2

=INT(A2)+MOD(A2,1)*100

regards, barry
0
 
AlanConsultantCommented:
That's the best one Barry - good thinking!

Alan.
0
 
cyberkiwiCommented:
For postering, because I messed up using ROUND instead of INT (even though it gets used in the 2nd part...)

if A1 is 10.15, and you want to get 10+15=25 as the answer..

=INT(A1)+INT(MOD(A1,1)*100)

10.159999 will also end up as 25
0
 
cyberkiwiCommented:
Sorry, I was testing Barry's formula and got mixed up, I meant to correct my 2nd one

=INT(A1)+INT(MOD(A1*100,100))
0
 
csharp_learnerAuthor Commented:
CAn there be a formula to do it when it is 1 decimal place?

Sorry that if i forgot to mention there are instances where it may be like

10.1 or 0.1
0
 
cyberkiwiCommented:
So if it is 10.1 -> 11? or 20?
And can it be 10.1456 -> 10 + 1456 = 1466?
0
 
cyberkiwiCommented:
If your number is in A1

=IF(A1=INT(A1),A1,INT(A1)+MID(A1,FIND(".",A1&".")+1,100))
0
 
AlanConsultantCommented:
But perhaps 10.1456 = 10+14.56 = 24.56 ?

There may be a secret algorithm ;->

Alan.
0
 
Rory ArchibaldCommented:
Variation on a theme:
=INT(A1)+SUBSTITUTE(MOD(A1,1),"0.","")
0
 
Rory ArchibaldCommented:
PS the above assumes your numbers are always positive.
0
 
cyberkiwiCommented:
Rory, I get

10.1      => 1E+15
10.62 => 6.2E+14
0
 
Rory ArchibaldCommented:
Ah, yes. Stupid bloody floating points. :)
0
 
Rory ArchibaldCommented:
Or:
=INT(A1)+SUBSTITUTE(A1&".0",INT(A1)&".","")
0
 
cyberkiwiCommented:
That last one is very Barry-like.  Real good
0
 
Rory ArchibaldCommented:
csharp_learner,
As you got multiple working solutions - and before my post too - I think a points split would be fairer here.
Regards,
Rory
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.