Very nice, p45cal
Quote:
Originally Posted by p45cal
I too found it difficult to get a worksheet formula that was easy to maintain
|
My first thought—before seeing your answer—was a conditional formula in Col D which would:
Count the number of numerical entries between the adjoining Col C cell and C2;
Multiply the Col C value by .1, .15 or .2 accordingly.
Won't that work, and be easy enough?