15,030
edits
Excel replace na and 0 with empty: Difference between revisions
Jump to navigation
Jump to search
m
no edit summary
(+color) |
mNo edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 8: | Line 8: | ||
2. replace #N/A with <span style="color: #98bf21">empty</span> | 2. replace #N/A with <span style="color: #98bf21">empty</span> | ||
* =IFNA (value, <span style="color: #98bf21">value_if_na</span> ) | * =IFNA (value, <span style="color: #98bf21">value_if_na</span> ) | ||
* =IFNA( <span style="border-bottom-style: dotted;border-color: #999;">IF( VLOOKUP(A1,SHEET1!A:E,3,0) = 0, <nowiki>""</nowiki>, VLOOKUP(A1, SHEET1!A:E, 3, 0))</span>, <span style="color: #98bf21"><nowiki>""</nowiki></span>) | * =IFNA( <span style="border-bottom-style: dotted;border-color: #999;">IF( VLOOKUP(A1,SHEET1!A:E,3,0) = 0, <nowiki>""</nowiki>, VLOOKUP(A1, SHEET1!A:E, 3, 0))</span>, <span style="color: #98bf21"><nowiki>""</nowiki></span> ) | ||
| Line 17: | Line 17: | ||
[[Category:Spreadsheet]] [[Category:Excel]] | [[Category:Spreadsheet]] [[Category:Excel]] | ||
[[Category:Data transformation]] | |||
[[Category:Data_hygiene]] | [[Category:Data_hygiene]] | ||
[[Category:Data Science]] | [[Category:Data Science]] | ||