83
edits
Excel Data Quality Toolkit: Difference between revisions
→Minimum and Maximum Elevation Values Mismatched
Jegelewicz (talk | contribs) |
Jegelewicz (talk | contribs) |
||
| Line 114: | Line 114: | ||
'''Problem:''' The minimum elevation ([https://dwc.tdwg.org/terms/#dwc:minimumElevationInMeters minimumElevationInMeters]) has a greater value than the maximum elevation ([https://dwc.tdwg.org/terms/#dwc:maximumElevationInMeters maximumElevationInMeters]). | '''Problem:''' The minimum elevation ([https://dwc.tdwg.org/terms/#dwc:minimumElevationInMeters minimumElevationInMeters]) has a greater value than the maximum elevation ([https://dwc.tdwg.org/terms/#dwc:maximumElevationInMeters maximumElevationInMeters]). | ||
'''Solution:''' | '''Solution:''' Check that minimum elevation is below maximum elevation with this formula where A1 is the minimum elevation and B1 is the maximum elevation. | ||
=IF(A1>B1,"ERROR","OK") | |||
=== Mismatched Country and CountryCode Values === | === Mismatched Country and CountryCode Values === | ||