Reply to thread

Message: [QUOTE="JFELLOW, post: 7423796"] 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 [/QUOTE]