I need help integrating a string into a formula
Microsoft Excel 2011
Example
I want the B5 cell to read "13 to 15"
Where 13 is the result of B1+B2 and 15 is the result of B3+B4
I just want that "to" in the beginning
Obviously
=(B1+B2) "to" (B3+B4) doesn't work?
What is the correct format?
Thank you
Last edited by Jhertilus; 10-24-2012 at 08:40 PM. Reason: forgot something
you have to put &
=(B1+B2)& " to " &(B3+B4)
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Nice! Thanks. One more question. Although I was able to add the string I can no longer limit my "(B1+B2)" to 0 decimal points. Is there something I can put in the formula? Because format cell seems to longer have an effect.
you can use the round,roundup,rounddown depends on your goal
something like
=round((B1+B2),0)& " to " &rounddown((B3+B4),2)
note: i used round and rounddown for the example above
Thank you so much!
Your welcome.
One issue, when I put this in my macro editor the quotation marks for to yields an end of argument error. Any workaround for that?
how did you put it can you show the code on that.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks