1 less character...
=EVEN(H7)/2*G7
--
John C
"Lars-Åke Aspelin" wrote:
On Wed, 13 Aug 2008 10:38:27 -0400, "Rick Rothstein \(MVP - VB\)"
wrote:
=E7*INT(1+F7/3)
<<<< Several skipped postings
Again, assuming DV, even shorter
=E7*INT((F7+1)/2)
Very nice!
LOL... I almost had that formula originally (I just needed to think about it
a "short" time more<g).
Rick
Here is an even shorter
=E7*INT(F7^.7)
Lars-Åke