How to do an IF, AND and Multiply scenario with multiple options

Options

I am trying to do an IF, AND and Multiply scenario with multiple options. I still need to add the 3rd option, but wanted to figure out what I am doing wrong. I tested the first option, it worked. Adding the 2nd resulted in Unparsable.


Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!