Here is an example that tests column A for the value a, and gets the MAX
value in B that is less than 10

=MAX(IF(A1:A10="a",IF(B1:B10<10,B1:B10)))

it is an array formula, so commit with Ctrl-Shift-Enter,

--

HTH

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


"Microofficetester" wrote in
message ...
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 "="?