Matt_Straya
Member
Hi,
This is the code I have in F6
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?
This is the code I have in F6
Code:
=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?