If/Then Formulas
Someone just tapped me on the shoulder, it was a veterinarian, he told me to
step take my club and step away from the horse, as he is well and truly dead.
--
John C
"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 moreg).
Rick
|