View Single Post
  #26  
Old August 13th, 2008, 04:02 PM posted to microsoft.public.excel.worksheet.functions
John C[_2_]
external usenet poster
 
Posts: 1,350
Default 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