Thread
:
Why are blanks being ignored by my MIN function?
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre
external usenet poster
Posts: 2,118
Why are blanks being ignored by my MIN function?
The MIN function ignores blanks...that's usually preferred.
Try this:
=MIN(100,N(A1))
Is that something you can work with?
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
"catherine bodine" <catherine
wrote in
message ...
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)
Reply With Quote
Ron Coderre
View Public Profile
Find all posts by Ron Coderre