Excel Data Quality Toolkit: Difference between revisions
Jump to navigation
Jump to search
Jegelewicz (talk | contribs) Tag: Manual revert |
Jegelewicz (talk | contribs) |
||
| Line 110: | Line 110: | ||
'''Solution:''' | '''Solution:''' | ||
=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"))) | |||
=== Minimum and Maximum Elevation Values Mismatched === | === Minimum and Maximum Elevation Values Mismatched === | ||