Prev: Problem to close a group of columns
Next: "manual page breaks error"
From: cdaniels on 16 Nov 2006 15:29
I have two columns, a date in the left, and in the right a formula to
calculate the date plus 14 days. For some of the cells in the left column,
there won't be a date right away. I want to have the formula to calcualte
the date in all the cells in the right column so when i do enter a date in
the left, it just pops up the correct date in the right column. How do i
write the forumula so that it does not try to calculate the blank cells?
Right now it gives me a date of 1/14 as the calculation from the blank cells.

Thank you!
--
C. Daniels
From: Teethless mama on 16 Nov 2006 15:33
=IF(A1="","",A1+14)


"cdaniels" wrote:

> I have two columns, a date in the left, and in the right a formula to
> calculate the date plus 14 days. For some of the cells in the left column,
> there won't be a date right away. I want to have the formula to calcualte
> the date in all the cells in the right column so when i do enter a date in
> the left, it just pops up the correct date in the right column. How do i
> write the forumula so that it does not try to calculate the blank cells?
> Right now it gives me a date of 1/14 as the calculation from the blank cells.
>
> Thank you!
> --
> C. Daniels
 | 
Pages: 1
Prev: Problem to close a group of columns
Next: "manual page breaks error"