Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 1st 05, 07:17 AM
Jim333
 
Posts: n/a
Default 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
View this thread: http://www.excelforum.com/showthread...hreadid=375528


  #2   Report Post  
Old June 1st 05, 07:33 AM
mangesh_yadav
 
Posts: n/a
Default


Total Dollars
=112+INT(223/100)

Total Cents
=MOD(223,100)

You could replace the numbers with your formulae

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=375528

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


Thank you sooooooooooooooo mcuh for you help


--
Jim333
------------------------------------------------------------------------
Jim333's Profile: http://www.excelforum.com/member.php...fo&userid=5186
View this thread: http://www.excelforum.com/showthread...hreadid=375528

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


Thank you sooooooooooooooo mcuh for your help


--
Jim333
------------------------------------------------------------------------
Jim333's Profile: http://www.excelforum.com/member.php...fo&userid=5186
View this thread: http://www.excelforum.com/showthread...hreadid=375528

  #5   Report Post  
Old June 1st 05, 12:23 PM
Mangesh Yadav
 
Posts: n/a
Default

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
View this thread: http://www.excelforum.com/showthread...hreadid=375528





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Addition problem, number always 2 cents off...Help WTG Excel Discussion (Misc queries) 3 March 30th 05 01:57 PM
Converting Text to Number Andrew Bartholomew Excel Discussion (Misc queries) 1 March 25th 05 02:50 AM
roundoff when converting text to numbers Jack Excel Worksheet Functions 3 January 30th 05 01:51 AM
Dollar Bill Chart RJB1 Charts and Charting in Excel 2 January 7th 05 02:51 PM
Amount or Numbers in Words ron New Users to Excel 6 December 24th 04 07:32 PM


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

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017