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

=MIN(IF(A1:A20<0,A1:A20)) works great, thanks!
Eric