Restrict % to 100

Robin Chapple · Jul 30, 2004

I have a spreadsheet where a calculated field can be greater the 100%
for reasons that I cannot change.

How do I write code to restrict the dispaly to be maximum 100%

Thanks,

Robin Chapple

Frank Kabel · Jul 30, 2004

Hi
try
=MIN(your_formula,1)

Robin Chapple · Jul 31, 2004

Thanks Frank,

It worked first time

Cheers,

Robin Chapple, Melbourne, Australia

Restrict % to 100

Robin Chapple

Frank Kabel

Robin Chapple