| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| growth function with blanks | Excel Worksheet Functions | |||
| SUBTOTAL function to average column without blanks | Excel Worksheet Functions | |||
| copy range of cells with blanks then paste without blanks | Excel Worksheet Functions | |||
| Paste Special Skip Blanks not skipping blanks, but overwriting... | Excel Discussion (Misc queries) | |||
| Excluding 0s and blanks from a LINEST function | Excel Worksheet Functions | |||
Threaded Mode
