Add Currencies with separate columns for dollars and cents

[Gheethanjali]

Hii Everyone....
I need to add currencies in a particular cell, however the dollars and cents are separated into two columns. So I need to add them in relevant column and if it reaches 100 cents it should automatically add 1 dollar to the next column while adding large number of prices....Eg:

140	50
130	60
271	10

 

[etaf]

how about

Book13
	A	B
1
2	1	60
3	1	50
4	1	80
5	1	90
6		75
7
8
9	7	55
Sheet1

Cell Formulas
Range	Formula
A9	A9	=INT(SUM(A2:A8)+SUM(B2:B8)/100)
B9	B9	=MOD(SUM(B2:B8),100)

 

[Gheethanjali]

how about

Book13
	A	B
1
2	1	60
3	1	50
4	1	80
5	1	90
6		75
7
8
9	7	55
Sheet1

Cell Formulas
Range	Formula
A9	A9	=INT(SUM(A2:A8)+SUM(B2:B8)/100)
B9	B9	=MOD(SUM(B2:B8),100)

Thank you so much.....Also when we separate dollars and cents I used =MOD(C36,1) formula which displayed the cents in decimal places....are there any ways to display them as you have done as full numbers......

 

[etaf]

how about
=MOD(C36,1)*100

 

[Gheethanjali]

how about
=MOD(C36,1)*100

Thank you so much

 

[etaf]

you are welcome