joeu2004 explained :
"Bruno Campanini" wrote:
Try to switch on your brain before speaking

Look in the mirror when you say that.


"Bruno Campanini" wrote:
Are you joking? What is this formula:
=IF(SUM(I39)0, SUM((I39*I40)+I39),"")

It makes the very same things of my formula:
=IF(I390,I39*(1+I40),"")

And what if I39 contains the null string ("")? (Or any other text, for that
matter.)

If I39 contains Null string or any other text, I390 returns False or 0
in the very same way SUM(I39)0 does.
With the difference it is not ridicolous.
Why don't you try the things before commenting?

Rhetorical question. The point is: I agree that SUM((I39*I40)+I39) is
silly. However, SUM(I39)0 is one way of writing effectively
AND(I39<"",I390) or AND(ISNUMBER(I39),I390).

I prefer to use N(I39)0 instead of SUM(I39)0. But the N function help page
is difficult to find. So I can imagine few people know about it.

The real point is: try being polite, and stop calling people and things they
do "stupid". Such ad hominem attacks are unwarranted; and they have a
tendency to come back and bite you.

The real point for me is that I can't avoid to call "stupid" who writes
such stupid things like SUM(I39) or, worse, SUM((I39*I40)+I39)!
If you really need to avoid any ambiguity - but now it is not the case
- use the Unary Operator (--I39).

Bruno