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.

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
HIS


"Michael Brown" wrote in message
...
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.

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

HTH. Best wishes Harald

"Michael Brown" skrev i melding
...
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.

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.