1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Excel - Two formulas in one cell

Discussion in 'Business Applications' started by CheesePlant, Sep 4, 2008.

Thread Status:
Not open for further replies.
Advertisement
  1. CheesePlant

    CheesePlant Thread Starter

    Joined:
    Sep 4, 2008
    Messages:
    11
    Hello,

    I can't for the life of me remember how to put two formulas in one cell.

    At the moment I have:

    Cell 1 which contains a total:
    =SUM(D68:T68)
    Result is 5,245

    Cell 2 shows the total as a percentage:
    =$U68/U$83
    Result is 9.16%

    How do I put this into one cell to produce:
    Total = 5,245 - 9.16%

    Thank you in advance.
     
  2. computerman29642

    computerman29642

    Joined:
    Dec 4, 2007
    Messages:
    2,895
    CheesePlant, welcome to the forum.

    You could have a formula that looks like this....

    Code:
    
    =SUM(D68:T68) & " - " & $U68/U$83
    
    
     
  3. CheesePlant

    CheesePlant Thread Starter

    Joined:
    Sep 4, 2008
    Messages:
    11
    That was great but now I get 5245 - 0.0940257356

    Is there a way I can put in a comma (5,245) and shorten the percentage into 2 decimal places (0.09)?

    Thanks.
     
  4. computerman29642

    computerman29642

    Joined:
    Dec 4, 2007
    Messages:
    2,895
    Would it be possible for you to attach a sample spreadsheet?
     
  5. CheesePlant

    CheesePlant Thread Starter

    Joined:
    Sep 4, 2008
    Messages:
    11
    Unfortunately the spreadsheet is quite complex and holds information I can't easily remove to freely hand it out.

    I am using this code:

    =" Total: £" & SUM(D66:T66) & " - " & $U66/U$81 & "%"



    SUM(D66:T66) is resulting in 5,245 and $U66/U$81 results in 0.09
     
  6. computerman29642

    computerman29642

    Joined:
    Dec 4, 2007
    Messages:
    2,895
    Try this formula...

    Code:
    =FIXED(SUM(D68:T68),0) & " - " & ROUND($U68/U$83,2)
    
     
  7. CheesePlant

    CheesePlant Thread Starter

    Joined:
    Sep 4, 2008
    Messages:
    11
    Ah that's interesting. I've just created an example (please find it attached). Maybe you could have a look and advise?
     

    Attached Files:

  8. computerman29642

    computerman29642

    Joined:
    Dec 4, 2007
    Messages:
    2,895
    I took a look at the spreadsheet you attached. Please take a look at the revised spreadsheet I have attached.
     

    Attached Files:

  9. CheesePlant

    CheesePlant Thread Starter

    Joined:
    Sep 4, 2008
    Messages:
    11
    Thank you very much. That is perfect. I wish I completely understood it but I'll spend some time working it out.

    Cheers!
     
  10. computerman29642

    computerman29642

    Joined:
    Dec 4, 2007
    Messages:
    2,895
    You are welcome. :)

    Is there anything I can try to clear up for you?
     
  11. CheesePlant

    CheesePlant Thread Starter

    Joined:
    Sep 4, 2008
    Messages:
    11
    Just one more problem, I've had to change it to match my spreadsheet which had more than 2 months details so I added a SUM:


    =" Total: £" & FIXED(SUM(D66:T66),0) & " - " & ROUND($U$81/SUM(D66:T66),2) & "% of total"

    The last SUM(D66:T66) is causing me problems, im getting a higher %?
     
  12. computerman29642

    computerman29642

    Joined:
    Dec 4, 2007
    Messages:
    2,895
    It would be better if I could see the problem. Could you attach another example?

    When I use
    it works fine for me.
     
  13. CheesePlant

    CheesePlant Thread Starter

    Joined:
    Sep 4, 2008
    Messages:
    11
    Sure, attached is a new version. Thanks.
     

    Attached Files:

  14. computerman29642

    computerman29642

    Joined:
    Dec 4, 2007
    Messages:
    2,895
    Take a look at the revised spreadsheet.
     

    Attached Files:

  15. CheesePlant

    CheesePlant Thread Starter

    Joined:
    Sep 4, 2008
    Messages:
    11
    Great thank you very much for your help :)
     
  16. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/746780