Forum Discussion
Solved
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 i...
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.
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
