Different values depending on ISBLANK

[Matt_Straya]

Hi,
This is the code I have in F6

=IF(AND(ISBLANK(E6), ISBLANK(D6)), "", D6-$E$4)

But Id like F6 to say "Delivered" if E6 isn't blank.

PS. there are dates in the cells if they aren't blank.

Any ideas?

 

[NARAYANK991]

Hi ,

Just add to your existing formula , as follows :

=IF(AND(ISBLANK(E6), ISBLANK(D6)), "", IF(E6 <> "" , "Delivered" , D6-$E$4))

Narayan

 

[Matt_Straya]

Thanks Narayan. It works except for the #Value error. Have tried IFERROR but it didn't work

 

[NARAYANK991]

Hi ,

Which cell can have the error value ?

And what should be the output in that case ?

Narayan

 

[Matt_Straya]

Working with the formula on sheet MER_Jan. The due date in column D comes from sheet MER_MAP and the date in column is entered when the report is done.
Have attached an example. Thanks for your time.

 

[NARAYANK991]

Hi ,

Use this formula :

=IF(AND(E6 = "", D6 = ""), "", IF(E6 <> "", "Delivered", D6-$E$4))

Narayan

 

[Matt_Straya]

PERFECT! I was way off track! Thanks so much Narayan!