The first thing to do is select the cell whose value you want to adjust. Now, you want to calculate the profit margin so that your profit percentage is 30%. You use the following formula in cell B13 to calculate the profit percentage: =(B12-B11)/B12 But to how much? Goal seek will help you find it. If you would like your increase your profit to ‘30%’, but you are unable to increase your investment, so you must increase your revenue to gain profit. And cell B13 shows the percentage of your profit (20%). In the below screenshot, cell B11 (below) displays how much it cost you to buy fruits for your stall and cell B12 shows your total revenue on selling those fruits. To demonstrate how it works in a simple example, imagine you run a fruit stall.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |