You did not post your layout or formulas but see if this helps. This is an
ARRAY formula which must be entered using ctrl+shift+enter

=MAX(IF(B2:B22<0.05,B2:B22))

--
Don Guillett
SalesAid Software

"Milly" wrote in message
...
How do you include values in a min,max calcualtion with the character <
preceeding some of them. E.g <0.05. Please help, loads of data to get
through
and these are slowing me down!!