Thread
:
Adding Decimals
View Single Post
#
2
Posted to microsoft.public.excel.misc
Nick Hodge
Posts: n/a
Adding Decimals
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.
Reply With Quote