Quote:
Originally Posted by Lugh
Very nice, p45cal 
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? |
Yes, it will work, and it's straightforward and quite easy to maintain. It does require at least one helper column, which can be hidden.
I thought the OP was looking for a single-cell formula.