Originally Posted by Ron Rosenfeld[_2_]

On Mon, 4 Nov 2013 17:23:44 +0000, JFELLOW wrote:


I need help with an IF function. Essentially, I have a very simple
calculation
=IF(L21, 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(L21, D2-L2,""),"")