Wednesday, June 1, 2022

Calculate Percentage correctly across columns

 When we need to show the percentage on a report/excel  and we have to divide by an odd number , we should divide by an even number and then computed values should be used for the last group.

Example: Col1 = 30/105    

                Col2=50/105

                Col3=25/105


So percentage for col1 and col2 is calculated then the difference is used for col3

No comments:

Post a Comment