Hi
1. Not really sure what you're trying to achieve. Do you mean an array
formula such as
=MAX(IF(A1:A100="value1")*(B1:B100="value2"),C1:C1 00))

2. Yes

--
Regards
Frank Kabel
Frankfurt, Germany
"Microofficetester" schrieb im
Newsbeitrag ...
question 1
can you use the MAX function to check more than one condition?

question 2
when entering a formula by selecting cell references, do you only need to
type the operators and the initial "="?