ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Adding currency broken in two columns? (https://www.excelbanter.com/excel-worksheet-functions/38763-adding-currency-broken-two-columns.html)

lperisich

Adding currency broken in two columns?
 
Is there a way to add currency that is broken into a column for dollars and a
column for cents? How do I format so that if the censt are 00 it won't
default to 0? - Thanks a million!

Blue Hornet

=sum (A:A) + sum( B:B) / 100
should work for the summation

What do you want to show for cents = 0? You can set up a custom format
to show nearly anything you want (or nothing). If you say what you
want it's easier for us to answer.



All times are GMT +1. The time now is 02:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com