![]() |
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! |
=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