how do i sum dollars & cents in different columns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eric - 20 Nov 2005 22:16 GMT

In my account sheet I need to have dollars in the first column and cents in
the second. For my total row I would like to be able to have everything sum
(dollars and cents) and then be displayed as it is above (dollars in the
first column and cents in the second) How in the world is this done??? email
me at Eric@thesolarco.com

Reply to this Message

Bob Phillips - 20 Nov 2005 22:40 GMT

See response in programming group.

Signature

HTH

Bob Phillips

(remove nothere from email address if mailing direct)

> In my account sheet I need to have dollars in the first column and cents in
> the second. For my total row I would like to be able to have everything sum
> (dollars and cents) and then be displayed as it is above (dollars in the
> first column and cents in the second) How in the world is this done??? email
> me at Eric@thesolarco.com

Reply to this Message

Randall.Senn@excite.com - 21 Nov 2005 02:42 GMT

Assuming $1.23 is in cell A1, in cell B1 use =INT(A1) to return the
whole dollar value.

Then in cell C1 use =MOD(A1,1) to retunr the pennies, 0.23. You can
multiply by 100 if you'd like.

Then add columns B and C individually. Naturally column C may yield a
value of more than 100 pennies.

Reply to this Message

Ron Rosenfeld - 20 Nov 2005 22:42 GMT

see answer in .programming.

Please do not multipost.
--ron

Reply to this Message

JE McGimpsey - 20 Nov 2005 22:48 GMT

One way:

Assuming that, say $1.23 was entered as

A B
1 1 23

then

Dollars:

=SUM(A1:A100) + INT(SUM(B1:B100)/100)

Cents:

=MOD(SUM(B1:B100),100)

Reply to this Message

Bernard Liengme - 20 Nov 2005 23:17 GMT

Now you know how to do it, can one ask why two columns? Why not, for
example, 12.25 in one cell for $12.25?
best wishes

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> In my account sheet I need to have dollars in the first column and cents
> in
[quoted text clipped - 4 lines]
> email
> me at Eric@thesolarco.com

Reply to this Message