Calculate if....

Hello,

I'm looking for a way to create a fonction that would make a calculation based on criteria in 2 tables. Much like the sumifs ou countifs fonction except that I would like the function to calculate a different operation than a sum or count.

My data in in 2 different sheets this is why I am showing you 2 tables. The calculation I am looking for is in table 2 Column D

Table 1

ColA ColB

Client. Invoice ?

300100. YES

300200. NO

Table 2

Col A Col B Col C Col D

Client. AUM. FEE Invoice calculation

300100. 100000. 1% Result of formula : 250

300200. 150000. 0.5% Result of formula : NO INVOICE

Here is the details of what the formula should do :

line 1 : If table 1, A2=table 2, A2 and table 1, B2=YES then B2 * C2 / 4

line 2 : If table 1, A2=table 2, A2 and table 1, B2=NO then “NO INVOICE” (if text doesn't work then any character other than 0.

Could anyone help me with this ?

Thank you very much

Véronique