Success rate calculate

[arindamsenaxa]

I Just want to calculate my success rate ,if there is any formula to get this please do let me know


I have a actual value and Expected value.so by comparing my expected value is it possible to calculate the success rate.
for more details look in to the attached excel.
In D I have update the success rate but I need that should be reflect through a formulaSuccess Rate.xls

[PFDave]

in D2 and drag down

=IFERROR(B2/C2,0)

[Phuocam]

Try this ...

=IF(COUNT(B2:C2)=2,B2/C2,"")

Format -> %

[arindamsenaxa]

Hi both Thanks for the response
Both the formula is working fine.
Need one suggestion on one of the scenario
If suppose my actual number is greater than my expected numbers then your formula is throwing a result of more than 100%.
Example :- Actual is 3 and Expected is 2 =150%
So in this scenario if I wanted to benchmark my success rate as 100% then how should I showcase the remaining 1 of actual.It should react negative because I am having 1 buffer in actual.
Need your suggestion

[Phuocam]

=if(count(b2:c2)=2,min(1,b2/c2),"")