Well, what makes this complicated is because the cells aren't in a
contiguous range. Much of the formula is dedicated to dealing with just that
one aspect of the problem. If the cells were in a contiguous range this
would be relatively simple.

So, if there was a way that you could rearange your layout and put these
cells in a contiguous range it would make things easier.

As is, this formula really isn't any better than the one you're using now.

--
Biff
Microsoft Excel MVP


"memilanuk" wrote in message
...
Thanks for the response. I'll have to chew on that one for a bit; I'm
not familiar w/ the use of some of those functions (obviously).

What would you suggest as far as a 'redesign of my data'? At this
point I am mainly replicating a printed form that had to be calculated
by hand. I've seen others work where they use a decimal instead of
the dash, and/or go with a format of NNNN.vvvv and then pick off the
applicable portions, or enter the two portions of the score in
separate cells and then concatenate them at the end for a print copy
of the score sheet. For this one sheet I will probably stick w/ the
format as given, but in the future I will have some more latitude as
far as how the user enters data.

Thanks,

Monte