.. In the formula bar, look for the curly braces { } -- which
will be inserted by Excel (we don't type these braces) -- as a visual cue
that it's correctly array-entered...
The formula should register & appear like this in the formula bar,
with CSE correctly done:
{=MAX(IF(A1:A10<4,A1:A10))}
{=MIN(IF(A1:A101,A1:A10))}
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---