Please tell me, is it the longest formula you have ever created?
I wouldn't know, but basically it's twice the same formula wrapped in an IF(ISERROR function. XL2010 has made things muche easier with the IFERROR function.
OTH a long formula is not always the best solution ! Sometimes a helper column makes things much more fluid