I need to replicate an Accounts Sheet that shows the In/Out cloumns with
dollars and cents in separate columns. How do I set up Excel to SUM
dollars and cents in two separate columns and use two separate columns
for other formulas? - Thanks.


--
ncbuilder01
------------------------------------------------------------------------
ncbuilder01's Profile: http://www.excelforum.com/member.php...o&userid=27732
View this thread: http://www.excelforum.com/showthread...hreadid=472431

If A1 hold a value such as $123.45
in B1 enter =INT(A1) and in C1 enter =MOD(A1,1)
now $ and ¢ are separate
Does this answer question?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"ncbuilder01"
wrote in message
...

I need to replicate an Accounts Sheet that shows the In/Out cloumns with
dollars and cents in separate columns. How do I set up Excel to SUM
dollars and cents in two separate columns and use two separate columns
for other formulas? - Thanks.


--
ncbuilder01
------------------------------------------------------------------------
ncbuilder01's Profile:
http://www.excelforum.com/member.php...o&userid=27732
View this thread: http://www.excelforum.com/showthread...hreadid=472431

Format cells A1, B1, C1 as currency

Enter 12.34 in A1
enter =ROUND(A1,0) in B1
enter =A1-B1 in C1

A1 is dollars and cents
B1 is the dollars part
C1 is the cents part

Have a good day
--
Gary''s Student


"ncbuilder01" wrote:


I need to replicate an Accounts Sheet that shows the In/Out cloumns with
dollars and cents in separate columns. How do I set up Excel to SUM
dollars and cents in two separate columns and use two separate columns
for other formulas? - Thanks.


--
ncbuilder01
------------------------------------------------------------------------
ncbuilder01's Profile: http://www.excelforum.com/member.php...o&userid=27732
View this thread: http://www.excelforum.com/showthread...hreadid=472431

Gary's Student,

Enter 12.34 in A1
enter =ROUND(A1,0) in B1
enter =A1-B1 in C1

Wont that produce errors if the cents are more than 50?

ie Enter 12.85 and the formulas will return 13 in B1 and -0.15 in C1


--
Regards

Sandy

Replace@mailinator with @tiscali.co.uk


"Gary''s Student" wrote in message
...
Format cells A1, B1, C1 as currency

Enter 12.34 in A1
enter =ROUND(A1,0) in B1
enter =A1-B1 in C1

A1 is dollars and cents
B1 is the dollars part
C1 is the cents part

Have a good day
--
Gary''s Student


"ncbuilder01" wrote:


I need to replicate an Accounts Sheet that shows the In/Out cloumns with
dollars and cents in separate columns. How do I set up Excel to SUM
dollars and cents in two separate columns and use two separate columns
for other formulas? - Thanks.


--
ncbuilder01
------------------------------------------------------------------------
ncbuilder01's Profile:
http://www.excelforum.com/member.php...o&userid=27732
View this thread:
http://www.excelforum.com/showthread...hreadid=472431

Further to Bernard's reply, if when you have separated the dollars and
cents, you used the formula:

=SUM(B1:C100) or whatever your range will be, it will sum them as you want.

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"ncbuilder01"
wrote in message
...

I need to replicate an Accounts Sheet that shows the In/Out cloumns with
dollars and cents in separate columns. How do I set up Excel to SUM
dollars and cents in two separate columns and use two separate columns
for other formulas? - Thanks.


--
ncbuilder01
------------------------------------------------------------------------
ncbuilder01's Profile:
http://www.excelforum.com/member.php...o&userid=27732
View this thread: http://www.excelforum.com/showthread...hreadid=472431

Gary's Student

You probably meant TRUNC(A1,0) instead of ROUND(A1,0) or just INT(A1)


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=472431

Thanks for the tips. I may not have been clear in what I needed. I
scanned the sheet as a pdf but it's a little bigger than I can post
here.

I have two major columns Receipts & Checking Account. Under each of
those major headings are two other columns In & Out. Each of the In &
Out columns are actually two columns, one for the dollars and one for
the cents. For example one line could be (showing I for a column
break)

I Receipts I Checking Account I
I IN I OUT I IN I OUT I
I 100 I 05 I 100 I 05 I 100 I 05 I I I

And then the Total at the bottom is the same way with dollars in one
column and censt in another column. I need to be able to take the
totals at the bottom and use them in other formulas as well - Help.


--
ncbuilder01
------------------------------------------------------------------------
ncbuilder01's Profile: http://www.excelforum.com/member.php...o&userid=27732
View this thread: http://www.excelforum.com/showthread...hreadid=472431

Anybody?....


--
ncbuilder01
------------------------------------------------------------------------
ncbuilder01's Profile: http://www.excelforum.com/member.php...o&userid=27732
View this thread: http://www.excelforum.com/showthread...hreadid=472431