ExcelBanter - If then formulas in excel?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If then formulas in excel? (https://www.excelbanter.com/excel-discussion-misc-queries/60218-if-then-formulas-excel.html)

vtchiokim

If then formulas in excel?

I am trying to find out if there is a formula in excel that would let me note
the word "complete" in one cell if another cell has a date in it and if there
is no date in the cell then a number is stated.

Example:

In A1: 12/13/05 or blank
In B1: Number of days left to complete (D1-C1...these are dates) if A1 does
not have a date
In C1: todays date
In D1: date needed

Scott Wagner

If then formulas in excel?

=IF(A1="",D1-C1,"Complete")

"vtchiokim" wrote:

I am trying to find out if there is a formula in excel that would let me note
the word "complete" in one cell if another cell has a date in it and if there
is no date in the cell then a number is stated.

Example:

In A1: 12/13/05 or blank
In B1: Number of days left to complete (D1-C1...these are dates) if A1 does
not have a date
In C1: todays date
In D1: date needed

Duke Carey

If then formulas in excel?

=IF(ISBLANK(A1),D1-C1,"Complete")

"vtchiokim" wrote:

I am trying to find out if there is a formula in excel that would let me note
the word "complete" in one cell if another cell has a date in it and if there
is no date in the cell then a number is stated.

Example:

In A1: 12/13/05 or blank
In B1: Number of days left to complete (D1-C1...these are dates) if A1 does
not have a date
In C1: todays date
In D1: date needed

All times are GMT +1. The time now is 05:31 AM.