i'm trying to run IF functions on cells containing text and i keep getting the "#VALUE!" error...what gives?
