Formula for looking up blank and/or date-filled cells- conting
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
|