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
|