The most pointless combination of functions

[Lewiy]

Is there anything more pointless than this:
=ISLOGICAL(ISLOGICAL(A1))

 

[Richard Schollar]

This is pretty pointless:

=ISNUMBER(1)

or

=SUM(A1)

But these suffer from brevity, whereas yours is truly an example of utter irrelevancy

 

[Legacy 96851]

My boss once gave me a sheet where he had used

=SUM(D4:D17)/COUNT(D4:D17)

quite a few times.

 

[Jonmo1]

My boss once gave me a sheet where he had used

=SUM(D4:D17)/COUNT(D4:D17)

quite a few times.

I wouldn't call that one pointless....
It does in fact serve a purpose, it gives you the average...

It's overcomplicated and could be done with a simpler formula, but it's not pointless...

 

[Legacy 96851]

I wouldn't call that one pointless....
It does in fact serve a purpose, it gives you the average...

It's overcomplicated and could be done with a simpler formula, but it's not pointless...

Its very existence is unnecessary, and for that, I would call it pointless. The topic, after all, is pointless combinations.

 

[Jonmo1]

I would say we need a clearer definition of the word "Pointless"

I (and I beleive Lewiy as well) was considering the definition : Does Nothing, Serves no purpose

You seem to include "can be done different/better/easier" in the definition...

By that definition I would say Vlookup is pointless.

 

[MrKowz]

=If(1=1,1,1)

Pointless

 

[DonkeyOte]

MrKowz, shouldn't that be:

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

 

[Jonmo1]

=and(a1=1,a1<>5)

 

[Legacy 96851]

I would say we need a clearer definition of the word "Pointless"

I (and I beleive Lewiy as well) was considering the definition : Does Nothing, Serves no purpose

You seem to include "can be done different/better/easier" in the definition...

By that definition I would say Vlookup is pointless.

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

If we're just doing functions that do nothing, how about:

=OR(NOT(NOT(TRUE)), NOT(NOT(NOT(FALSE))))