| Home |
| Search |
| Today's Posts |
|
|
|
#1
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) | |||
Hybrid Mode
