Comparin data in cells

H

hn.srikanth

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell data entering slow! 0
Excel - Wich Function should I use? 1
Remove Identical words 0
Merging from an Excel file with graphics 1
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Compare last digit in 5 cells for match 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
How to delete ALL cells containing the same data --- REVISED 0

Top