Need help with an IF Function

[JFELLOW]

I need help with an IF function. Essentially, I have a very simpl
calculation
=IF(L2>1, D2-L2, ""). Both the D and L columns are MM/DD/YYYY and th
D2-L2 calculation is determining the # of days we are within or outsid
a deadline. However, in some cases a due date (column D) was not give
and therefore in place of the MM/DD/YYYY is "N/A". I can't seem t
figure out the proper imbedded multiple IF function that will keep th
cell blank or return even a text value. I would be happy with a blan
cell or "N/A" just don't want to see "#VALUE!"... any help would b
greatly appreciated

 

[Claus Busch]

Hi,

Am Mon, 4 Nov 2013 17:23:44 +0000 schrieb JFELLOW:

=IF(L2>1, D2-L2, ""). Both the D and L columns are MM/DD/YYYY and the
D2-L2 calculation is determining the # of days we are within or outside
a deadline. However, in some cases a due date (column D) was not given
and therefore in place of the MM/DD/YYYY is "N/A".

try:
=IF(L2*D2<>0,D2-L2,"")


Regards
Claus B.

 

[Ron Rosenfeld]

I need help with an IF function. Essentially, I have a very simple
calculation
=IF(L2>1, D2-L2, ""). Both the D and L columns are MM/DD/YYYY and the
D2-L2 calculation is determining the # of days we are within or outside
a deadline. However, in some cases a due date (column D) was not given
and therefore in place of the MM/DD/YYYY is "N/A". I can't seem to
figure out the proper imbedded multiple IF function that will keep the
cell blank or return even a text value. I would be happy with a blank
cell or "N/A" just don't want to see "#VALUE!"... any help would be
greatly appreciated!

Perhaps:

=IFERROR(IF(L2>1, D2-L2,""),"")

 

[Stan Brown]

I need help with an IF function. Essentially, I have a very simple
calculation
=IF(L2>1, D2-L2, ""). Both the D and L columns are MM/DD/YYYY and the
D2-L2 calculation is determining the # of days we are within or outside
a deadline. However, in some cases a due date (column D) was not given
and therefore in place of the MM/DD/YYYY is "N/A". I can't seem to
figure out the proper imbedded multiple IF function that will keep the
cell blank or return even a text value. I would be happy with a blank
cell or "N/A" just don't want to see "#VALUE!"... any help would be
greatly appreciated!

=IF( ISNA(D2), "", IF(L2>1, D2-L2, "") )

 

[JFELLOW]

Thank you, this one worked!

;1614791']On Mon, 4 Nov 2013 17:23:44 +0000, JFELLO

I need help with an IF function. Essentially, I have a very simple
calculation
=IF(L2>1, D2-L2, ""). Both the D and L columns are MM/DD/YYYY and the
D2-L2 calculation is determining the # of days we are within o outside
a deadline. However, in some cases a due date (column D) was not given
and therefore in place of the MM/DD/YYYY is "N/A". I can't seem to
figure out the proper imbedded multiple IF function that will keep the
cell blank or return even a text value. I would be happy with a blank
cell or "N/A" just don't want to see "#VALUE!"... any help would be
greatly appreciated!-

Perhaps:

=IFERROR(IF(L2>1, D2-L2,""),""