Limiting a returned calc to 195

  • Thread starter Thread starter Mr Sandman
  • Start date Start date
M

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
 
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
 
=MIN(195,your_formula)

will not go higher than 195


--


Regards,


Peo Sjoblom
 
Cheers!


Steve

Pete_UK said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I format cells in Excel to make 175/5 read 175? 2
QUARTILE Function on Sorted Data 2
Put parts of cell into separate columns 3
If And Or functions 2
How can I get excel to look up prices in a table 1
Countif function for years 3
Vlookup formula 4
In a formula, how do I set a maximum acceptable value? 1

Back
Top