Multiply with a condition

**nsv** · 06-12-2009, 08:32 AM

I found this formula in a spreadsheet:

=IF(MATCH(U51;R$50:R$10999;0)<950;1;0)*(D$21=1)

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.
Where can I find a general description of this tool?

NSV

**martindwilson** · 06-12-2009, 08:38 AM

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)

**nsv** · 06-12-2009, 09:01 AM

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