+ Reply to Thread
Results 1 to 9 of 9

Trying to insert celldata/celldata but don't know how.

  1. #1
    Registered User
    Join Date
    04-03-2007
    Posts
    4

    Trying to insert celldata/celldata but don't know how.

    hello, I have a quick question and looking for a quick answer

    I have cell C5=300 and cell C6=400, how do I get it to write it out for me in cell C7=C6/C5 which is 400/300?

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474
    didn't you just answer your question??
    =C6/C5

  3. #3
    Registered User
    Join Date
    04-03-2007
    Posts
    4
    no.. try inserting that into excel, it will give you 1.3 not 400/300
    I'm required to show work and not give a direct answer. therefore I don't want it to solve the equation, I want it to write it out... get it?

  4. #4
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885
    Try:

    =C6&"/"&C5

  5. #5
    Registered User
    Join Date
    04-03-2007
    Posts
    4
    ok thanks, but a new problem occurred.. It's giving me a number like 0.03109738243420943/0.01284791823 How do I reduce the decimal places?

  6. #6
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885
    Are 0.03109738243420943 and 0.01284791823 the two values in C6 and C5? If not, are the values in C6 and C5 rounded, but the real values underneath them are what you show above?

    Perhaps try:

    =TEXT(C6,"0.00")&"/"&TEXT(C5,"0.00")

    This will convert any number to two decimal places only.

  7. #7
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474
    A new can of worms..

    =C6&"/"&C5
    maybe
    =round(c6,2)&"/"&round(C5,2)

  8. #8
    Registered User
    Join Date
    04-03-2007
    Posts
    4
    sweet, you guys rule.. I've always wondered how this could be done without doing it myself, never taught us this in school. Great time saver.

  9. #9
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885
    Yeah, those darn teachers always trying to get you to figure out how to do things on your own. Horrible!

    Glad you got it sorted out.

+ 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