If/Then Formulas

[John C]

=E7*(F7=3)+E7*(OR(F7={1,2,3}))
--
John C

And of course, stealing from Ricks' formula:
=E7*(F7=3)+E7*(F7={1,2,3})

 

[Rick Rothstein \(MVP - VB\)]

A little shorter<g>....

=E7*MID("0112",F7+1,1)

Rick

 

[Rick Rothstein \(MVP - VB\)]

Nope, let's go back to Teethless mama's original form and modify it....

=((F7=3)+(F7<>""))*E7

There... one character shorter. <g>

Rick

 

[John C]

Again, assuming DV, even shorter

=E7*INT((F7+1)/2)

 

[Rick Rothstein \(MVP - VB\)]

=E7*INT(1+F7/3)

Again, assuming DV, even shorter

=E7*INT((F7+1)/2)

Very nice!

LOL... I almost had that formula originally (I just needed to think about it
a "short" time more<g>).

Rick

 

[John C]

Someone just tapped me on the shoulder, it was a veterinarian, he told me to
step take my club and step away from the horse, as he is well and truly dead.

 

[Lars-Åke Aspelin]

Very nice!

LOL... I almost had that formula originally (I just needed to think about it
a "short" time more<g>).

Rick

Here is an even shorter

=E7*INT(F7^.7)

Lars-Åke

 

[John C]

1 less character...
=EVEN(H7)/2*G7
--
John C

Here is an even shorter

=E7*INT(F7^.7)

Lars-Ã…ke

 

[Rick Rothstein \(MVP - VB\)]

Here is an even shorter

=E7*INT(F7^.7)

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

Rick

 

[Rick Rothstein \(MVP - VB\)]

Here is an even shorter

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

LOL... I stand corrected. Excellent!

Rick

 

[Lars-Åke Aspelin]

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

 

[Peo Sjoblom]

They certainly are
--


Regards,


Peo Sjoblom

=E7*INT(F7^.7)

=EVEN(F7)/2*E7

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

Lars-Åke

 

[John C]

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)

 

[Rick Rothstein \(MVP - VB\)]

Here is an even shorter

=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

 

[Lars-Åke Aspelin]

Oh, now I see what you mean

Lars-Åke

 

[John C]

See other post. No, they certainly aren't.

 

[John C]

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

 

[Peo Sjoblom]

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]

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.