IF cell contains specific letter then return value

mromaire

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

Ray Lindstrom

Hi @mromaire,

Try this!

=IF(RIGHT([xfmr#]@row, 1) = "X", "277/480", IF(RIGHT([xfmr#]@row, 1) = "E", "120/208", "120/240"))

Hope that helps!

BRgds,

-Ray

Ray Lindstrom

Hi @mromaire,

Try this!

=IF(RIGHT([xfmr#]@row, 1) = "X", "277/480", IF(RIGHT([xfmr#]@row, 1) = "E", "120/208", "120/240"))

Hope that helps!

BRgds,

-Ray

mromaire

Thats it! Thanks Ray.

mromaire

I forgot to add how would I exclude cells that are blank?

Ray Lindstrom

Hi @mromaire,

So glad it worked for you. To exclude the blanks, use this:

=IF(ISBLANK([xfmr#]@row), "", IF(RIGHT([xfmr#]@row, 1) = "X", "277/480", IF(RIGHT([xfmr#]@row, 1) = "E", "120/208", "120/240")))

BRgds,

-Ray