Needing nested IF statement advice

[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:

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.

 

[Jerry W. Lewis]

=IF(C_,"N/A",IF(ISBLANK(A_),"",TODAY()-A_))

Jerry