View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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