Search Search for: Business ApplicationsAll Forums

# Solved: Excel - Two formulas in one cell

 CheesePlant
Junior Member with 11 posts.

Join Date: Sep 2008
Experience: 1+2=3
04-Sep-2008, 05:05 AM #1
Solved: Excel - Two formulas in one cell
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%

Member with 2,888 posts.

Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Intermediate
04-Sep-2008, 08:05 AM #2
CheesePlant, welcome to the forum.

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

Code:
`=SUM(D68:T68) & " - " & \$U68/U\$83`
 CheesePlant
Junior Member with 11 posts.

Join Date: Sep 2008
Experience: 1+2=3
04-Sep-2008, 09:05 AM #3
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.
Member with 2,888 posts.

Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Intermediate
04-Sep-2008, 09:09 AM #4
Would it be possible for you to attach a sample spreadsheet?
 CheesePlant
Junior Member with 11 posts.

Join Date: Sep 2008
Experience: 1+2=3
04-Sep-2008, 09:27 AM #5
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
Member with 2,888 posts.

Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Intermediate
04-Sep-2008, 09:36 AM #6
Try this formula...

Code:
`=FIXED(SUM(D68:T68),0) & " - " & ROUND(\$U68/U\$83,2)`
 CheesePlant
Junior Member with 11 posts.

Join Date: Sep 2008
Experience: 1+2=3
04-Sep-2008, 09:47 AM #7
Ah that's interesting. I've just created an example (please find it attached). Maybe you could have a look and advise?
Attached Files
 example.xls (8.5 KB, 1667 views)
Member with 2,888 posts.

Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Intermediate
04-Sep-2008, 09:52 AM #8
I took a look at the spreadsheet you attached. Please take a look at the revised spreadsheet I have attached.
Attached Files
 example_revised.xls (17.5 KB, 3262 views)
 CheesePlant
Junior Member with 11 posts.

Join Date: Sep 2008
Experience: 1+2=3
04-Sep-2008, 09:54 AM #9
Thank you very much. That is perfect. I wish I completely understood it but I'll spend some time working it out.

Cheers!
Member with 2,888 posts.

Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Intermediate
04-Sep-2008, 09:57 AM #10
You are welcome.

Is there anything I can try to clear up for you?
 CheesePlant
Junior Member with 11 posts.

Join Date: Sep 2008
Experience: 1+2=3
04-Sep-2008, 10:01 AM #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 %?
Member with 2,888 posts.

Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Intermediate
04-Sep-2008, 10:05 AM #12
It would be better if I could see the problem. Could you attach another example?

When I use
Quote:
 =" Total: £" & FIXED(SUM(D66:T66),0) & " - " & ROUND(\$U\$81/SUM(D66:T66),2) & "% of total"
it works fine for me.
 CheesePlant
Junior Member with 11 posts.

Join Date: Sep 2008
Experience: 1+2=3
04-Sep-2008, 10:09 AM #13
Sure, attached is a new version. Thanks.
Attached Files
 example2.xls (18.5 KB, 552 views)
Member with 2,888 posts.

Join Date: Dec 2007
Location: HERE OR THERE?!?!?!
Experience: Intermediate
04-Sep-2008, 10:22 AM #14
Take a look at the revised spreadsheet.
Attached Files
 example_revised2.xls (21.5 KB, 1545 views)
 CheesePlant
Junior Member with 11 posts.

Join Date: Sep 2008
Experience: 1+2=3
04-Sep-2008, 10:27 AM #15
Great thank you very much for your help
 techguy.org/746780
As Seen On

WELCOME TO TECH SUPPORT GUY!

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

Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

### Find the solution to your computer problem!

 Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)