Previous Topic Next Topic

Formula which calculates the percentage of these cells

Closed
Lucy - Mar 17, 2015 at 10:59 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Mar 23, 2015 at 12:54 PM
I was wondering if anyone could help me with a formula for some work I am currently doing. I have a set of data (numbers ranging from -0.8 to + 0.7) which are in cells H10:H46. I want to have a formula which calculates the percentage of these cells which contain numbers which are either greater than and including +0.4 and lesser than and including -0.4. the percentage needs to include both of these.

many thanks

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 555
Mar 23, 2015 at 12:54 PM
Hi Lucy,

Try this formula:
=(COUNTIF(H10:H46,"<=-0,4")+COUNTIF(H10:H46,">=0,4"))/16

Don't forget to format your formula cell as Percentage to get the desired result.

Best regards,
Trowa

Similar discussions

Excel Formula
bicky@7 -
bicky@7 -

6 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
Auto generate serial number in excel based on Column
Raj_1562 -
TrowaD -

4 responses