IF cell contains specific letter then return value

mromaire
mromaire ✭✭✭✭
edited 06/22/23 in Formulas and Functions

I'd like to return a value of 120/208 in Service Volts for Xfmr# ending in E

value of 277/480 for Xfmr# ending in X

value of 120/240 for Xfmr# ending with no letter


Thanks

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!