Hello Everyone!
I have confidence intervals that I concatenated into single cells so that they read "lowCI-upperCI" and I would like to round the lower and upper confidence intervals while keeping the hyphen. Is there a formula I can use to do this? If not is there some VBA code that could help?
For example:
I have: "16.6226-19.1051"
And I want: "16.6-19.1"
Thank you!
Hi there... and welcome to the Excel Forum. Try htis out:
=ROUND(LEFT(A1,FIND("-",A1)-1)+0,1)&"-"&ROUND(MID(A1,FIND("-",A1)+1,255)+0,1)
assuming your numerical string is in A1
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Here's a couple of ways:
=ROUND(A1,1)&"-"&ROUND(B1,1)
or:
=TEXT(A1,"0.0")&"-"&TEXT(B1,"0.0")
assuming your values are in A1 and B1.
Hope this helps.
Pete
Thank you Glen and Pete!
Glen, you code worked perfectly! And thanks for the welcome!
Pete, thank you for your post aswell. I should have specified clearer that the hyphened number was in a single cell!
Really appreciate the expedited responses!!
You're welcome... and thanks for the Rep...
Yes, my formulae are to replace your concatenation formula.
Thanks for the rep, though.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks