On Sat, 19 Apr 2008 18:53:53 GMT, "gavin"
wrote:


"akphidelt" wrote in message
...
Wow, glad it worked out. Yea it's amazing how things can be figured out in
excel. What's funny is some guys on here can probably do that same exact
equation that's half the size of mine.

Well no one's posted an alternative so I reckon your solution is perfect!


The following is a bit shorter, but the price for that is maybe less
clarity, so I suggest you stick with the formula suggested by
akphidelt.

=IF(AND(A1=C1,B1=D1),4,IF(AND(A1=B1,C1=D1),2,IF((A 1-B1)*(C1-D1)0,1,0)))

Lars-Åke