Thread: Adding Decimals
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nikki
 
Posts: n/a
Default Adding Decimals

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.