Firstly, the formula evaluates MIN(3+.0.02*H9, 0.05*H9)
So if H9 holds the value -1, it finds MIN(3-0.02, -0.05) which is -0.05
Then if finds the MEDIAN of -400, -0.05 and 0
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"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