Splitting dollars and cents

[ncbuilder01]

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.

 

[Bernard Liengme]

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" <[email protected]>
wrote in message
news:[email protected]...

 

[Gary''s Student]

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

 

[Sandy Mann]

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
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk

 

[Sandy Mann]

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
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk


"ncbuilder01" <[email protected]>
wrote in message
news:[email protected]...

 

[Cutter]

Gary's Student

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

 

[ncbuilder01]

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

I have two major columns Receipts & Checking Account. Under each o
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 fo
the cents. For example one line could be (showing I for a colum
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 on
column and censt in another column. I need to be able to take th
totals at the bottom and use them in other formulas as well - Help

 

[ncbuilder01]

Anybody?.... :confused