mgroms
New member
- Joined
- Oct 9, 2021
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Office365
[FONT="]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.[/FONT]
[FONT="]For example -[/FONT]
[FONT="]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[/FONT]
[FONT="]Can you share a formula by using select or another manner. Thank for your assistance.[/FONT]
[FONT="]For example -[/FONT]
[FONT="]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[/FONT]
[FONT="]Can you share a formula by using select or another manner. Thank for your assistance.[/FONT]