formula problem

[hhaddick]

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(C38>0,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

 

[Tom Ogilvy]

the only way the formula could produce zero is if C15-C37 equaled zero and
C38 did not - but you said C38 equals C15-C37, so you should either get a
positive number or " "

Did you drag fill the formula to other cells. This shifts you references
depending on which direction you were dragging.

It is unclear how these formulas could produce a zero if they are all like
what you show.

 

[Chris]

I think that there is a way to solve the problem but I am
having a hard time viusallizing your table. Does the
feb. cell return a 0.00 or a blank. If it is blank then
I can help. Send me an e-mail with the table if you want
and I can help you with more certainty.

 

[hhaddick]

I am sorry for the confusion, Tom. What I meant is I get a long string
of 100.00 across my spreadsheet when what I want is a string of blank
cells.

Is there a way to accomplish this?

Again, sorry for the confusion.

Bill Haddick

 

[Tom Ogilvy]

I guess you could check if this formula would produce the same value as the
last formula, then show nothing

=if(previous cell = "","",if(formula=previous cell,"",formula))