Hello all
I'm currently working on an excising excel document, which we use to keep track of client progress, i would like it to change so anytime someone inputs "na" into a cell to would convert it to a 4 within a certain range, so when we use it in several formulas it would calculate appropriately, does anyone know how i can do this?