LinkBack URL
About LinkBacks
Snap11.jpg
why both results are different ? SUMPRODUCT({FALSE;FALSE;TRUE},{1;2;3}) <> =SUMPRODUCT({0;0;1},{1;2;3})
i want to know why true , false cannot be converted to 1,0 automatically in sumproduct function ?
Snap11.jpg
why both results are different ? SUMPRODUCT({FALSE;FALSE;TRUE},{1;2;3}) <> =SUMPRODUCT({0;0;1},{1;2;3})
i want to know why true , false cannot be converted to 1,0 automatically in sumproduct function ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks