Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i sum dollars & cents in different columns
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i sum dollars & cents in different columns
See response in programming group.
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Eric" wrote in message ... 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??? me at |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i sum dollars & cents in different columns
see answer in .programming.
Please do not multipost. --ron |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i sum dollars & cents in different columns
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) In article , "Eric" wrote: 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i sum dollars & cents in different columns
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 -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Eric" wrote in message ... 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??? me at |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i sum dollars & cents in different columns
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to swap rows and columns? | Excel Discussion (Misc queries) | |||
Linking Columns and cells | Excel Worksheet Functions | |||
Hiding columns and custom views problem | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) |