Forum Discussion
converting values greater than or equal to X into percentage
Hi, I'm trying to find out what formula I would use to convert the values greater than or equal to a number into a percentage.
Example below. I've been currently entering the values myself but it takes too long and I want to make it into a formula.
Change the values in J1 to M1 to 15, 20, 35 and 30.
If you wish, you can apply the custom number format
≥ 0
to these cells, so that you'll see ≥ 15 etc.
Enter the following formula in J2:
=COUNTIF($C2:$H2,">="&J$1)/COUNT($C2:$H2)
and format J2 as a percentage. Then fill to the right to M1, and down to the last row with data.
2 Replies
Change the values in J1 to M1 to 15, 20, 35 and 30.
If you wish, you can apply the custom number format
≥ 0
to these cells, so that you'll see ≥ 15 etc.
Enter the following formula in J2:
=COUNTIF($C2:$H2,">="&J$1)/COUNT($C2:$H2)
and format J2 as a percentage. Then fill to the right to M1, and down to the last row with data.
- Thanks so much. Works perfect now. saved me so much time
