Thread: If/Then Formulas
View Single Post
  #29  
Old August 13th, 2008, 07:20 PM posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\)[_1116_]
external usenet poster
  
Posts: 1
Default If/Then Formulas
Here is an even shorter

=E7*INT(F7^.7)

Bravo!!! It is hard to imagine that a shorter one will be found.

Rick