The most pointless combination of functions

[Jonmo1]

Hi Rob

Did you try FINDing carkeys in the TRUNC?

That would cause a circular reference, - need the keys to open the trunc....

 

[xlHammer]

I'd tried the formula FIND(carkeys,TRUNC(A911)) but all I got was the error message
#GOHOME?

I realise what I've done wrong though, I haven't got a 911.

 

[riaz]

A home is not a home without a porch.

 

[erik.van.geit]

short and pointless
=N(""&A1)

EDIT: variation
=IF(N(""&A1),N(A1),0)

 

[Oorang]

Technically there is a difference between =IF(A1=B1,"TRUE","FALSE") and =A1=B1. The former returns a variant/string whereas the later returns a variant/boolean. It would be unusual for such a technicality to make a serious difference (or any really) but in principle it could. One example of how they could be treated differently is in excel 2003 the auto-formatting will automatically left align the string version but not the boolean.

 

[Lewiy]

Technically there is a difference between =IF(A1=B1,"TRUE","FALSE") and =A1=B1. The former returns a variant/string whereas the later returns a variant/boolean. It would be unusual for such a technicality to make a serious difference (or any really) but in principle it could. One example of how they could be treated differently is in excel 2003 the auto-formatting will automatically left align the string version but not the boolean.

Interesting that we appear to have gone round in a big circle here because to prove Oorang's point:

=ISLOGICAL(IF(A1=B1,"TRUE","FALSE"))

returns FALSE!!!

 

[Peter_SSs]

The most pointless combination of function?
There isn't one, and I think this thread is well on the way to demonstrating that. Sort of like below

Step1:
    Whenever you think you have the most pointless combination,
    somebody can think of another one that is either
    a) more pointless, or
    b) equally pointless.

If a Then
    You now have the second most poinless combination
ElseIf b Then
    You now only have an equal most pointless combination, not the most pointless
End If

GoTo Step1

 

[mikerickson]

If (Range("A1") < 2) = True then
    Range("A2")= "small"
End If
If (Range("A1") < 2) = False then
    Range("A2")= "Big"
End If

 

[Gerald Higgins]

My humble attempt, combining some of Lewiy's and Erik's ideas into something that looks complicated but does nothing.

=IF(A1=OFFSET(A1,N(""&A1),N(""&A1),ISLOGICAL(ISLOGICAL(A1)),
ISLOGICAL(ISLOGICAL(A1))),SUBSTITUTE(A1,A1,"",1),LEFT(A1,N(""&A1)))

 

[Jonmo1]

How about

=A1*0