Question: how to calculate total percentage of two percentages in excel?
Answer: =ROUND(A1/$A$5,2). Note that you round to two decimal places when you want to display resultant percentages with no decimal places. If you want to display to one decimal place, use this formula: =ROUND(A1/$A$5,3).