Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to have auto calc cells be blank unless entry made
I am creating a travel report that will be filled out on excel and also by
hand. I want cells to auto calculate for those who complete in excel, but need the cells to not show anything (such as $0.00) when nothing is entered so those completing by hand can still use those same cells. Right now I have a date range and # of miles and reimbursement amount cells that auto calculate. When I leave the cells that provide the auto number blank, I still get something - such as the $0.00. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
put date and time in cells after entry made in shared workbook | Excel Worksheet Functions | |||
auto calc on, but have to edit (f2) cells to force re-calc..help! | Excel Worksheet Functions | |||
After a date entry is made, only displaying the Day | Excel Discussion (Misc queries) | |||
Count blank cells since last entry | Excel Worksheet Functions | |||
Want a number of cells to be auto completed based on entry in one. | Excel Worksheet Functions |