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