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.
|