This is my formula with concatenation: =K3/K1*100 & "c" & " Each"
This is the result of the values in K3 divided by K1: 6.41666666666667c Each
I would like to limit the decimal places to two: 6.41c Each.
I have tried to format the cell and none of the formatting options have any effect.
If possible I would like to use the rounding function but I do not know how to combine the formula + text + rounding.
Thank you.
Hi and welcome to the forum
Maybe this?
=text(K3/K1*100,"0.00") & "c Each"
Not sure if that will take care of the rounding, test it. If not, then....
=text(round(K3/K1*100,2),"0.00") & "c Each"
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Formula:
Please Login or Register to view this content.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
try this text(K3/K1*100,""0.00")&"C Each")
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
Perhaps?
=Round(K3/K1*100,2) & "c" & " Each"
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thanks for welcoming me to the forum!
Your first suggestion worked perfectly! I checked the solution with my hand calculator and your formula rounded the number up correctly.
Many thanks!
Worked perfectly. Thanks for the quick response...........!
Gave me exactly what I needed. Had one extra quotation mark and Excel gave me a message to change something in the equation. I am not complaining though. The help is very very appreciated.
Thank you..........!
Thank you all for your help. Every one of your solutions worked!
I learned a lot from this!
Thanks again!
Happy you got what you wanted, and thanks for the feedback and kind words
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks