View Single Post
  #34   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\)[_1118_] Rick Rothstein \(MVP - VB\)[_1118_] is offline
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.

1 less character...
=EVEN(F7)/2*E7


LOL... I stand corrected. Excellent!

Rick


=E7*INT(F7^.7)

=EVEN(F7)/2*E7

Are they not of the same length? What am I missing?


Hmm! I believed John without bothering to actually count the characters. So,
I guess... It's a tie! Interesting though... two completely different
approaches coming in at so few characters.

Rick