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. |
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. |
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. |
All times are GMT +1. The time now is 07:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com