MSexcel

From wiki

Revision as of 10:19, 6 May 2020 by Hdridder (talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to search

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.

Retrieved from "https://wiki.antiperfect.org/index.php?title=MSexcel&oldid=810"