The MIN function only evaluates numbers. Since a blank is not a number, the
MIN function ignores it. Try this:

=MIN(100,IF(A1="",0,A1))

HTH,
Elkar


"catherine bodine" wrote:

in Excel 2003 I have a formula =MIN (100, A1)

If A1 is blank it returns 100 but if A1=0 then it returns 0.

Why doesn't it see the blank as a 0? Is there a setting or option that I am
missing? I didn't have this problem in Excel 2000 (my work recently upgraded
us)