Once again im a little stuck with Excel. This hopefully will be an easy one and I'm just missing something simple.
I've got a basic spreadsheet for money in and out a a groups bank account. People pay in either by direct bank transfer or PayPal. Now PP charge a fee and to keep the figures right, Ive got to allow two columns for these I then have a final 'Total In' column which simply takes away these fees from the original amount. Now the formula im using when copied down the column leaves any lines not filled in as £0.00 is there any way of making Excel just leave those cells empty until something is entered in the cells of the corresponding row.
I've make a quick PS of the Spreadsheet that I'm talking about
:
Hope that makes sence, and thanks in advance for any help.