MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Hiding formula results in tables if no I/P on that row


Posted by Graham on January 26, 2002 9:39 PM

I am trying to produce a monthly bank statement check sheet. Showing Income and outgoings, with a running total coloum down the right side. At the moment the total is displayed all the way to the bottom of the page, even if there is no IN or Out on the Row. (ie displays the same answer to the last sum the rest of the way down the page)I would like the total to be blank unless there is an entry on that line. Im sure there must be an easy answer but im affraid I cant find it and would be grateful for any help.


Posted by Bariloche on January 26, 2002 9:59 PM

Graham,

Depending on how you are calculating your running total, a formula as simple as =IF(A3>0, A3+B2,"") (placed, in this example, in cell B3) could work.

See if you can adapt that to your situation.

enjoy