Bob Phillips wrote:


"Eric" wrote in message
...
Bob Phillips wrote:

Blank is zero, all you need is =E8-(B9+G8)

On the other

=MIN(IF(A1:A20<0,A1:A20))

which is an array formula, so commit with Ctrl-Shift-Enter.


=E8-(B9+G8)
compains that "this formula in this cell refers cells that are currently
empty" which is the same problem i had before and also the cell contains
a green triangle in its upper left corner. Whats that about?
sorry for basic q's but I'm real new to excel

Sorry, I have never seen that message.

Ah, i found it, its an option that was turned on "Warn about formulas
referring to empty cells"
Anyway, thanks for the help, the stuff you showed me works good.
Eric