Thread
:
how to have auto calc cells be blank unless entry made
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
daddylonglegs
external usenet poster
Posts: 287
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 With Quote
daddylonglegs
View Public Profile
Find all posts by daddylonglegs