Created
May 3, 2018 21:32
-
-
Save discarn8/4312ed35e720ffa79f383b5ab421e69b to your computer and use it in GitHub Desktop.
EXCEL_FORMULA_Check_if_cell_contains_number
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Check if the cell has a dn in it and if not - add it | |
| =IF(C2=0,"",IF(ISNUMBER(SEARCH(C2,B2)),B2,B2&" "&C2) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment