Excel Data Quality Toolkit: Difference between revisions
Jump to navigation
Jump to search
Jegelewicz (talk | contribs) |
Jegelewicz (talk | contribs) |
||
| Line 113: | Line 113: | ||
=IF(ISBLANK(C1),IF(ISBLANK(B1),IF(ISBLANK(A1),"no geography","OK"),IF(ISBLANK(A1),"missing country","OK")),IF(ISBLANK(B1),IF(ISBLANK(A1),"missing state and country","missing state"),IF(ISBLANK(A1),"no country","OK"))) | =IF(ISBLANK(C1),IF(ISBLANK(B1),IF(ISBLANK(A1),"no geography","OK"),IF(ISBLANK(A1),"missing country","OK")),IF(ISBLANK(B1),IF(ISBLANK(A1),"missing state and country","missing state"),IF(ISBLANK(A1),"no country","OK"))) | ||
country !! stateProvince !! county !! check | {|class="wikitable" | ||
|+ Sample Results | |||
|- | |||
| country !! stateProvince !! county !! check | |||
|- | |- | ||
| || Texas || Kerr|| no country | | || Texas || Kerr|| no country | ||