split dollars and cents

[Guest]

hi, how do i split dollars and cent in 2 colums and at the end sum it,
for example: A1 Dollar, B1 cents, A2 dollar, B2 cents and in A3 and B3
the sum result of A1,A2 and B1 B2.
thanks for help

 

[Guest]

The easiest is to pick the column column (A), do Data->Text to Columns click
next in the next screen select other and put a . in the box and hit finish.
Column b must be empty before you do this. The just autosum at the bottom.

 

[Ron Rosenfeld]

hi, how do i split dollars and cent in 2 colums and at the end sum it,
for example: A1 Dollar, B1 cents, A2 dollar, B2 cents and in A3 and B3
the sum result of A1,A2 and B1 B2.
thanks for help

=SUM(B1:B2)/100+SUM(A1:A2)


--ron

 

[Bob Phillips]

Don't both, add directly

=SUMPRODUCT(INT(A1:A2))

=SUMPRODUCT(MOD(A1:A2,1))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[David Biddulph]

But if you want Ron's result split between A3 & B3 as requested, then
A3 =INT(SUM(B1:B2)/100+SUM(A1:A2))
B3 =MOD(SUM(B1:B2)+100*SUM(A1:A2),100)

The most obvious problem with that is if you have fractions of cents & these
try to round up values greater than 99.5 to display as 100 cents. In that
case you may need to do rounding in the formulae.

 

[Guest]

In A3 put =SUMPRODUCT(INT(A1:A2))

In B3 put =SUM(A1:A2)-A3

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

thank u ron but david got the nail on the head, still appreciate your comment

 

[Guest]

hey u r really good , this is what work and do the job, i apreciate your
kindness in helping out

 

[Ron Rosenfeld]

thank u ron but david got the nail on the head, still appreciate your comment

You're welcome. I misread part of your question.
--ron