Changing last character in a cell based on the character before it

If the second last letter is "I" then the "S" should be converted to "N". If the second last letter is "B" then the "S" should be converted to "Z". Thanks.