Restrict % to 100

[Robin Chapple]

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]

Hi
try
=MIN(your_formula,1)

 

[Robin Chapple]

Thanks Frank,

It worked first time

Cheers,

Robin Chapple, Melbourne, Australia