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

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How do I enter a not to exceed number 1 in a formula? (https://www.excelbanter.com/excel-programming/337824-how-do-i-enter-not-exceed-number-1-formula.html)

Dalas

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

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

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

Hi Dalas,

= Min(x/y,1)

---
Regards,
Norman

"Dalas" wrote in message
...
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

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

Norman,

Thanks. This worked, and a big help.

Dalas

"Norman Jones" wrote:

Hi Dalas,

= Min(x/y,1)

---
Regards,
Norman

"Dalas" wrote in message
...
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?

All times are GMT +1. The time now is 07:29 PM.