Ok so heres what im saying:

Lets say I have a value in a cell "Price"

If I put a value of "If activecell = "Price" then"

This will be a valid statement and do what I tell it to afterwards. However,
lets say the value in the cell is " Price" or "$Price" how would I make a
statment saying something to the effect of "If activecell = similar to
"Price" then"