View Single Post
  #28   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default If/Then Formulas

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