Getting rid of all negative numbers on a worksheet

  • Thread starter Thread starter abxy
  • Start date Start date
A

abxy

Ok, for the workbook i'm building, I need all numbers equal to or less
than 0 to not be displayed. Instead I want the cells to be left blank
or display: -- (i'd prefer if the cells were blank though).

The real problem is that I have a range of cells that have the formula
=DAYS360 in them. That formula counts the days between two dates on the
worksheet, but when one date is entered and the other isn't, the cell
displays a huge negative number( becuase of the dept. i work in, i
never know the second date until sometime later, but the sheet still
has to be printed up in the meantime). I've tried everything I could
think of to fix it or get around this problem, but nothing quite works,
then, I realized "well, if I could just get the worksheet to display a
blank cell anytime a cell value is 0 or less, then the problem wouldn't
exist"

thanks
 
Put those cells with formulas into an If statement, i.e.

=IF(SUM(A1:A10)<=0,"",SUM(A1:A10))

This will put a "blank" in the cell if the value of the formula is less
than or equal to 0.
 
This works. I can't beleive it works. Thankyou very very much, you'd
just made me one happy worker bee.

The concept nesting formulas within formulas never occured to me,
becuase I had the thought that each and everyone formula must start
with an "=".

Anyhoo, thankyou veeeerrry much.
 
Glad that it worked. Yes, nesting formulas can perform some magic i
Excel. I'm still learning myself
 
Back
Top