Can You Put a at&t Sim Card in a Sprint Phone
- Joined
- Sep 4, 2008
- Messages
- eleven
- #1
How-do-you-do,
I tin can't for the life of me recollect how to put two formulas in ane cell.
At the moment I have:
Cell 1 which contains a full:
=SUM(D68:T68)
Consequence is 5,245
Cell 2 shows the full as a percentage:
=$U68/U$83
Result is ix.16%
How do I put this into ane cell to produce:
Total = 5,245 - nine.xvi%
Thank you in advance.
- #2
CheesePlant, welcome to the forum.
Y'all could have a formula that looks like this....
Code:
=SUM(D68:T68) & " - " & $U68/U$83 - Joined
- Sep iv, 2008
- Messages
- 11
- #three
That was corking but now I get 5245 - 0.0940257356
Is there a manner I can put in a comma (v,245) and shorten the percentage into ii decimal places (0.09)?
Cheers.
- #4
Would it be possible for you to attach a sample spreadsheet?
- Joined
- Sep 4, 2008
- Messages
- 11
- #5
Unfortunately the spreadsheet is quite complex and holds data I tin't hands 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
- #six
Try this formula...
Code:
=FIXED(SUM(D68:T68),0) & " - " & ROUND($U68/U$83,2) - Joined
- Sep 4, 2008
- Messages
- 11
- #vii
Ah that's interesting. I've just created an case (please detect it attached). Maybe you lot could have a look and propose?
- #8
I took a await at the spreadsheet you attached. Delight take a expect at the revised spreadsheet I have fastened.
- Joined
- Sep 4, 2008
- Letters
- eleven
- #9
Thank y'all very much. That is perfect. I wish I completely understood information technology but I'll spend some time working it out.
Cheers!
- #10
You lot are welcome. 
Is in that location anything I can effort to articulate upwards for you?
- Joined
- Sep 4, 2008
- Messages
- xi
- #xi
Merely i 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 final SUM(D66:T66) is causing me bug, im getting a higher %?
- #12
It would be better if I could see the problem. Could you attach some other example?
When I use
it works fine for me.
- Joined
- Sep 4, 2008
- Messages
- xi
- #13
Sure, fastened is a new version. Thanks.
- #14
Have a look at the revised spreadsheet.
- Joined
- Sep four, 2008
- Messages
- eleven
- #15
Great cheers very much for your help
Source: https://forums.techguy.org/threads/solved-excel-two-formulas-in-one-cell.746780/
0 Response to "Can You Put a at&t Sim Card in a Sprint Phone"
Post a Comment