Thread: How do I enter a not to exceed number 1 in a formula?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
  
Posts: 5,302
Default 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?


Reply With QuoteReply With Quote