Difference between revisions of "MSexcel"
Jump to navigation
Jump to search
(Created page with "Some formula's to remember if you have to use Excel ;TEKST(A1,"00000") :Fill out the value of cell A1 with 0's on the left side. :TEKST(2,"0000") => 0002") |
|||
Line 4: | Line 4: | ||
:Fill out the value of cell A1 with 0's on the left side. | :Fill out the value of cell A1 with 0's on the left side. | ||
:TEKST(2,"0000") => 0002 | :TEKST(2,"0000") => 0002 | ||
+ | |||
+ | ;<nowiki>=IF(LEN(VLOOKUP(D2,A2:B10,2,0))=0,"",VLOOKUP(D2,A2:B10,2,0))</nowiki> | ||
+ | :VLOOKUP returns 0 values for empty cells by default. This looks better. |
Revision as of 10:19, 6 May 2020
Some formula's to remember if you have to use Excel
- TEKST(A1,"00000")
- Fill out the value of cell A1 with 0's on the left side.
- TEKST(2,"0000") => 0002
- =IF(LEN(VLOOKUP(D2,A2:B10,2,0))=0,"",VLOOKUP(D2,A2:B10,2,0))
- VLOOKUP returns 0 values for empty cells by default. This looks better.