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
