Using ReplaceValue to conditionally replace a cell with a numeric value based on another column's value

I've seen lots of suggestions for when one is populating cells with text, but what if the new value is a number?  In the example below, I filtered a table to a single row and requesting if the ticker...