Restrict % to 100

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Robin Chapple - 30 Jul 2004 20:39 GMT

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

Reply to this Message

Frank Kabel - 30 Jul 2004 21:05 GMT

Hi
try
=MIN(your_formula,1)

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

> I have a spreadsheet where a calculated field can be greater the 100%
> for reasons that I cannot change.
[quoted text clipped - 4 lines]
>
> Robin Chapple

Reply to this Message

Robin Chapple - 31 Jul 2004 05:01 GMT

Thanks Frank,

It worked first time

Cheers,

Robin Chapple, Melbourne, Australia

>Hi
>try
>=MIN(your_formula,1)

Reply to this Message