I am planning to derive an answer in percentage in excel by using excel formula. Basically, I am trying to select a specific number from a cell, then add that specific number and then divide to get percentage.
For example -
In the excel sheet from total 5 cells - if Cell A1 has 100, Cell A2 has 100, Cell A5 has 100 - then select those 3 numbers from A1, A2, A5 and add them (100 + 100 + 100 = 300) then divide 5 and take that answer as percentage & in this case - 300 / 5 = 60
Can you share a formula by using select or another manner. Thank for your assistance.