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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to have auto calc cells be blank unless entry made
Hi
A formula will aways return a zero if the calculation equals 0. To avoid this you need to test if your formula returns zero, and of so leave the cell empty. Look at this example: =IF(SUM(A1:A6)=0,"",SUM(A1:A6)) Hopes it helps Regards, Per "miss sass" <miss skrev i meddelelsen ... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to have auto calc cells be blank unless entry made
You can also test if a specific cell is empty....and if it is return a blank,
e.g. =IF(A1="","",A1*B1) This formula gives you the result of the calculation A1*B1....but if A1 is blank the formula will just return a blank "Per Jessen" wrote: Hi A formula will aways return a zero if the calculation equals 0. To avoid this you need to test if your formula returns zero, and of so leave the cell empty. Look at this example: =IF(SUM(A1:A6)=0,"",SUM(A1:A6)) Hopes it helps Regards, Per "miss sass" <miss skrev i meddelelsen ... 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. |
Reply |
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 |