It looks like you're trying to use the AND function within your IF statement, but you're using the ampersand (&) instead of the correct syntax.
Here's the corrected formula:
Formula:
=IF(AND(H12="Tier 1", J12="Yes"), 150*B12, "None")
In this formula, we're using the
AND function to check if both
H12 equals "Tier 1" and
J12 equals "Yes". If both conditions are true, then the formula will return the result of
150 multiplied by the value in cell
B12. If either condition is false, then the formula will return "None".