software

I have a simple =MIN(A1,lt;formulagt;) 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 lt;formulagt; to 5 and still get min of 0 amp; 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, WinXPquot;noybquot; wrote:

gt; I have a simple =MIN(A1,lt;formulagt;) if A1 is 0 the min=0 but if a1 is
gt; blank min=formula (which resolves to greater than 0). A1 is formated as
gt; number. Never seen this before and have no idea what is causing this.
gt; Any ideas much appreciated.
gt; ps just changed lt;formulagt; to 5 and still get min of 0 amp; 5 = 5??? Why
gt; does Excel not see a blank as 0, if this is the problem?
gt; Thanks
gt;

Hi

=MIN(SUM(A1),lt;formulagt;)--
Arvi Laanemets
( My real mail address: arvi.laanemetslt;atgt;tarkon.ee )
quot;noybquot; gt; wrote in message
...
gt;I have a simple =MIN(A1,lt;formulagt;) if A1 is 0 the min=0 but if a1 is blank
gt;min=formula (which resolves to greater than 0). A1 is formated as number.
gt;Never seen this before and have no idea what is causing this. Any ideas
gt;much appreciated.
gt; ps just changed lt;formulagt; to 5 and still get min of 0 amp; 5 = 5??? Why does
gt; Excel not see a blank as 0, if this is the problem?
gt; Thanks
Yes, thanks

Ron Coderre wrote:
gt; Try something like this:
gt;
gt; For A1 as a value or blank
gt;
gt; =MIN( A1,(formula))
gt;
gt; Does that help?
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP
gt;
gt;
gt; quot;noybquot; wrote:
gt;
gt;
gt;gt;I have a simple =MIN(A1,lt;formulagt;) if A1 is 0 the min=0 but if a1 is
gt;gt;blank min=formula (which resolves to greater than 0). A1 is formated as
gt;gt;number. Never seen this before and have no idea what is causing this.
gt;gt;Any ideas much appreciated.
gt;gt;ps just changed lt;formulagt; to 5 and still get min of 0 amp; 5 = 5??? Why
gt;gt;does Excel not see a blank as 0, if this is the problem?
gt;gt;Thanks
gt;gt;

Thanks for reply. This works but I will stick with the shorter quot; quot;
example above.

Arvi Laanemets wrote:
gt; Hi
gt;
gt; =MIN(SUM(A1),lt;formulagt;)
gt;
gt;

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.laanemetslt;atgt;tarkon.ee )
quot;noybquot; gt; wrote in message
...
gt; Thanks for reply. This works but I will stick with the shorter quot; quot; example
gt; above.
gt;
gt; Arvi Laanemets wrote:
gt;gt; Hi
gt;gt;
gt;gt; =MIN(SUM(A1),lt;formulagt;)
gt;gt;