Thread: Why are blanks being ignored by my MIN function?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
catherine bodine catherine bodine is offline
external usenet poster
  
Posts: 1
Default Why are blanks being ignored by my MIN function?
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 QuoteReply With Quote