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
|