You know you are using the right document editor when such a simple job as Shape formula document does not take more time than it should. Editing files is now a part of numerous working processes in various professional areas, which is why accessibility and simplicity are crucial for editing resources. If you find yourself researching manuals or trying to find tips on how to Shape formula document, you may want to get a more easy-to-use solution to save time on theoretical learning. And here is where DocHub shines. No training is needed. Just open the editor, which will guide you through its main functions and features.
A workflow gets smoother with DocHub. Take advantage of this instrument to complete the paperwork you need in short time and take your productivity one stage further!
Hey, welcome back to MrExcel netcast. Im Bill Jelen. Excel Charts Chapter 11; Shape Formula. Hey! All right, welcome back to the MrExcel netcast. Im Bill Jelen. Well, I have a really simple Spreadsheet today. We have a goal of 1.5 million, were currently at 1,234,567. And Im gonna build a little motivating formula here, so, equal We are at space, close the quotes and then an ampersand, Im gonna use the text function here to do a little calculation. Text B2 divided by B1 and then Im gonna format that as a percentage, so 0.0%. All right, and then Im gonna close, finish off this sentence. So, another concatenation character and then in quotes, space, so were at, some percent of our goal. Close the quotes. I want to capitalize this, so Ill go back and edit that. Here we go, so were at 82.3% of our goal, hows that? Does that motivate you? Yeah, me neither. All right, so lets see if we can really dress this up, a little bit. Well go to Insert, where we have the Shapes here