 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / May 2006MIN 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 Try something like this: For A1 as a value or blank =MIN(+A1,(formula)) Does that help? *********** Regards, Ron XL2002, WinXP > 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 [quoted text clipped - 3 lines] > does Excel not see a blank as 0, if this is the problem? > Thanks Yes, thanks > Try something like this: > [quoted text clipped - 16 lines] >>does Excel not see a blank as 0, if this is the problem? >>Thanks Hi =MIN(SUM(A1),<formula>)  SignatureArvi Laanemets ( My real mail address: arvi.laanemets<at>tarkon.ee ) >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. [quoted text clipped - 3 lines] > Excel not see a blank as 0, if this is the problem? > Thanks Thanks for reply. This works but I will stick with the shorter "+" example above. > Hi > > =MIN(SUM(A1),<formula>) 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. SignatureArvi Laanemets ( My real mail address: arvi.laanemets<at>tarkon.ee ) > Thanks for reply. This works but I will stick with the shorter "+" example > above. > >> Hi >> >> =MIN(SUM(A1),<formula>) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.