|You could add an OR() function to the formula like:|
In this we first test to see if B1 is Blank OR If B1 has the Text string N.A.
If True then we use C1
If False we use B1
Personally, I would simply do a Search & Replace and remove all of the N.A.
simply because you will inevitably find some user who will put N/A or NA or
some other combination.
Much simpler to just tell them to leave it blank.
message edited by mmcconaghy