| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Limiting a returned calc to 195
I have a complex formula, i need to limit the result of the calculation to
195 maximum..its probably dead simple..but how do i do it? cheers Steve |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Limiting a returned calc to 195
Use this:
=MIN(195,your_complex_formula) so, if your formula returns a value that is greater than 195, then the MIN will pick 195. Hope this helps. Pete On Nov 6, 4:36 pm, "Mr Sandman" wrote: I have a complex formula, i need to limit the result of the calculation to 195 maximum..its probably dead simple..but how do i do it? cheers Steve |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Limiting a returned calc to 195
Cheers!
Steve "Pete_UK" wrote in message ups.com... Use this: =MIN(195,your_complex_formula) so, if your formula returns a value that is greater than 195, then the MIN will pick 195. Hope this helps. Pete On Nov 6, 4:36 pm, "Mr Sandman" wrote: I have a complex formula, i need to limit the result of the calculation to 195 maximum..its probably dead simple..but how do i do it? cheers Steve |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Limiting a returned calc to 195
You're welcome, Steve.
Pete On Nov 6, 5:24 pm, "Mr Sandman" wrote: Cheers! Steve "Pete_UK" wrote in message ups.com... Use this: =MIN(195,your_complex_formula) so, if your formula returns a value that is greater than 195, then the MIN will pick 195. Hope this helps. Pete On Nov 6, 4:36 pm, "Mr Sandman" wrote: I have a complex formula, i need to limit the result of the calculation to 195 maximum..its probably dead simple..but how do i do it? cheers Steve- Hide quoted text - - Show quoted text - |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Limiting a returned calc to 195
=MIN(195,your_formula)
will not go higher than 195 -- Regards, Peo Sjoblom "Mr Sandman" wrote in message ... I have a complex formula, i need to limit the result of the calculation to 195 maximum..its probably dead simple..but how do i do it? cheers Steve |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calc = Manual & Do Not Calc b/4 SAVE | Excel Discussion (Misc queries) | |||
| Help with Characters limiting | Excel Worksheet Functions | |||
| My calc key on Excel changes box to "Text" Box and doesn't calc ? | Charts and Charting in Excel | |||
| auto calc on, but have to edit (f2) cells to force re-calc..help! | Excel Worksheet Functions | |||
| limiting cell value | Excel Discussion (Misc queries) | |||
Hybrid Mode
