Thread: If/Then Formulas
View Single Post
  #25   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\)[_1114_] Rick Rothstein \(MVP - VB\)[_1114_] is offline
external usenet poster
  
Posts: 1
Default If/Then Formulas
=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

Reply With QuoteReply With Quote