Combine Multiple Functions (Nested Formulas)

Help me create a complex nested Excel formula to achieve the following logic: [Describe the desired outcome based on multiple conditions, e.g., 'If the value in cell A2 is 'High' AND B2 > 10, then return the value from C2 * 1.1; IF A2 is 'Medium' AND B2 > 5, return C2 * 1.05; Otherwise, return C2']. Suggest the appropriate combination of functions like IF, AND, OR, VLOOKUP, etc.