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!
Help Article Resources
Check out the Formula Handbook template!