Calculate percentages depending on the values

[amicable.person]

Hello Guru's

Question I am posting must have been already asked, but this little specific and i am beginner

%Pass = =F13/G13
%Fail = =D13/G13
%Total = =H13+I13

Total = Summation of all value

I want to write a macro which will autopopualte upon entering Blocked, Failed, No Run, Passed Values.


I have attached the excel sheet.
Thansk for looking my post.

Appreciate your help