Formula for returning specific value depending on cell criteria


I'm trying to create a formula to populate a field with a fee amount based on the designated country group in another column. Essentially, I'm trying to say:

If country A, return $125.00

If country B, return $160.00

If country C, return $125.00

If country D, return $160.00

If Staff/Comp, return $0.00

What I came up with below is not working. Any advice? Thanks in advance!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!