MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Help with Formulas


Posted by Dennis UK on February 03, 2002 2:43 PM

I am trying to write a formula where the result must be a minimum of 250 and a max of 600
eg 100,000 (A1) mutiply by 1.5% would normally read 1,500 in cell A2. As this exceeds 600 how do I get it to read 600?

If I then substitute 10,000 in A1 it must then read 250 instead of 150.

Can this be done . I would appreciate some help.
Thanks
Dennis


Posted by Aladin Akyurek on February 03, 2002 3:01 PM

Should be:


=MIN(MAX(A1*1.5%,250),600)

===========

Posted by Dennis UK on February 04, 2002 3:21 PM

:Thanks Aladin it works fine