invoice displays 0s when blank
I created an invoice. I have used the cells A through G. Where A is the description of items and G is the Total sale. My problem is when A is blank G displays $0.00 for total. How can I get G to be blank when A is blank? Some other cells in between display [...]

Answer Question   |  March 12, 2012  8:42 PM
Excel Cell Formatting, Microsoft Excel 2003

Data entry and calculations in the same cell
I have an excel template and would like to allow the user to input their date in one of two ranges and have the other range calculated automatically based on a formula to use in each cell This means that the formula needs to be outside the cells in the two ranges as they are [...]

Answer Question   |  April 29, 2010  5:30 PM
Data conversion, excel, Excel Cell Formatting, Excel formulas

Cell Formatting Protection
How do I protect a cell (or series of cells) from being re-formatted, and yet allow the user to Sort and Copy the Data within the spreadsheet? When I LOCK the cell(s), then protect the Worksheet and contents of locked cell, I allow them to Select Locked Cells, Select Unlocked Cells, Delete Rows, Insert Rows, [...]

Answer Question   |  April 3, 2009  2:43 PM
Excel Cell Formatting, Excel workbooks, Microsoft Excel

Cell color coding
I am using a spreadsheet designed by someone else and it has some formatting gin place that when a date is entered if it is within a certain period the cell goes green if not red and so on. I need to add some columns and apply the same formatting however for some reason I [...]

Answer Question   |  February 22, 2009  10:34 PM
Excel 2007, Excel Cell Formatting, Microsoft Excel