Adding Decimals

[Michael Brown]

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.

[Nick Hodge]

Michael

If they're in A1 and A2

=MOD(A1,1)+MOD(A2,1)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]HIS


"Michael Brown" <[email protected]> wrote in message
news:[email protected]...
> 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.

[Harald Staff]

=MOD(8.46,1)+MOD(9.55,1)

HTH. Best wishes Harald

"Michael Brown" <[email protected]> skrev i melding
news:[email protected]...
> 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.

[Nikki]

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.