qureshianis
New Member
- Joined
- Feb 15, 2010
- Messages
- 4
[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.
<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.