split dollars and cents
 

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

split dollars and cents
 

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

split dollars and cents
 

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

split dollars and cents
 

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

split dollars and cents
 

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

split dollars and cents
 

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

split dollars and cents
 

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

split dollars and cents
 

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

split dollars and cents
 

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