Tammy R. asked

💻  Computer

In Google Sheets, I want to multiply a number in Column J by a certain number based on the dropdown item selected in Column K. Specifically, if 'Haven', 'Maintenance', or 'Onboarding' are selected in Column K, I want Column J to be multiplied by 35. If 'Trip Charge' is selected in Column K, I want Column J to be multiplied by 25. How can I achieve this?

January 17th, 2023

Carla A. answered

To achieve this in Google Sheets, you can use an IF and OR function combination. Here are the steps:...

January 17th, 2023

Sign Up to View Full Expert Answers

Create an account to view answers and interact with the community!