| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
MIN function
Try something like this:
For A1 as a value or blank =MIN(+A1,(formula)) Does that help? *********** Regards, Ron XL2002, WinXP "noyb" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
MIN function
Hi
=MIN(SUM(A1),<formula) -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "noyb" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
MIN function
Yes, thanks
Ron Coderre wrote: Try something like this: For A1 as a value or blank =MIN(+A1,(formula)) Does that help? *********** Regards, Ron XL2002, WinXP "noyb" wrote: 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
MIN function
Thanks for reply. This works but I will stick with the shorter "+"
example above. Arvi Laanemets wrote: Hi =MIN(SUM(A1),<formula) |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
MIN function
Hi
The formulas don't behave exactly in same way. My formula returns 0 whenever in A1 is non-numeric, Ron's formla returns 0, when A1 is empty, but error when there is some text entry, or even a formula which returns empty string. Which you prefer, depends on your data. -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "noyb" wrote in message ... Thanks for reply. This works but I will stick with the shorter "+" example above. Arvi Laanemets wrote: Hi =MIN(SUM(A1),<formula) |
| Reply |
| 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 | |||
Linear Mode
