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!

Hi,

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

=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".

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


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

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,""),"")

Thank you, this one worked!

On Wed, 6 Nov 2013 17:25:43 +0000, JFELLOW wrote:

Thank you, this one worked!

Glad to help. Thanks for the feedback.

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!

=IF( ISNA(D2), "", IF(L21, D2-L2, "") )

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...