I need help with producing a formula in Excel where 2 out of 3 conditions met and then have it perform a calculation accordingly. Example below

If Cell =“certain text” and either “option1” or “option 2” then multiply the answer by 90%. If only one option met then multiply answer by 50%
Thank you.