Modify A Formula To Include AND
 

I am using this formula:

=MIN(IF($A$1:$A$7=D1,$B$1:$B$7))

I wouldlike to modify it to perform the calculation if E1:E7="Check"

Thank you in advance.

Unlear what you exactly intend to modify to the formula you post...

Maybe:

(a)

=MIN(IF($E$1:$E$7="Check",$B$1:$B$7))

(b)

=MIN(IF($A$1:$A$7=D1,IF(E1:E7="Check",$B$1:$B$7)))

carl wrote:
I am using this formula:

=MIN(IF($A$1:$A$7=D1,$B$1:$B$7))

I wouldlike to modify it to perform the calculation if E1:E7="Check"

Thank you in advance.

I think you mean

=MIN(IF(($A$1:$A$7=D1)*($E$1:$E$7="Check"),$B$1:$B $7))

as an array formula

--

HTH

RP
(remove nothere from the email address if mailing direct)


"carl" wrote in message
...
I am using this formula:

=MIN(IF($A$1:$A$7=D1,$B$1:$B$7))

I wouldlike to modify it to perform the calculation if E1:E7="Check"

Thank you in advance.