Converting 100 cents to 1 dollar

J

Jim333

Hi everybody,

I have a question and I hope that I find a satisfactor answer for it,

I have two columns >> the firs one contains numbers represent dollar
and the other one contains numbers represent cents >>

Let's assume the the total of cents is 223 and the total of dollars i
112,, The formuls I want is to convert the total of cents to 23 and th
total of dollars to 114 ..

I wish that my question is clear for all.


I hope I find the reply ASAP.

Thanx for Al
 
M

mangesh_yadav

Total Dollars
=112+INT(223/100)

Total Cents
=MOD(223,100)

You could replace the numbers with your formulae

Manges
 
Top