![]() ![]() Suppose we wanted to capture the Margin % we have acquired through business with each country. You can copy the formulas and paste them to different cells so that you get the formulated results for the other column.Įxample #2 – Margin Percentage for Each Country Well, this is one of the nicest Excel features of all time. ![]() Step 4: Copy cell B9 and paste (Ctrl + V) it under cell C9 to get the average value for Margin. Step 3: Close the parentheses to complete the formula and press Enter key to see the output as shown below: Step 2: Use B2:B7 (all sales values) as a reference under the AVERAGE function. Step 1: In cell B9, start typing the formula =AVERAGE() However, in Excel, you have a built-in AVERAGE function that does this task for you. TEXT and String Functions in Excel (26+).Lookup and Reference Functions in Excel (36+). ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |