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. |
|
|
Thread Tools | Display Modes |
#31
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|