As this presumably relates to a previous thread, you ought to ask the
question as a follow-up to the relevant message on the previous thread.
MEDIAN and MIN are both standard Excel functions, so you'll find descritions
and examples if you type the function name into Excel help.
MEDIAN is an easy way of limiting a formula's output to a value between 2
limits.
=MEDIAN(min_val,formula,max_val) will give an output of formula if formula
lies between min_val and max_val, but will give min_val if formula evaluated
to below min_val, and will give an output of max_val if formula gives a
value greater than max_val.
MIN gives you an output of the lowest of the range of input values, so if
0.05*H9 is less than 3+0.02*H9 it will return 0.05*H9, otherwise it will
return 3+0.02*H9.

If you struggle with maths, then you're likely to struggle with any
spreadsheet, but if you can give examples of values of H9, what formula you
are using, what value you are getting out of your formula, what you
expected, and why.
--
David Biddulph

"M Thompson" wrote in message
...
Hi Dana, and thanks again for the following:

=MEDIAN(-400,-MIN(3 + 0.02* H9, 0.05* H9),0)

Can you elaborate on it? Math is a shortcoming for me, so I'm definitely
not getting the min calc. And why median?

Thanks and have...
--
OneFineDay