How do I enter a not to exceed number 1 in a formula?

[Dalas]

I am creating a Building Code analysis and a formula result can not exceed
1.0. How do I create this?

x/y = number (but not to exceed 1.0)

There must be a modifier but I need assistance. Anyone?

[Norman Jones]

Hi Dalas,

= Min(x/y,1)



---
Regards,
Norman



"Dalas" <[email protected]> wrote in message
news:[email protected]...
>I am creating a Building Code analysis and a formula result can not exceed
> 1.0. How do I create this?
>
> x/y = number (but not to exceed 1.0)
>
> There must be a modifier but I need assistance. Anyone?

[Dalas]

Norman,

Thanks. This worked, and a big help.

Dalas

"Norman Jones" wrote:

> Hi Dalas,
>
> = Min(x/y,1)
>
>
>
> ---
> Regards,
> Norman
>
>
>
> "Dalas" <[email protected]> wrote in message
> news:[email protected]...
> >I am creating a Building Code analysis and a formula result can not exceed
> > 1.0. How do I create this?
> >
> > x/y = number (but not to exceed 1.0)
> >
> > There must be a modifier but I need assistance. Anyone?
>
>
>