You are 100% correct, Bernie. Thanks for the tip, I didn't realize that your
method actually "broke" the nest on the IFs. That will probably do the trick!

Thanks fellas for the input!

Dave

"Bernie Deitrick" wrote:

Bernard,

Yes, they are mutually exclusive. That's the nature of bowling scoring: if
E4 is an "X", then F4 cannot be "/". I'm not sure of his column structure,
but it appears that B and C will be the first "frame", E and F the second
frame, H and I, etc... for emtry, then D, G, J... for calculations.

Bernie


"Bernard Liengme" wrote in message
...
This, of course, implies that the tests are mutually exclusive. If B4="X"
, E4="X" and H4="X" and F4="/" then the result would be 50. Would be fine
it the same three cells were being test in each section of the sum.

Bernard