W
willie Loh
i am trying to sum a number into single number?
eg 1347 --- >> 25
please help
eg 1347 --- >> 25
please help
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Biff
eg 1347 --- >> 25
Shouldn't that be 15?
Biff
Shouldn't that be 15?
Biff
B
Biff
eg 1347 --- >> 25
A1 = 1347
=SUMPRODUCT(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))
Returns 15
Biff
Shouldn't that be 15?
A1 = 1347
=SUMPRODUCT(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))
Returns 15
Biff
N
noyb
I have seen the use of "--" in a few responses here and in other groups
but fail to understand what the 2 '--'s do or why they are necessary. I
see that 1 - returns a negative, therefore 2 -'s return a positive, but
why does + or nothing, that is "(MID(....") return 0?
Can you explain?
Thanks
but fail to understand what the 2 '--'s do or why they are necessary. I
see that 1 - returns a negative, therefore 2 -'s return a positive, but
why does + or nothing, that is "(MID(....") return 0?
Can you explain?
Thanks
W
willie Loh
thks bro, it work.
noyb said:I have seen the use of "--" in a few responses here and in other groups
but fail to understand what the 2 '--'s do or why they are necessary. I
see that 1 - returns a negative, therefore 2 -'s return a positive, but
why does + or nothing, that is "(MID(....") return 0?
Can you explain?
Thanks
V
vezerid
The -- is used when we want to convert textual values to their numeric
equivalent. In the above example, MID returns text. If it happens that
the text represents a number, it can be used in numeric calculations if
it is converted to a number. The same happens for values returning true
or false: even though in an explicit calculation true=1 and false=0, if
these values are found in an array and you want, e.g. SUM(A1:A10), and
some of these cells contain true, it will be ignored instead of
counting as 1. If you want to sum all these values, including T/F, you
could use:
=SUM(--A1:A10)
but then you would have to array-enter it (Shift+Ctrl+Enter).
HTH
Kostis Vezerides
equivalent. In the above example, MID returns text. If it happens that
the text represents a number, it can be used in numeric calculations if
it is converted to a number. The same happens for values returning true
or false: even though in an explicit calculation true=1 and false=0, if
these values are found in an array and you want, e.g. SUM(A1:A10), and
some of these cells contain true, it will be ignored instead of
counting as 1. If you want to sum all these values, including T/F, you
could use:
=SUM(--A1:A10)
but then you would have to array-enter it (Shift+Ctrl+Enter).
HTH
Kostis Vezerides
N
noyb
Thanks