IF statement with multiple conditions
I am currently working on an IF statement with multiple criteria and I'm having no luck. Basically, I would like the formula to articulate that if a specific manager is selected, then column 6 will multiply the data submitted in column 5 by a specific number, presenting me with its value.
If Column 1 is one of the below:
Then Column 6 should multiply by a specific value associated w/ each manager
Manager 1 value = 5
Manager 2 value = 6
Manager 3 value = 7
They're multiplying the number by the data in Column 5
Row 1 data = 2
Row 2 data = 3
Row 3 data = 4
Help Article Resources
Check out the Formula Handbook template!