Percentage calculations - please help

[qureshianis]

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Items[/TD]
[TD]Yes[/TD]
[TD]No[/TD]
[TD]NA[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Banana[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Orange[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mango[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Grapes[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
So here is what i want.
1. I have list of items with me. If that particular item is available with me that means it will come under "Yes" and its value i have given as "1" and "No" & "NA" will be "0"
i need final calculation to be as "100%": if the value for each item is "1" for either "Yes" or "NA"
if the value under "No" comes in "1" the overall calculation will be reduce from "100%"

Hope m able to explain my requirements.

 

[Skybluekid]

What would the value be, as a percentage, if the item was "No"?

 

[qureshianis]

What would the value be, as a percentage, if the item was "No"?

the overall calculation should reduce from 100% to lower.

 

[Skybluekid]

Do this help: https://www.dropbox.com/s/cw39z2mbkbuv33s/100%.xlsx?m=

 

[qureshianis]

Do this help: https://www.dropbox.com/s/cw39z2mbkbuv33s/100%.xlsx?m=

Thank you so much! that was indeed helpful! i have one more question.

i have uploaded the xcel sheet. if you see i have highlighted cell in blue and i need an average calculation in this cell.

https://www.dropbox.com/s/ofrzjdzqkg16pmx/100%.xlsx

 

[Skybluekid]

In Scenario 1, if you change the formula to =IF(OR(C3=1,E3=1),100%,95%), and then change the format to a percentage. Then the Average Function will work.