If statement with multiple conditions in Excel and then caluclate a formula

I have an IF statement that says if AG, AL, AJ all have Yes in the cell then I want it to go to a lookup table to retrieve a result. I then want it to take that result and perform a calculation but I don't know how to write it.

If one of the three cells has a no in it, then I just want it to return the value in cell AK

Here is an example:

IF(AG="Yes", AI="Yes", AJ="Yes"), VLOOKUP(Payout Table!A:B,201, 2,True), (O7*H17*AK) False=AK

This is my first time trying to do this so if you can recommend a link I can go to too better understand the correct formula that would be great.