Converting 100 cents to 1 dollar

[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

 

[mangesh_yadav]

Total Dollars
=112+INT(223/100)

Total Cents
=MOD(223,100)

You could replace the numbers with your formulae

Manges

 

[Jim333]

Thank you sooooooooooooooo mcuh for you hel

 

[Jim333]

Thank you sooooooooooooooo mcuh for your help

 

[Mangesh Yadav]

Thanks for the feedback.

Mangesh