Modify A Formula To Include AND

C

carl

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.
 
A

Aladin Akyurek

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)))
 
B

Bob Phillips

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)
 
Top