shouldn't MAX for Rating 1 in 2009 equal 4%?
shouldn't MAX for Rating 1 in 2010 equal 4%, too?

On 17 Gru, 05:01, Christi wrote:
I have a worksheet with the following layout:
* * * * * *A * * * * * * * *B * * * * * * * * * *C * * * * * * * * * * *D
* * * * *Rating * * * * Year * * * * * * * *Rate * * * * * * * * Override Rate
Row1 * * 1 * * * * * * * * 2009 * * * * * * * 4% * * * * * * * * * 2.5%
Row2 * * 1 * * * * * * * * 2010 * * * * * * * 3% * * * * * * * * *
Row3 * * 3 * * * * * * * * 2009 * * * * * * * 6% * * * * * * * * *
Row4 * * 1 * * * * * * * * 2010 * * * * * * * 4% *

I'm trying to set up formuals to populate the following:
Titles---------- * * * *Forumlas----
Rating * * Year * * * * Min * * * Max
1 * * * * * * 2009 * * * *2.5% * *6.0%
1 * * * * * * 2010 * * * *3.0% * *3.0%

I can't figure out how to select only one column's value for calculating the
Min/Max. *D should always replace C, if D is populated. *Otherwise only C
should be considered. *File is much bigger than this, but an example formula
I was trying to work with (which is not properly calculating the MIN) is:

={MIN(MIN((IF((a1:a4="1")*(b1:b4=2009)*(d1:d4=0),c 1:c4)),MIN((IF((a1:a4="1"*)*(b1:b4=2009)*(d1:d4<0 ),d1:d4)))))}

Can anyone help? * * * * * * * *