IF statement help

[matlocktm]

Hello,
I am looking for some advice on creating a nested IF statement. The
criteria I am using is as follows:

Column A - Today's date
=TODAY()

Column B - Requisition #
number format

Column C - Purchase order #
number format

Column D - # of days since requisition was entered
number format

I believe I need to create a nested IF statement in order to achieve
the following:

The formula in Column D has to reflect "If Column A has no value,
return blank, otherwise, return today's date minus the date (or value)
entered in Column A:

=IF(ISBLANK(A_),"",TODAY()-A_)

In addition to the previous argument, the following has to apply (and
this is where I am stuck):

If Column C has any value at all, Column D needs to return "N/A",
otherwise return today's date minus the date (or value) entered in
Column A.

I'm hung up on how to create the second IF statement, as I am an Excel
novice. I have hammered the Excel help files and looked for a thread
regarding a similar problem that might point me in the right
direction, but so far, no luck. Any advice would be greatly
appreciated.

 

[Frank Kabel]

Hi
try
=IF(ISBLANK(A1),"",IF(C1="","N/A",TODAY()-A1))

 

[Ron Rosenfeld]

Hello,
I am looking for some advice on creating a nested IF statement. The
criteria I am using is as follows:

Column A - Today's date
=TODAY()

Column B - Requisition #
number format

Column C - Purchase order #
number format

Column D - # of days since requisition was entered
number format

I believe I need to create a nested IF statement in order to achieve
the following:

The formula in Column D has to reflect "If Column A has no value,
return blank, otherwise, return today's date minus the date (or value)
entered in Column A:

=IF(ISBLANK(A_),"",TODAY()-A_)

In addition to the previous argument, the following has to apply (and
this is where I am stuck):

If Column C has any value at all, Column D needs to return "N/A",
otherwise return today's date minus the date (or value) entered in
Column A.

I'm hung up on how to create the second IF statement, as I am an Excel
novice. I have hammered the Excel help files and looked for a thread
regarding a similar problem that might point me in the right
direction, but so far, no luck. Any advice would be greatly
appreciated.

Well, column A should not have Todays date, but rather some date

So something like (and I've not debugged it):

=IF(ISBLANK(A1),"",IF(ISNUMBER(C1),NA(),TODAY()-A1))



--ron