Remember Me?

#1
June 1st 05, 07:17 AM
 Jim333 Posts: n/a
Converting 100 cents to 1 dollar

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 dollars
and the other one contains numbers represent cents

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

I wish that my question is clear for all.

I hope I find the reply ASAP.

Thanx for All

--
Jim333
------------------------------------------------------------------------
Jim333's Profile: http://www.excelforum.com/member.php...fo&userid=5186

#2
June 1st 05, 07:33 AM

Total Dollars
=112+INT(223/100)

Total Cents
=MOD(223,100)

You could replace the numbers with your formulae

Mangesh

--
------------------------------------------------------------------------

#3
June 1st 05, 09:54 AM
 Jim333 Posts: n/a

Thank you sooooooooooooooo mcuh for you help

--
Jim333
------------------------------------------------------------------------
Jim333's Profile: http://www.excelforum.com/member.php...fo&userid=5186

#4
June 1st 05, 09:55 AM
 Jim333 Posts: n/a

Thank you sooooooooooooooo mcuh for your help

--
Jim333
------------------------------------------------------------------------
Jim333's Profile: http://www.excelforum.com/member.php...fo&userid=5186

#5
June 1st 05, 12:23 PM

Thanks for the feedback.

Mangesh

"Jim333" wrote in
message ...

Thank you sooooooooooooooo mcuh for your help

--
Jim333
------------------------------------------------------------------------
Jim333's Profile:

http://www.excelforum.com/member.php...fo&userid=5186

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post WTG Excel Discussion (Misc queries) 3 March 30th 05 01:57 PM Andrew Bartholomew Excel Discussion (Misc queries) 1 March 25th 05 02:50 AM Jack Excel Worksheet Functions 3 January 30th 05 01:51 AM RJB1 Charts and Charting in Excel 2 January 7th 05 02:51 PM ron New Users to Excel 6 December 24th 04 07:32 PM

All times are GMT +1. The time now is 11:17 AM.