No, it doesn't want to multiply *text*!

That means your dates are *not* XL "legal" dates.

Try this:

=IF(AND(A10,B10),"No",IF(OR(A10,B10),"Yes","N/A"))

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Roady" wrote in message
...
Unfortnately, that returns an Value error. I think it doesn't want to
multiply dates- just as a guess...

"RagDyeR" wrote:

Does this work for you:

=IF(A1*B10,"No",IF(A1+B10,"Yes","N/A"))
?

Copy down as needed.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Roady" wrote in message
...
Hi:

Column A is called 'Receipt Deadline' (mo/dd/yr)
Column B is called 'Actual Receipt Date'. (mo/dd/yr)
Column C would be called 'Outstanding Receipts'?' (yes/no/'N/A')

I want Column C to look in Column A and IF there is a date entered there,
then look up column B and see if there is a date entered there as well.
Then
1 of 3 scenarios will occur in Column C:

1. If there is a date in A but none in B, then I want it to return a value
of 'Yes' in C.
2. If there is a date in both A and B, then I want it to return a value of
'No' in C.
3. If there are no dates in either A or B, I want it to return a value of
'N/A'.

Can you help? thank you!
Roady