Posted to microsoft.public.excel.programming

Ron Rosenfeld Ron Rosenfeld is offline

external usenet poster

Posts: 5,651

how do i sum dollars & cents in different columns

On Sun, 20 Nov 2005 16:04:30 -0700, JE McGimpsey wrote:

Or, a bit simpler:

=MOD(SUM(B:B),100)

In article ,
Ron Rosenfeld wrote:

CentsSum: =MOD(SUM(B:B)/100,1)*100

Duh! Senior moment.

--ron

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
split dollars and cents	yodochi	Excel Worksheet Functions	8	August 16th 07 12:11 AM
Extracting dollars and cents	Teethless mama	Excel Worksheet Functions	0	March 28th 07 01:05 AM
Extracting dollars and cents	Pradhan	Excel Worksheet Functions	0	March 28th 07 01:00 AM
how do i sum dollars & cents in different columns	Eric	Excel Worksheet Functions	5	November 21st 05 02:42 AM
Separating dollars and cents	alison via OfficeKB.com	Excel Worksheet Functions	5	March 30th 05 11:08 PM

All times are GMT +1. The time now is 10:07 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us