15,030
edits
Excel replace na and 0 with empty: Difference between revisions
Jump to navigation
Jump to search
no edit summary
(Created page with "replace #N/A and 0 with empty when vlookup 1. replace 0 with empty <pre> =IF( logical_test, [value_if_true], [value_if_false] ) =IF( VLOOKUP(A1,SHEET1!A:E,3,0) = 0...") |
No edit summary |
||
| Line 15: | Line 15: | ||
[[Category:Spreadsheet]] | [[Category:Spreadsheet]] [[Category:Excel]] | ||
[[Category:Data_hygiene]] | [[Category:Data_hygiene]] | ||
[[Category:Data Science]] | [[Category:Data Science]] | ||