The most pointless combination of functions

[Jonmo1]

I was trying to be creative and think up something someone might actually use - something that goes out of its way without object.

Fair enough, wasn't trying to start an argument. We're cool...


I've actually seen this many times, both in work and on this forumn

=IF(condition,"TRUE","FALSE")

 

[Norie]

jonmo

That's not pointless, well it is I suppose.

But perhaps what is required is the text value, rather than TRUE/FALSE which are really only numeric as far as I'm aware.

 

[MrKowz]

MrKowz, shouldn't that be:

=IF(1=1,1*1,1/1)

=IF(abs(1)=sqrt(1),1^1,(1*1+1-1)/(sqrt(1)*abs(1)*1^1))

lets see how many times we can get 1 to appear in an if statement.

 

[Jonmo1]

But perhaps what is required is the text value, rather than TRUE/FALSE

But the logical TRUE/FALSE is still useable as a text string..
You can copy/paste it into notepad
=""&A1 results in a text string of "TRUE" where A1 is a logical resulting in TRUE.

The only place it doesn't work as a text string is in a lookup formula.
=LOOKUP("TRUE",A:B) doesn't work.
But all you have to do is drop the quotes and it does.

 

[Legacy 96851]

Fair enough, wasn't trying to start an argument. We're cool...

Ah please, we're always cool. This is, after all, the internet.

Who knew pointless combinations of functions could spark such heated debate?

 

[MrKowz]

=if(isblank(a1),"","")

 

[erik.van.geit]

make it
=if(isblank(a1),a1,"")

because it 'looks' more usefull

 

[Lewiy]

The thing that actually inspired me about
=ISLOGICAL(ISLOGICAL(A1))
Is that it only has one reference to a cell, there are no “user defined” results and it makes absolutely no difference what the value of A1 is, it can be a number, a text string, an error value….anything.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
So I guess, my definition of a pointless formula, would be one that serves no purpose regardless of the input value and that produces its own result rather than having a user define the result.

 

[xlHammer]

FIND(carkeys,now)

never seems to work.

of course TRUNC(A1) is certainly decimal pointless.

(sorry)

Rob

 

[riaz]

FIND(carkeys,now)

never seems to work.

of course TRUNC(A1) is certainly decimal pointless.

(sorry)

Rob

Hi Rob

Did you try FINDing carkeys in the TRUNC?