The most pointless combination of functions

[xyzabc198]

I think we can make an exception for a function’s only purpose being that it is the most pointless function!!<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

Quite ironic really that the most POINTLESS function is the whole POINT of this conversation!

 

[Greg Truby]

Greg, surely that's what you would expect given that Sum performs no coercive operations on the arguments passed to it?

At least for my train of thought, I'd say you've inverted the flow of the logic there, Richard. I do not expect this because I do not *know* that SUM performs no coersions because I don't have the actual code that's in SUM memorized (can't quite recall where I saw it once upon a time). Rather I would say that given this treatment of booleans one can reasonably conclude that SUM performs no coersions.

 

[arkusM]

At least for my train of thought, I'd say you've inverted the flow of the logic there, Richard. I do not expect this because I do not *know* that SUM performs no coersions because I don't have the actual code that's in SUM memorized (can't quite recall where I saw it once upon a time). Rather I would say that given this treatment of booleans one can reasonably conclude that SUM performs no coersions.

Check this link out from John site:
What is truth!
http://spreadsheetpage.com/index.php/oddity/what_is_truth/

It is interesting...

 

[Richard Schollar]

At least for my train of thought, I'd say you've inverted the flow of the logic there, Richard. I do not expect this because I do not *know* that SUM performs no coersions because I don't have the actual code that's in SUM memorized (can't quite recall where I saw it once upon a time). Rather I would say that given this treatment of booleans one can reasonably conclude that SUM performs no coersions.

You're quite right Greg - I was drawing one too many conclusions from incomplete data.

Of course, had your memory been up to speed (old man ) then you would have remembered all the minutiae of the SUM coding so I wouldn't have had to jump to any conclusions. So it's your fault really...