-->

80% Of The Values Are Greater Than X.


-->

80% Of The Values Are Greater Than X.. To test if a cell is greater than a given value, you can use the if function. The result in cell e5 is x since the score in cell c5 is greater than 80.

Commercial Real Estate Tops FY24 PE Deals In India With 57 Value Share
Commercial Real Estate Tops FY24 PE Deals In India With 57 Value Share from realtynxt.com

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. I've been currently entering the values myself but it takes too long and i want to make it into a formula. The result returned by the if function can be adjusted as needed.

-->

Commercial Real Estate Tops FY24 PE Deals In India With 57 Value Share

Try removing the % sign form your formula and formatting the range to contain percentages. The ifs function returns a value corresponding to the first true condition. Try removing the % sign form your formula and formatting the range to contain percentages. The result in cell e5 is x since the score in cell c5 is greater than 80.

-->