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
|