|
I'm creating a template using Excel for data input into a database. The database doesn't allow blank cells in the upload, it requires an "NA" in the cell to represent null. I have included some calculation checks in the Excel template to ensure that users are transcribing the right data. To make it the most efficient and productive template I want to make all cells in the template default to "NA" (so analysts don't have to manually fill these in every time) but when I do that our calculation checks on the side don't work since they view it as a text string. So here's my question: Is there anyway I can assign the numerical value 0 to the text string "NA"? Or is there anyway I can designate the formulas on the side, that do the calculation checks, to disregard any cell that has the text string "NA"? I think either of those will enable me to do what I want. If you have any other ideas I'm open to them as well -- thanks!
|
# ¿ Apr 15, 2010 19:24 |
|
|
# ¿ May 6, 2024 00:25 |