I found this formula in a spreadsheet:
I can of course deduce that the if D21 does not equal 1 the result is 0; else the result is that of the IF(MATCH...) question, but this way of multiplying with (something=something else) is new to me.
Please Login or Register to view this content.
Where can I find a general description of this tool?
NSV
the question really is why /what is it being used for?
it looks just like another way of putting
=IF(and(MATCH(U51;R$50:R$10999;0)<950,D$21=1);1;0)
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thanks for the answer, but I should really like to know where to find the general description to see if there are other possibilities or possible limitations
NSV
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks