C

#### Christi

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),c1:c4)),MIN((IF((a1:a4="1")*(b1:b4=2009)*(d1:d4<>0),d1:d4)))))}

Can anyone help?