Comparin data in cells
 

Hi,
I have data in 4 cells ie cell a1, a2, a3 & a4.
I would be keying in either 3 or 1 as input data in each cell.
If all cells are keyed in as 3 then in cell a5 i want the answer to be
100%, if one of the cell contains 1 and rest of the cells contain 3
then i want the answer to be 75%, if 2 cells contain 1 and 2 cells
contain 3 I want the answer to be 50%, if 3 cells contain 3 and 1 cell
contain 1 then the answer would be 25% and if all cells contain 1 then
the answer should be 0%.
Can any one help me in putting a formula to get the above result.
Thanks in advance!!!

- Srikanth HN

Comparin data in cells
 

Format Cell A5 as a percentage and then enter =COUNTIF(A1:A4,"3")/4

" wrote:

Hi,
I have data in 4 cells ie cell a1, a2, a3 & a4.
I would be keying in either 3 or 1 as input data in each cell.
If all cells are keyed in as 3 then in cell a5 i want the answer to be
100%, if one of the cell contains 1 and rest of the cells contain 3
then i want the answer to be 75%, if 2 cells contain 1 and 2 cells
contain 3 I want the answer to be 50%, if 3 cells contain 3 and 1 cell
contain 1 then the answer would be 25% and if all cells contain 1 then
the answer should be 0%.
Can any one help me in putting a formula to get the above result.
Thanks in advance!!!

- Srikanth HN