Limiting a returned calc to 195

[Mr Sandman]

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

 

[Pete_UK]

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

 

[Peo Sjoblom]

=MIN(195,your_formula)

will not go higher than 195


--


Regards,


Peo Sjoblom

 

[Mr Sandman]

Cheers!


Steve

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

 

[Pete_UK]

You're welcome, Steve.

Pete

Cheers!

Steve







- Show quoted text -