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.

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
news
>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.

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
> news
> >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.
>
>