A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

If/Then Formulas



 
 
Thread Tools Display Modes
  #31  
Old August 13th, 2008, 08:07 PM posted to microsoft.public.excel.worksheet.functions
Lars-Åke Aspelin[_2_]
external usenet poster
 
Posts: 722
Default If/Then Formulas

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
  #32  
Old August 13th, 2008, 08:19 PM posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom[_2_]
external usenet poster
 
Posts: 963
Default If/Then Formulas

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



  #33  
Old August 13th, 2008, 08:21 PM posted to microsoft.public.excel.worksheet.functions
John C[_2_]
external usenet poster
 
Posts: 1,350
Default If/Then Formulas

Your formula typed is good as gold, unfortunately, xl feels it must always
put a digit in front of the decimal, so your formula is actually:
=E7*INT(F7^0.7)

--
John C


"Lars-Ã…ke Aspelin" wrote:

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

  #34  
Old August 13th, 2008, 08:26 PM posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\)[_1118_]
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

  #35  
Old August 13th, 2008, 08:30 PM posted to microsoft.public.excel.worksheet.functions
Lars-Åke Aspelin[_2_]
external usenet poster
 
Posts: 722
Default If/Then Formulas

Oh, now I see what you mean

Lars-Åke

On Wed, 13 Aug 2008 12:21:13 -0700, John C johnc@stateofdenial
wrote:

Your formula typed is good as gold, unfortunately, xl feels it must always
put a digit in front of the decimal, so your formula is actually:
=E7*INT(F7^0.7)


  #36  
Old August 13th, 2008, 08:31 PM posted to microsoft.public.excel.worksheet.functions
John C[_2_]
external usenet poster
 
Posts: 1,350
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




  #37  
Old August 13th, 2008, 08:41 PM posted to microsoft.public.excel.worksheet.functions
John C[_2_]
external usenet poster
 
Posts: 1,350
Default If/Then Formulas

Nope, see other post. xl puts a 0 before the decimal, so it is ... F7^0.7 ...
--
John C


"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?


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


  #38  
Old August 13th, 2008, 09:11 PM posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom[_2_]
external usenet poster
 
Posts: 963
Default If/Then Formulas

That is because Excel has a bug/feature, if you enter the formula you enter
the same number of characters
so in my book they are the same size. I mean the only practical reason for
wanting a shorter formula must be
that you save time by entering less characters. Of course displayed using
default fonts your formula
actually takes up more cell space even if we include the padded zero g


--


Regards,


Peo Sjoblom

"John C" johnc@stateofdenial wrote in message
...
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






  #39  
Old August 13th, 2008, 09:27 PM posted to microsoft.public.excel.worksheet.functions
John C[_2_]
external usenet poster
 
Posts: 1,350
Default If/Then Formulas

Well, actually, the 'longer formula' causes the file size to be larger.
Admittedly just 1 character at a time, but it does actually take more memory
for the 'longer' formula.

I disagree with your assessment that the 0 before the decimal is a bug. It
is the value of 0 prior to the decimal, and this is a real and tangible value.


--
John C


"Peo Sjoblom" wrote:

That is because Excel has a bug/feature, if you enter the formula you enter
the same number of characters
so in my book they are the same size. I mean the only practical reason for
wanting a shorter formula must be
that you save time by entering less characters. Of course displayed using
default fonts your formula
actually takes up more cell space even if we include the padded zero g


--


Regards,


Peo Sjoblom

"John C" johnc@stateofdenial wrote in message
...
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






 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:43 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.