Hi
Could anyone help with this problem.
I've attached an example of a cash flow statement, and as you can see column "F" has a running total all the way to the bottom.
What I would like to achieve is that all the cells in column "F" below the last entry line "F5 down inclusive" be clear.
Only when there has been a new entry in either column "D" or "E" does the running total appears in that row.
Can anyone help please?
call your forumla in F "X"
for row 2
=IF(or(D2<>"",E<>""),X,"")
should help. if not attach a work book
The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
<--- If a post helps hit the star
Thank you very much for your reply but I'm lost.
I have however attached a sample book of what I'm trying to achieve which is to make the area coloured yellow invisible until another entry is made in either column B or C.
Could you apply the formulas and I'll go from there?
I hope this is OK?
Many thanks
Try
=IF(AND(B7="",C7=""),"",D6-B7+C7)
or
=IF(COUNT(B7:C7),SUM(D6,-B7,C7),"")
and dragged down
Last edited by Cutter; 05-04-2012 at 03:33 PM. Reason: Added second formula
Many thanks to all that replied, the formula from Cutter seems to have done the trick.
Much appreciated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks