+ Reply to Thread
Results 1 to 11 of 11

Converting 100 cents to 1 dollar

  1. #1
    Registered User
    Join Date
    01-21-2004
    Posts
    21

    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

  2. #2
    Forum Contributor
    Join Date
    06-10-2004
    Location
    India
    Posts
    1,066
    Total Dollars
    =112+INT(223/100)

    Total Cents
    =MOD(223,100)

    You could replace the numbers with your formulae

    Mangesh

  3. #3
    Registered User
    Join Date
    01-21-2004
    Posts
    21
    Thank you sooooooooooooooo mcuh for you help

  4. #4
    Registered User
    Join Date
    01-21-2004
    Posts
    21
    Thank you sooooooooooooooo mcuh for your help

  5. #5
    Mangesh Yadav
    Guest

    Re: Converting 100 cents to 1 dollar

    Thanks for the feedback.

    Mangesh



    "Jim333" <Jim333.1pxwyk_1117616763.9118@excelforum-nospam.com> wrote in
    message news:Jim333.1pxwyk_1117616763.9118@excelforum-nospam.com...
    >
    > 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
    >




  6. #6
    Mangesh Yadav
    Guest

    Re: Converting 100 cents to 1 dollar

    Thanks for the feedback.

    Mangesh



    "Jim333" <Jim333.1pxwyk_1117616763.9118@excelforum-nospam.com> wrote in
    message news:Jim333.1pxwyk_1117616763.9118@excelforum-nospam.com...
    >
    > 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
    >




  7. #7
    Mangesh Yadav
    Guest

    Re: Converting 100 cents to 1 dollar

    Thanks for the feedback.

    Mangesh



    "Jim333" <Jim333.1pxwyk_1117616763.9118@excelforum-nospam.com> wrote in
    message news:Jim333.1pxwyk_1117616763.9118@excelforum-nospam.com...
    >
    > 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
    >




  8. #8
    Mangesh Yadav
    Guest

    Re: Converting 100 cents to 1 dollar

    Thanks for the feedback.

    Mangesh



    "Jim333" <Jim333.1pxwyk_1117616763.9118@excelforum-nospam.com> wrote in
    message news:Jim333.1pxwyk_1117616763.9118@excelforum-nospam.com...
    >
    > 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
    >




  9. #9
    Mangesh Yadav
    Guest

    Re: Converting 100 cents to 1 dollar

    Thanks for the feedback.

    Mangesh



    "Jim333" <Jim333.1pxwyk_1117616763.9118@excelforum-nospam.com> wrote in
    message news:Jim333.1pxwyk_1117616763.9118@excelforum-nospam.com...
    >
    > 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
    >




  10. #10
    Mangesh Yadav
    Guest

    Re: Converting 100 cents to 1 dollar

    Thanks for the feedback.

    Mangesh



    "Jim333" <Jim333.1pxwyk_1117616763.9118@excelforum-nospam.com> wrote in
    message news:Jim333.1pxwyk_1117616763.9118@excelforum-nospam.com...
    >
    > 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
    >




  11. #11
    Mangesh Yadav
    Guest

    Re: Converting 100 cents to 1 dollar

    Thanks for the feedback.

    Mangesh



    "Jim333" <Jim333.1pxwyk_1117616763.9118@excelforum-nospam.com> wrote in
    message news:Jim333.1pxwyk_1117616763.9118@excelforum-nospam.com...
    >
    > 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1