Need to change the value of 0 to 100%

[DHM]

I am currently using the following formula =countif(D83:D93,">7:51") 7:51 is a time value. I need to count the number of occurances under that time and then turn the resulting value into a percentage. My problem comes in when the value = 0. I have tried If(d93=0,"100%"), where D93 = the value of the the previous forumla, but the formula returns a 0%.

[Moo the Dog]

Try this:

=COUNTIF(D83:D93,">7:51")/COUNTA(D83:D93)

That will return the percentage of values in the range d83:d93 that are GREATER THAN 7:51

If you want to count the percentage of list values LESS THAN 7:51, use

=COUNTIF(D83:D93,"<7:51")/COUNTA(D83:D93)

- Moo

[DHM]

Still giving me "0".

[Moo the Dog]

Try uploading your spreadsheet with data, actual results and expected results. Maybe you have some custom formatting taking place. Because the formulas I posted seem to work fine (for me, anyway)

- Moo