formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a running balance formula that I have copied further down the column. How do I make the last entry balance not show in the column?
 
Hi
not quite sure what you're trying to do?. Cn you post an example (plain
text - no attachment please)

--
Regards
Frank Kabel
Frankfurt, Germany

Loca said:
I have a running balance formula that I have copied further down the
Click to expand...
column. How do I make the last entry balance not show in the column?
 
Hi Loca

if i'm understanding you correctly you have a list of values say in column A
and alongside them in column B you have a running sum so that it looks
something like this:

A B
1 10 10
2 5 15
3 10 25
4 25
5 25

and you'ld like the 25 in B4 & B5 not to show until there's a value in A4 &
A5 respectively - if so, change the formula in B2 to

=IF(ISBLANK(A2),"",A2+B1)
and fill down

Hope this helps
Cheers
JulieD

Loca said:
I have a running balance formula that I have copied further down the
Click to expand...
column. How do I make the last entry balance not show in the column?
 
Back
Top