FORMULES EXCEL
EPM101B
2024 - 2025
,Inhoudstafel
Hst 01: Basis / Reeksen......................................................................................................................................3
Hst 02: Formules Functies..............................................................................................................................3
Hst 03: Celadres.................................................................................................................................................... 4
Hst 04: Als en of.................................................................................................................................................... 4
Hst 05: Datum en tijd.........................................................................................................................................5
Hst 06: Validatie (gegevensinvoer beperken tot…)........................................................................6
Hst 07: Celeigenschappen............................................................................................................................. 6
Hst 08: Afronden................................................................................................................................................... 7
Hst 09: Zoeken........................................................................................................................................................ 7
Hst 10: Zoeken advanced................................................................................................................................ 8
Hst 11: Functies II................................................................................................................................................... 8
Hst 12: Afdruk...........................................................................................................................................................9
Hst 13: Grafieken.................................................................................................................................................. 10
1
, Hst 01: Basis / Reeksen
som =som(...)
min =verschil(...)
maximum / grootste getal =max(...)
minimum / kleinste getal =min(...)
Hst 02: Formules Functies
aantal cellen met getallen =aantal (waarde)
aantal cellen (incl. die leeg zijn) =aantalarg (waarde)
Percentage 𝑎𝑎𝑛𝑡𝑎𝑙
= ≠ *100
𝑡𝑜𝑡𝑎𝑎𝑙
Excl. BTW → incl. BTW = prijs excl. BTW * (1 + BTW)
Incl. BTW → excl. BTW 𝑝𝑟𝑖𝑗𝑠 𝑖𝑛𝑐𝑙. 𝐵𝑇𝑊
=
(1 + 𝐵𝑇𝑊)
toename/afname (𝑛𝑖𝑒𝑢𝑤 − 𝑜𝑢𝑑)
=
𝑜𝑢𝑑
BTW bedrag = exl. BTW * BTW percentage
Percentage omzetting % 𝑑𝑖𝑒 𝑗𝑒 𝑤𝑖𝑙𝑡 𝑏𝑒𝑟𝑒𝑘𝑒𝑛𝑒𝑛
=
𝑏𝑒𝑠𝑙𝑖𝑠𝑡𝑒 % 𝑔𝑒𝑡𝑎𝑙
2
EPM101B
2024 - 2025
,Inhoudstafel
Hst 01: Basis / Reeksen......................................................................................................................................3
Hst 02: Formules Functies..............................................................................................................................3
Hst 03: Celadres.................................................................................................................................................... 4
Hst 04: Als en of.................................................................................................................................................... 4
Hst 05: Datum en tijd.........................................................................................................................................5
Hst 06: Validatie (gegevensinvoer beperken tot…)........................................................................6
Hst 07: Celeigenschappen............................................................................................................................. 6
Hst 08: Afronden................................................................................................................................................... 7
Hst 09: Zoeken........................................................................................................................................................ 7
Hst 10: Zoeken advanced................................................................................................................................ 8
Hst 11: Functies II................................................................................................................................................... 8
Hst 12: Afdruk...........................................................................................................................................................9
Hst 13: Grafieken.................................................................................................................................................. 10
1
, Hst 01: Basis / Reeksen
som =som(...)
min =verschil(...)
maximum / grootste getal =max(...)
minimum / kleinste getal =min(...)
Hst 02: Formules Functies
aantal cellen met getallen =aantal (waarde)
aantal cellen (incl. die leeg zijn) =aantalarg (waarde)
Percentage 𝑎𝑎𝑛𝑡𝑎𝑙
= ≠ *100
𝑡𝑜𝑡𝑎𝑎𝑙
Excl. BTW → incl. BTW = prijs excl. BTW * (1 + BTW)
Incl. BTW → excl. BTW 𝑝𝑟𝑖𝑗𝑠 𝑖𝑛𝑐𝑙. 𝐵𝑇𝑊
=
(1 + 𝐵𝑇𝑊)
toename/afname (𝑛𝑖𝑒𝑢𝑤 − 𝑜𝑢𝑑)
=
𝑜𝑢𝑑
BTW bedrag = exl. BTW * BTW percentage
Percentage omzetting % 𝑑𝑖𝑒 𝑗𝑒 𝑤𝑖𝑙𝑡 𝑏𝑒𝑟𝑒𝑘𝑒𝑛𝑒𝑛
=
𝑏𝑒𝑠𝑙𝑖𝑠𝑡𝑒 % 𝑔𝑒𝑡𝑎𝑙
2
