Limit a cell with average formula to 100%

Hi all.

I have a formula that works out the average, but displays as a blank cell if no data is available.

=IF(E6=0,"",F6/E6)

The problem I have is sometimes, the value will go over 100%. I want to limit the cell to 100%. I have searched on this subject and found a few formulas such as MIN etc, but I cant get them to work.

Can anyone help me please?

Thanks,

Tony

Brilliant, thanks a lot