View Single Post
  #36   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

See other post. No, they certainly aren't.
--
John C


"Peo Sjoblom" wrote:

They certainly are
--


Regards,


Peo Sjoblom

"Lars-Åke Aspelin" wrote in message
...
On Wed, 13 Aug 2008 15:01:17 -0400, "Rick Rothstein \(MVP - VB\)"
wrote:

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?

Lars-Åke