| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to auto-sum and not exceed a certain number | Excel Discussion (Misc queries) | |||
| Formula, automation turn red if value exceed a number | Excel Worksheet Functions | |||
| Can you exceed 15 number characters in an excel cell? | Excel Discussion (Misc queries) | |||
| The number of hours in a day cannot exceed 24... | Excel Worksheet Functions | |||
| identification of cell that exceed certain number of characters | Excel Programming | |||
Hybrid Mode
