Needing to return a value if 2 different cells have specific data

[splehpekim2010]

Link to sheet:
https://docs.google.com/spreadsheets/d/1nZs3it5lLQm8onE7KPP-RYfpnpeKivNQMtRvcrYqxmM/edit?usp=sharing

I am needing to finish the pay sheet for my sales staff. I am needing to return a certain value in column R if 2 different cells have specific data and needing to return a certain value in column S if 3 different cells have specific data.

Example 1:
IF Review = Yes AND Commission = 300 then over to the right I need the value of 25 to be returned otherwise return a value of 0
IF Review = Yes AND Commission = 400 then over to the right I need the value of 50 to be returned otherwise return a value of 0
IF Review = Yes AND Commission = 700 then over to the right I need the value of 100 to be returned otherwise return a value of 0

Example 2:
IF We Owe = No AND Hold Price = Yes AND Commission = 300 then over to the right I need the value of 25 to be returned otherwise return a value of 0
IF We Owe = No AND Hold Price = Yes AND Commission = 400 then over to the right I need the value of 50 to be returned otherwise return a value of 0
IF We Owe = No AND Hold Price = Yes AND Commission = 700 then over to the right I need the value of 200 to be returned otherwise return a value of 0

any and all help is GREATLY appreciated!

 

[Roderick_E]

Can modify this code:

=IF(AND(A3="yes",B3=300),25,IF(AND(A3="yes",B3=400),50,IF(AND(A3="yes",B3=700),100,0)))

 

[jtakw]

Hi,

What should happen if the Commission is in between, below, or above values (i.e. 250, 350, 410, 800, etc.)?
Or that would never happen?