I think this would be much better as a custom function and then you could
copy it down the cells.
When you say this goes on for several rows is the comparison always to cell
C2 or is it C3, C4...etc?

Nick

wrote in message
oups.com...
I should have mentioned this....my mistake - we have used formulas for
some of these calculations, but in this case, we will have more than 7
statements....