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.![]()
=IF(MATCH(U51;R$50:R$10999;0)<950;1;0)*(D$21=1)
Where can I find a general description of this tool?
NSV
Bookmarks