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

SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Counting cells with specific month in 7
COUNT function 2
Checking cells for 2 conditions 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
How to count merged cells 1
Using countif on non-consecutive cells 5
Combining text from several cells into 1 cell 4

Top