I have a cell that multiplies one cell by another and displays the total. The trouble is that if nothing is in the other cells it just displays a '0'.
Is there a way of setting it to not display a '0' and just remain blank ?
Thank you for your help
John
I have a workbook with several sheets in it. The idea is that you fill in a project sheet and it automatically fills in the corresponding invoice sheet. The two sheets are called : Project no. and Invoice1
Invoice1 was our current invoice sheet that I copied into this workbook.
I have cells in...
I have an Access database for customers with Customer Name, Customer Address (blah blah, all the usual fields)
I also have an Excel sheet for projects which requires the inputting of the customer name and address.
My question is this...
Is there any way to link the Excel customer name box to...
