Q:

excel formula IF minimum 100 percent value

I have a formula that is working for some cells and not others, using this i get most but i dont want it to exceed 100% any help appreciated.
H4 is the sign in usage, I4 is the non sign in usage
Formula
    =IF(I4=0,--(H4>0),H4/I4-1)

Data
                   H4  I4   % percentage of usage
    Ashtabula OH    3   8   -63%
    Atlanta GA     18   7   157%
    Augusta GA     11   2   450%
    Avon IN        28   12  133%  
    Baldwin FL     0    22  -100%  <--accurate, shows no usage at all
    Birmingham AL  21   1   2000%  <--not accurate
    Bronx NY       0    19  -100%
    Brunswick MD   0    47  -100%
    Buffalo NY     0    16  -100%
    Charlotte NC  29    1   2800%
    ChattanoogaTN  5    0   100%   <--most accurate positive value if everyone used the machine this would be 100% percent for all locations

Photo:

A:

Wrap your formula in MIN()
=MIN(IF(I4=0,--(H4>0),H4/I4-1),1)

