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

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

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

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

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 -