I am using excel 97 and am trying to get a blank space returned in a
spreadsheet. What I am trying to avoid is a long series of zeros
across my sheet.

An ending balance of 100.00 in January becomes the beginning balance in
February but then 100.00 is in each months cell the rest of the year.

What I came up with was this:

=IF(C380,C15-37," "), Where C38 is the ending balance in
January,C15-C37 is in C38, creating the formula for the opening balance
in February and " " represents the blank spaces I would like to see in
each successive month.

The problem is I get 0.00 in each successive months opening balance
which is just the situation I was trying to avoid.

Can anyone help me accomplish what I am trying to do?

Bill Haddick



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/