| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MIN function
I have a simple =MIN(A1,<formula) if A1 is 0 the min=0 but if a1 is
blank min=formula (which resolves to greater than 0). A1 is formated as number. Never seen this before and have no idea what is causing this. Any ideas much appreciated. ps just changed <formula to 5 and still get min of 0 & 5 = 5??? Why does Excel not see a blank as 0, if this is the problem? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
| Date & Time | New Users to Excel | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Threaded Mode
