Thanks for the response, Bill.

I've just posted in the thread
what I was missing / doing wrong
(about 8 minutes before your response)

It was a line break I missed clearing
after pasting your formula as -is.

My apologies for the trouble...

rgds,
Max
-----------------------------------------
Use xdemechanik <atyahoo<dotcom for email
----------------------------------------------------------------------------
"Bill Manville" wrote in message
...
Max wrote:
I pasted your formula as-is into E1, copied it down to E8,
- i.e. the last row (IAH-DTW-CO) in the table in A2:C8 (as per OP's
post)
and it returned a "1".


I did the same and it returned a 0, as the formula clearly should, since
the OR gives True because B8="DTW" is True, it then uses IF(C8="CO",0,1)
which gives 0 because C8="CO".

Maybe you didn't transcribe the data or the formula correctly.
Could either of the CO be C0?

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup