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

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.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"yodochi" wrote:

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

On Mon, 13 Aug 2007 05:32:02 -0700, yodochi
wrote:

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

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

"Ron Rosenfeld" wrote in message
...
On Mon, 13 Aug 2007 05:32:02 -0700, yodochi

wrote:

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

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



"David Biddulph" wrote:

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

"Ron Rosenfeld" wrote in message
...
On Mon, 13 Aug 2007 05:32:02 -0700, yodochi

wrote:

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

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


"Ron Rosenfeld" wrote:

On Mon, 13 Aug 2007 05:32:02 -0700, yodochi
wrote:

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

On Wed, 15 Aug 2007 14:04:07 -0700, yodochi
wrote:


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

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)

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

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

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

Vaya con Dios,
Chuck, CABGx3



"yodochi" wrote:

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