{"id":907,"date":"2026-05-19T11:21:25","date_gmt":"2026-05-19T09:21:25","guid":{"rendered":"https:\/\/www.site-e-work.fr\/shop\/?p=907"},"modified":"2026-05-19T11:25:50","modified_gmt":"2026-05-19T09:25:50","slug":"cours-excel-fonctions-avancees","status":"publish","type":"post","link":"https:\/\/www.site-e-work.fr\/shop\/2026\/05\/19\/cours-excel-fonctions-avancees\/","title":{"rendered":"Cours Excel &#8211; Fonctions Avanc\u00e9es"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"907\" class=\"elementor elementor-907\">\n\t\t\t\t<div class=\"elementor-element elementor-element-940e97d e-flex e-con-boxed e-con e-parent\" data-id=\"940e97d\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8a24aa2 elementor-widget elementor-widget-html\" data-id=\"8a24aa2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t\t\r\n<style>\r\n@import url('https:\/\/fonts.googleapis.com\/css2?family=Syne:wght@400;500;600;700;800&family=Inter:wght@400;500&family=JetBrains+Mono:wght@400;500&display=swap');\r\n\r\n\/* \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\r\n   RESET SCOPED \u2014 tout limit\u00e9 \u00e0 #excrs-root\r\n\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550 *\/\r\n#excrs-root *,\r\n#excrs-root *::before,\r\n#excrs-root *::after {\r\n  box-sizing: border-box;\r\n  margin: 0;\r\n  padding: 0;\r\n  font-family: inherit;\r\n}\r\n\r\n#excrs-root {\r\n  --ex-bg:           #0A0C0E;\r\n  --ex-bg2:          #111416;\r\n  --ex-bg3:          #181C1F;\r\n  --ex-surface:      #1E2326;\r\n  --ex-surface2:     #252B2F;\r\n  --ex-text:         #EEE9E0;\r\n  --ex-mid:          #8A9099;\r\n  --ex-dim:          #505860;\r\n  --ex-accent:       #63AAE0;\r\n  --ex-accent-dim:   #63A0E01F;\r\n  --ex-accent-glow:  #63B4E040;\r\n  --ex-border:       #63A0E01F;\r\n  --ex-border2:      #63B4E040;\r\n  --ex-green:        #4ade80;\r\n  --ex-green-dim:    #4ade8020;\r\n  --ex-amber:        #f59e0b;\r\n  --ex-amber-dim:    #f59e0b20;\r\n  --ex-red:          #f87171;\r\n  --ex-red-dim:      #f8717120;\r\n  --ex-purple:       #c586c0;\r\n  --ex-purple-dim:   #c586c020;\r\n  --ex-excel:        #1D6F42;   \/* vert Excel *\/\r\n  --ex-excel-dim:    #1D6F4220;\r\n  --ex-excel-glow:   #1D6F4240;\r\n  --ex-ff-display:   'Syne', sans-serif;\r\n  --ex-ff-body:      'Inter', sans-serif;\r\n  --ex-ff-mono:      'JetBrains Mono', monospace;\r\n\r\n  font-family: var(--ex-ff-body);\r\n  background: var(--ex-bg);\r\n  color: var(--ex-text);\r\n  border-radius: 12px;\r\n  overflow: hidden;\r\n  width: 100%;\r\n  line-height: 1.5;\r\n  isolation: isolate;\r\n}\r\n\r\n\/* \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\r\n   TOPBAR\r\n\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550 *\/\r\n#excrs-root .excrs__topbar {\r\n  background: var(--ex-bg2);\r\n  border-bottom: 1px solid var(--ex-border2);\r\n  display: flex;\r\n  align-items: center;\r\n  padding: 0 1.5rem;\r\n  gap: 1rem;\r\n  height: 50px;\r\n  flex-shrink: 0;\r\n}\r\n#excrs-root .excrs__topbar-logo {\r\n  font-family: var(--ex-ff-display);\r\n  font-size: 15px;\r\n  font-weight: 700;\r\n  color: var(--ex-accent);\r\n  letter-spacing: .04em;\r\n}\r\n#excrs-root .excrs__topbar-sep {\r\n  width: 1px; height: 20px;\r\n  background: var(--ex-border2);\r\n  flex-shrink: 0;\r\n}\r\n#excrs-root .excrs__topbar-subtitle {\r\n  font-family: var(--ex-ff-display);\r\n  font-size: 13px;\r\n  font-weight: 500;\r\n  color: var(--ex-mid);\r\n}\r\n#excrs-root .excrs__topbar-right {\r\n  margin-left: auto;\r\n  display: flex;\r\n  align-items: center;\r\n  gap: .75rem;\r\n}\r\n#excrs-root .excrs__topbar-pill {\r\n  font-family: var(--ex-ff-display);\r\n  font-size: 10px;\r\n  font-weight: 700;\r\n  letter-spacing: .1em;\r\n  text-transform: uppercase;\r\n  padding: 3px 10px;\r\n  border-radius: 20px;\r\n  background: #1D6F4220;\r\n  color: #4ade80;\r\n  border: 1px solid #1D6F4240;\r\n}\r\n#excrs-root .excrs__topbar-counter {\r\n  font-size: 12px;\r\n  color: var(--ex-dim);\r\n  font-family: var(--ex-ff-display);\r\n}\r\n\r\n\/* \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\r\n   PROGRESS\r\n\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550 *\/\r\n#excrs-root .excrs__progress-track {\r\n  height: 3px;\r\n  background: var(--ex-surface);\r\n  flex-shrink: 0;\r\n}\r\n#excrs-root .excrs__progress-fill {\r\n  height: 3px;\r\n  background: linear-gradient(90deg, #4ade80, #63AAE0);\r\n  width: 11.11%;\r\n  transition: width .4s cubic-bezier(.4,0,.2,1);\r\n}\r\n\r\n\/* \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\r\n   LAYOUT\r\n\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550 *\/\r\n#excrs-root .excrs__body {\r\n  display: flex;\r\n  height: 630px;\r\n}\r\n\r\n\/* \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\r\n   SIDENAV\r\n\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550 *\/\r\n#excrs-root .excrs__sidenav {\r\n  width: 225px;\r\n  flex-shrink: 0;\r\n  background: var(--ex-bg2);\r\n  border-right: 1px solid var(--ex-border2);\r\n  overflow-y: auto;\r\n  padding: 1.5rem 0;\r\n  display: flex;\r\n  flex-direction: column;\r\n  gap: 2px;\r\n}\r\n#excrs-root .excrs__sidenav-label {\r\n  font-family: var(--ex-ff-display);\r\n  font-size: 9px;\r\n  font-weight: 700;\r\n  letter-spacing: .14em;\r\n  text-transform: uppercase;\r\n  color: var(--ex-dim);\r\n  padding: 0 1.25rem .75rem;\r\n  display: block;\r\n}\r\n#excrs-root .excrs__navitem {\r\n  display: flex;\r\n  align-items: center;\r\n  gap: .6rem;\r\n  padding: .6rem 1.25rem;\r\n  background: transparent;\r\n  border: none;\r\n  border-left: 2px solid transparent;\r\n  color: var(--ex-mid);\r\n  font-family: var(--ex-ff-body);\r\n  font-size: 12.5px;\r\n  text-align: left;\r\n  width: 100%;\r\n  cursor: pointer;\r\n  transition: all .15s ease;\r\n  appearance: none;\r\n  -webkit-appearance: none;\r\n  outline: none;\r\n  border-radius: 0;\r\n  line-height: 1.4;\r\n}\r\n#excrs-root .excrs__navitem:hover {\r\n  color: var(--ex-text);\r\n  background: var(--ex-surface);\r\n}\r\n#excrs-root .excrs__navitem.excrs--active {\r\n  color: var(--ex-green);\r\n  background: var(--ex-green-dim);\r\n  border-left-color: var(--ex-green);\r\n}\r\n#excrs-root .excrs__navitem-num {\r\n  font-family: var(--ex-ff-display);\r\n  font-size: 10px;\r\n  font-weight: 700;\r\n  color: var(--ex-dim);\r\n  min-width: 18px;\r\n  flex-shrink: 0;\r\n}\r\n#excrs-root .excrs__navitem.excrs--active .excrs__navitem-num {\r\n  color: var(--ex-green);\r\n}\r\n\r\n\/* \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\r\n   CONTENU\r\n\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550 *\/\r\n#excrs-root .excrs__content-area {\r\n  flex: 1;\r\n  overflow-y: auto;\r\n  padding: 2.5rem 3rem;\r\n  scroll-behavior: smooth;\r\n}\r\n\r\n\/* \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\r\n   CHAPITRE\r\n\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550 *\/\r\n#excrs-root .excrs__chapter { display: none; max-width: 760px; }\r\n#excrs-root .excrs__chapter.excrs--visible { display: block; }\r\n\r\n#excrs-root .excrs__ch-badge {\r\n  display: inline-flex;\r\n  align-items: center;\r\n  gap: .4rem;\r\n  font-family: var(--ex-ff-display);\r\n  font-size: 11px;\r\n  font-weight: 600;\r\n  letter-spacing: .06em;\r\n  padding: 4px 14px;\r\n  border-radius: 20px;\r\n  margin-bottom: 1.1rem;\r\n}\r\n#excrs-root .excrs__ch-title {\r\n  font-family: var(--ex-ff-display);\r\n  font-size: 26px;\r\n  font-weight: 800;\r\n  color: var(--ex-text);\r\n  margin-bottom: .5rem;\r\n  line-height: 1.2;\r\n  margin-top: 0;\r\n}\r\n#excrs-root .excrs__ch-intro {\r\n  font-size: 14px;\r\n  color: var(--ex-mid);\r\n  line-height: 1.7;\r\n  padding-bottom: 1.75rem;\r\n  border-bottom: 1px solid var(--ex-border2);\r\n  margin-bottom: 1.75rem;\r\n}\r\n\r\n\/* \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\r\n   TYPOGRAPHIE\r\n\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550 *\/\r\n#excrs-root .excrs__para {\r\n  font-size: 14px;\r\n  color: var(--ex-mid);\r\n  line-height: 1.8;\r\n  margin-bottom: 1rem;\r\n  font-weight: 400;\r\n}\r\n#excrs-root .excrs__para strong { color: var(--ex-text); font-weight: 500; }\r\n#excrs-root .excrs__para code,\r\n#excrs-root .excrs__ic {\r\n  font-family: var(--ex-ff-mono);\r\n  font-size: 12px;\r\n  color: var(--ex-green);\r\n  background: var(--ex-green-dim);\r\n  padding: 2px 6px;\r\n  border-radius: 4px;\r\n}\r\n#excrs-root .excrs__section-heading {\r\n  font-family: var(--ex-ff-display);\r\n  font-size: 11px;\r\n  font-weight: 700;\r\n  color: var(--ex-green);\r\n  text-transform: uppercase;\r\n  letter-spacing: .1em;\r\n  margin: 2rem 0 .85rem;\r\n  padding: 0;\r\n  border: none;\r\n  background: none;\r\n}\r\n\r\n\/* \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\r\n   FORMULE EXCEL \u2014 bloc signature\r\n\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550 *\/\r\n#excrs-root .excrs__formula-sig {\r\n  background: #0d1f15;\r\n  border: 1px solid #1D6F4260;\r\n  border-left: 3px solid var(--ex-green);\r\n  border-radius: 8px;\r\n  padding: 1rem 1.25rem;\r\n  margin: 1rem 0 1.5rem;\r\n  font-family: var(--ex-ff-mono);\r\n  font-size: 14px;\r\n  color: var(--ex-text);\r\n  line-height: 1.6;\r\n}\r\n#excrs-root .excrs__formula-sig .excrs__fn { color: #4ade80; font-weight: 600; }\r\n#excrs-root .excrs__formula-sig .excrs__arg { color: #9cdcfe; }\r\n#excrs-root .excrs__formula-sig .excrs__op { color: var(--ex-purple); }\r\n#excrs-root .excrs__formula-sig small {\r\n  display: block;\r\n  font-family: var(--ex-ff-body);\r\n  font-size: 11px;\r\n  color: var(--ex-dim);\r\n  margin-top: .5rem;\r\n  font-style: italic;\r\n}\r\n\r\n\/* \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\r\n   BLOC DE CODE \/ FORMULE\r\n\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550 *\/\r\n#excrs-root .excrs__codeblock {\r\n  background: var(--ex-bg3);\r\n  border: 1px solid var(--ex-border2);\r\n  border-radius: 10px;\r\n  margin: 1rem 0 1.5rem;\r\n  overflow: hidden;\r\n}\r\n#excrs-root .excrs__codeblock-header {\r\n  display: flex;\r\n  align-items: center;\r\n  justify-content: space-between;\r\n  padding: .6rem 1.1rem;\r\n  background: var(--ex-surface);\r\n  border-bottom: 1px solid var(--ex-border2);\r\n}\r\n#excrs-root .excrs__codeblock-left {\r\n  display: flex;\r\n  align-items: center;\r\n  gap: .75rem;\r\n}\r\n#excrs-root .excrs__win-dots { display: flex; gap: 5px; }\r\n#excrs-root .excrs__win-dots span { width: 10px; height: 10px; border-radius: 50%; display: block; }\r\n#excrs-root .excrs__dot-r { background: #ff5f57; }\r\n#excrs-root .excrs__dot-y { background: #ffbd2e; }\r\n#excrs-root .excrs__dot-g { background: #28c840; }\r\n#excrs-root .excrs__codeblock-lang {\r\n  font-family: var(--ex-ff-display);\r\n  font-size: 10px;\r\n  font-weight: 700;\r\n  color: var(--ex-dim);\r\n  text-transform: uppercase;\r\n  letter-spacing: .1em;\r\n}\r\n#excrs-root .excrs__copybtn {\r\n  display: flex;\r\n  align-items: center;\r\n  gap: .35rem;\r\n  font-family: var(--ex-ff-body);\r\n  font-size: 11px;\r\n  color: var(--ex-mid);\r\n  background: transparent;\r\n  border: 1px solid var(--ex-border2);\r\n  border-radius: 6px;\r\n  padding: 4px 10px;\r\n  cursor: pointer;\r\n  transition: all .15s;\r\n  appearance: none;\r\n  outline: none;\r\n  line-height: 1.4;\r\n  font-weight: 400;\r\n}\r\n#excrs-root .excrs__copybtn:hover {\r\n  color: var(--ex-green);\r\n  border-color: var(--ex-green-dim);\r\n  background: var(--ex-green-dim);\r\n}\r\n#excrs-root .excrs__copybtn.excrs--copied { color: var(--ex-green); border-color: var(--ex-green-dim); }\r\n\r\n#excrs-root .excrs__codeblock pre {\r\n  padding: 1.25rem 1.5rem;\r\n  font-family: var(--ex-ff-mono);\r\n  font-size: 13px;\r\n  line-height: 1.8;\r\n  color: var(--ex-text);\r\n  overflow-x: auto;\r\n  white-space: pre;\r\n  tab-size: 2;\r\n  background: transparent;\r\n  border: none;\r\n  border-radius: 0;\r\n  margin: 0;\r\n  word-wrap: normal;\r\n}\r\n\r\n\/* Coloration syntaxique Excel *\/\r\n#excrs-root .ex-fn  { color: #4ade80; font-weight: 600; }  \/* fonction *\/\r\n#excrs-root .ex-ref { color: #9cdcfe; }                    \/* r\u00e9f\u00e9rence cellule *\/\r\n#excrs-root .ex-str { color: #ce9178; }                    \/* cha\u00eene texte *\/\r\n#excrs-root .ex-num { color: #ffd700; }                    \/* nombre *\/\r\n#excrs-root .ex-op  { color: #c586c0; }                    \/* op\u00e9rateur *\/\r\n#excrs-root .ex-cmt { color: #6a9955; font-style: italic; }\/* commentaire *\/\r\n#excrs-root .ex-col { color: var(--ex-amber); }            \/* colonne\/plage *\/\r\n\r\n\/* \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\r\n   TABLEAU EXCEL SIMUL\u00c9\r\n\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550 *\/\r\n#excrs-root .excrs__xltable-wrap {\r\n  overflow-x: auto;\r\n  margin: 1rem 0 1.5rem;\r\n  border-radius: 8px;\r\n  border: 1px solid var(--ex-border2);\r\n}\r\n#excrs-root .excrs__xltable {\r\n  border-collapse: collapse;\r\n  font-size: 13px;\r\n  width: 100%;\r\n  min-width: 500px;\r\n}\r\n#excrs-root .excrs__xltable .excrs__xl-colheader {\r\n  background: #1D6F4230;\r\n  color: var(--ex-green);\r\n  font-family: var(--ex-ff-display);\r\n  font-size: 11px;\r\n  font-weight: 700;\r\n  padding: .45rem .85rem;\r\n  text-align: center;\r\n  border: 1px solid var(--ex-border2);\r\n  letter-spacing: .06em;\r\n}\r\n#excrs-root .excrs__xltable .excrs__xl-rownum {\r\n  background: var(--ex-surface);\r\n  color: var(--ex-dim);\r\n  font-family: var(--ex-ff-display);\r\n  font-size: 11px;\r\n  font-weight: 700;\r\n  padding: .45rem .65rem;\r\n  text-align: center;\r\n  border: 1px solid var(--ex-border2);\r\n  min-width: 36px;\r\n}\r\n#excrs-root .excrs__xltable td {\r\n  background: var(--ex-bg3);\r\n  color: var(--ex-mid);\r\n  padding: .45rem .85rem;\r\n  border: 1px solid var(--ex-border2);\r\n  white-space: nowrap;\r\n  border-top: none;\r\n  border-left: none;\r\n  border-right: none;\r\n}\r\n#excrs-root .excrs__xltable td.excrs__xl-header-row {\r\n  background: var(--ex-surface2);\r\n  color: var(--ex-text);\r\n  font-weight: 500;\r\n  font-family: var(--ex-ff-display);\r\n  font-size: 12px;\r\n}\r\n#excrs-root .excrs__xltable td.excrs__xl-formula {\r\n  color: var(--ex-green);\r\n  font-family: var(--ex-ff-mono);\r\n  font-size: 12px;\r\n}\r\n#excrs-root .excrs__xltable td.excrs__xl-result {\r\n  color: var(--ex-amber);\r\n  font-family: var(--ex-ff-mono);\r\n  font-size: 12px;\r\n  font-weight: 600;\r\n}\r\n#excrs-root .excrs__xltable td.excrs__xl-true  { color: var(--ex-green); font-weight: 600; font-family: var(--ex-ff-mono); font-size: 12px; }\r\n#excrs-root .excrs__xltable td.excrs__xl-false { color: var(--ex-red); font-weight: 600; font-family: var(--ex-ff-mono); font-size: 12px; }\r\n#excrs-root .excrs__xltable td.excrs__xl-num   { color: var(--ex-accent); font-family: var(--ex-ff-mono); font-size: 12px; }\r\n#excrs-root .excrs__xltable td.excrs__xl-highlight { background: #1D6F4215; }\r\n\r\n\/* \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\r\n   BO\u00ceTES CONTEXTUELLES\r\n\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550 *\/\r\n#excrs-root .excrs__infobox {\r\n  border-radius: 10px;\r\n  padding: 1rem 1.25rem;\r\n  margin: 1.1rem 0;\r\n  display: flex;\r\n  gap: .85rem;\r\n  align-items: flex-start;\r\n}\r\n#excrs-root .excrs__infobox-icon { font-size: 18px; margin-top: 1px; flex-shrink: 0; line-height: 1; }\r\n#excrs-root .excrs__infobox-body { font-size: 13.5px; color: var(--ex-mid); line-height: 1.7; margin: 0; }\r\n#excrs-root .excrs__infobox-body strong { font-weight: 500; }\r\n#excrs-root .excrs__infobox-body code {\r\n  font-family: var(--ex-ff-mono);\r\n  font-size: 12px;\r\n  padding: 1px 5px;\r\n  border-radius: 4px;\r\n}\r\n#excrs-root .excrs__infobox.excrs--info { background: var(--ex-accent-dim); border: 1px solid var(--ex-accent-glow); }\r\n#excrs-root .excrs__infobox.excrs--info .excrs__infobox-icon,\r\n#excrs-root .excrs__infobox.excrs--info strong { color: var(--ex-accent); }\r\n#excrs-root .excrs__infobox.excrs--info code { background: var(--ex-accent-glow); color: var(--ex-accent); }\r\n\r\n#excrs-root .excrs__infobox.excrs--warn { background: var(--ex-amber-dim); border: 1px solid #f59e0b40; }\r\n#excrs-root .excrs__infobox.excrs--warn .excrs__infobox-icon,\r\n#excrs-root .excrs__infobox.excrs--warn strong { color: var(--ex-amber); }\r\n#excrs-root .excrs__infobox.excrs--warn code { background: #f59e0b15; color: var(--ex-amber); }\r\n\r\n#excrs-root .excrs__infobox.excrs--ok { background: var(--ex-green-dim); border: 1px solid #4ade8040; }\r\n#excrs-root .excrs__infobox.excrs--ok .excrs__infobox-icon,\r\n#excrs-root .excrs__infobox.excrs--ok strong { color: var(--ex-green); }\r\n#excrs-root .excrs__infobox.excrs--ok code { background: #4ade8015; color: var(--ex-green); }\r\n\r\n#excrs-root .excrs__infobox.excrs--danger { background: var(--ex-red-dim); border: 1px solid #f8717140; }\r\n#excrs-root .excrs__infobox.excrs--danger .excrs__infobox-icon,\r\n#excrs-root .excrs__infobox.excrs--danger strong { color: var(--ex-red); }\r\n\r\n#excrs-root .excrs__infobox.excrs--excel { background: #1D6F4215; border: 1px solid #1D6F4250; }\r\n#excrs-root .excrs__infobox.excrs--excel .excrs__infobox-icon,\r\n#excrs-root .excrs__infobox.excrs--excel strong { color: var(--ex-green); }\r\n#excrs-root .excrs__infobox.excrs--excel code { background: #1D6F4225; color: var(--ex-green); }\r\n\r\n\/* \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\r\n   TABLEAU DE R\u00c9F\u00c9RENCE\r\n\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550 *\/\r\n#excrs-root .excrs__reftable {\r\n  width: 100%;\r\n  border-collapse: collapse;\r\n  font-size: 13px;\r\n  margin: 1rem 0 1.5rem;\r\n  border-spacing: 0;\r\n}\r\n#excrs-root .excrs__reftable thead tr { background: transparent; }\r\n#excrs-root .excrs__reftable th {\r\n  background: var(--ex-surface);\r\n  color: var(--ex-green);\r\n  font-family: var(--ex-ff-display);\r\n  font-size: 10px;\r\n  font-weight: 700;\r\n  letter-spacing: .08em;\r\n  text-transform: uppercase;\r\n  padding: .7rem 1rem;\r\n  text-align: left;\r\n  border-bottom: 1px solid var(--ex-border2);\r\n  border-top: none; border-left: none; border-right: none;\r\n}\r\n#excrs-root .excrs__reftable td {\r\n  padding: .7rem 1rem;\r\n  border-bottom: 1px solid var(--ex-border);\r\n  color: var(--ex-mid);\r\n  vertical-align: top;\r\n  line-height: 1.6;\r\n  border-top: none; border-left: none; border-right: none;\r\n  background: transparent;\r\n}\r\n#excrs-root .excrs__reftable td:first-child {\r\n  color: var(--ex-green);\r\n  font-family: var(--ex-ff-mono);\r\n  font-size: 12px;\r\n  white-space: nowrap;\r\n}\r\n#excrs-root .excrs__reftable td strong { color: var(--ex-text); font-weight: 500; }\r\n#excrs-root .excrs__reftable tr:last-child td { border-bottom: none; }\r\n\r\n\/* \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\r\n   GRILLE DE CARTES\r\n\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550 *\/\r\n#excrs-root .excrs__cardgrid {\r\n  display: grid;\r\n  grid-template-columns: 1fr 1fr;\r\n  gap: .65rem;\r\n  margin: 1rem 0 1.5rem;\r\n}\r\n#excrs-root .excrs__cardgrid.excrs--three { grid-template-columns: 1fr 1fr 1fr; }\r\n#excrs-root .excrs__card {\r\n  background: var(--ex-surface);\r\n  border: 1px solid var(--ex-border2);\r\n  border-radius: 8px;\r\n  padding: .9rem 1rem;\r\n}\r\n#excrs-root .excrs__card-tag {\r\n  font-family: var(--ex-ff-mono);\r\n  font-size: 12.5px;\r\n  color: var(--ex-green);\r\n  font-weight: 600;\r\n  display: block;\r\n  margin-bottom: .35rem;\r\n}\r\n#excrs-root .excrs__card-desc {\r\n  font-size: 12px;\r\n  color: var(--ex-mid);\r\n  line-height: 1.55;\r\n  display: block;\r\n}\r\n\r\n\/* \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\r\n   COMPARE GRID\r\n\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550 *\/\r\n#excrs-root .excrs__compare-grid {\r\n  display: grid;\r\n  grid-template-columns: 1fr 1fr;\r\n  gap: 1rem;\r\n  margin: 1rem 0 1.5rem;\r\n}\r\n#excrs-root .excrs__compare-panel { border-radius: 10px; padding: 1.1rem; overflow: hidden; }\r\n#excrs-root .excrs__compare-panel.excrs--bad  { background: #200a0a; border: 1px solid var(--ex-red); }\r\n#excrs-root .excrs__compare-panel.excrs--good { background: #0d2218; border: 1px solid var(--ex-green); }\r\n#excrs-root .excrs__compare-label {\r\n  font-family: var(--ex-ff-display);\r\n  font-size: 10px; font-weight: 700;\r\n  letter-spacing: .1em; text-transform: uppercase;\r\n  margin-bottom: .85rem; display: block;\r\n}\r\n#excrs-root .excrs__compare-panel.excrs--bad  .excrs__compare-label { color: var(--ex-red); }\r\n#excrs-root .excrs__compare-panel.excrs--good .excrs__compare-label { color: var(--ex-green); }\r\n#excrs-root .excrs__compare-panel pre {\r\n  font-family: var(--ex-ff-mono);\r\n  font-size: 12px; line-height: 1.7;\r\n  color: var(--ex-mid); white-space: pre; overflow-x: auto;\r\n  background: transparent; border: none; border-radius: 0; margin: 0; padding: 0;\r\n}\r\n\r\n\/* \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\r\n   QUIZ INTERACTIF\r\n\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550 *\/\r\n#excrs-root .excrs__quiz {\r\n  background: var(--ex-bg3);\r\n  border: 1px solid var(--ex-border2);\r\n  border-radius: 10px;\r\n  padding: 1.25rem;\r\n  margin: 1rem 0 1.5rem;\r\n}\r\n#excrs-root .excrs__quiz-q {\r\n  font-family: var(--ex-ff-display);\r\n  font-size: 13px;\r\n  font-weight: 600;\r\n  color: var(--ex-text);\r\n  margin-bottom: .85rem;\r\n}\r\n#excrs-root .excrs__quiz-opts { display: flex; flex-direction: column; gap: .5rem; }\r\n#excrs-root .excrs__quiz-opt {\r\n  display: flex;\r\n  align-items: center;\r\n  gap: .6rem;\r\n  background: var(--ex-surface);\r\n  border: 1px solid var(--ex-border2);\r\n  border-radius: 7px;\r\n  padding: .6rem 1rem;\r\n  cursor: pointer;\r\n  color: var(--ex-mid);\r\n  font-size: 13px;\r\n  font-family: var(--ex-ff-mono);\r\n  transition: all .15s;\r\n  text-align: left;\r\n  width: 100%;\r\n  appearance: none; outline: none;\r\n}\r\n#excrs-root .excrs__quiz-opt:hover { color: var(--ex-text); border-color: var(--ex-accent-glow); }\r\n#excrs-root .excrs__quiz-opt.excrs--correct { background: var(--ex-green-dim); border-color: var(--ex-green); color: var(--ex-green); }\r\n#excrs-root .excrs__quiz-opt.excrs--wrong { background: var(--ex-red-dim); border-color: var(--ex-red); color: var(--ex-red); }\r\n#excrs-root .excrs__quiz-feedback {\r\n  margin-top: .75rem;\r\n  font-size: 13px;\r\n  color: var(--ex-mid);\r\n  display: none;\r\n  line-height: 1.6;\r\n}\r\n#excrs-root .excrs__quiz-feedback.excrs--show { display: block; }\r\n\r\n\/* \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\r\n   FOOTNAV\r\n\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550 *\/\r\n#excrs-root .excrs__footnav {\r\n  display: flex;\r\n  justify-content: space-between;\r\n  align-items: center;\r\n  margin-top: 3rem;\r\n  padding-top: 1.5rem;\r\n  border-top: 1px solid var(--ex-border2);\r\n}\r\n#excrs-root .excrs__footbtn {\r\n  display: flex;\r\n  align-items: center;\r\n  gap: .45rem;\r\n  background: var(--ex-surface);\r\n  border: 1px solid var(--ex-border2);\r\n  border-radius: 8px;\r\n  padding: .6rem 1.2rem;\r\n  color: var(--ex-mid);\r\n  font-family: var(--ex-ff-body);\r\n  font-size: 13px;\r\n  cursor: pointer;\r\n  transition: all .15s;\r\n  appearance: none; outline: none;\r\n  font-weight: 400; line-height: 1.4;\r\n}\r\n#excrs-root .excrs__footbtn:hover:not(:disabled) {\r\n  background: var(--ex-green-dim);\r\n  border-color: #4ade8040;\r\n  color: var(--ex-green);\r\n}\r\n#excrs-root .excrs__footbtn:disabled { opacity: .25; cursor: not-allowed; }\r\n#excrs-root .excrs__footcount {\r\n  font-family: var(--ex-ff-display);\r\n  font-size: 11px;\r\n  color: var(--ex-dim);\r\n}\r\n\r\n\/* \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\r\n   SCROLLBAR\r\n\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550 *\/\r\n#excrs-root .excrs__content-area::-webkit-scrollbar,\r\n#excrs-root .excrs__sidenav::-webkit-scrollbar { width: 5px; }\r\n#excrs-root .excrs__content-area::-webkit-scrollbar-track,\r\n#excrs-root .excrs__sidenav::-webkit-scrollbar-track { background: transparent; }\r\n#excrs-root .excrs__content-area::-webkit-scrollbar-thumb,\r\n#excrs-root .excrs__sidenav::-webkit-scrollbar-thumb { background: var(--ex-surface2); border-radius: 3px; }\r\n\r\n\/* \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\r\n   RESPONSIVE MOBILE\r\n\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550 *\/\r\n@media (max-width: 680px) {\r\n  #excrs-root .excrs__body { flex-direction: column; height: auto; }\r\n  #excrs-root .excrs__sidenav { width: 100%; height: auto; flex-direction: row; flex-wrap: wrap; padding: .5rem; border-right: none; border-bottom: 1px solid var(--ex-border2); gap: 4px; }\r\n  #excrs-root .excrs__sidenav-label { display: none; }\r\n  #excrs-root .excrs__navitem { width: auto; border-left: none; border-bottom: 2px solid transparent; padding: .45rem .75rem; font-size: 11px; border-radius: 6px; }\r\n  #excrs-root .excrs__navitem.excrs--active { border-bottom-color: var(--ex-green); border-left: none; }\r\n  #excrs-root .excrs__content-area { padding: 1.5rem 1.25rem; height: auto; max-height: none; }\r\n  #excrs-root .excrs__ch-title { font-size: 20px; }\r\n  #excrs-root .excrs__compare-grid,\r\n  #excrs-root .excrs__cardgrid { grid-template-columns: 1fr; }\r\n  #excrs-root .excrs__cardgrid.excrs--three { grid-template-columns: 1fr; }\r\n  #excrs-root .excrs__topbar-subtitle { display: none; }\r\n  #excrs-root .excrs__topbar-sep { display: none; }\r\n}\r\n<\/style>\r\n\r\n<!-- \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\r\n     HTML DU COURS\r\n\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550 -->\r\n<div id=\"excrs-root\" role=\"main\" aria-label=\"Cours interactif Excel \u2014 Fonctions avanc\u00e9es\">\r\n\r\n  <!-- TOPBAR -->\r\n  <header class=\"excrs__topbar\">\r\n    <span class=\"excrs__topbar-logo\">\u25c8 BTS CDUI \/ SIO<\/span>\r\n    <span class=\"excrs__topbar-sep\"><\/span>\r\n    <span class=\"excrs__topbar-subtitle\">Excel \u2014 Fonctions avanc\u00e9es<\/span>\r\n    <div class=\"excrs__topbar-right\">\r\n      <span class=\"excrs__topbar-pill\">\ud83d\udcca Niveau interm\u00e9diaire<\/span>\r\n      <span class=\"excrs__topbar-counter\" id=\"excrs-counter\">Chapitre 1 \/ 9<\/span>\r\n    <\/div>\r\n  <\/header>\r\n\r\n  <!-- PROGRESS -->\r\n  <div class=\"excrs__progress-track\" role=\"progressbar\" aria-valuenow=\"1\" aria-valuemin=\"1\" aria-valuemax=\"9\">\r\n    <div class=\"excrs__progress-fill\" id=\"excrs-prog\"><\/div>\r\n  <\/div>\r\n\r\n  <div class=\"excrs__body\">\r\n\r\n    <!-- SIDENAV -->\r\n    <nav class=\"excrs__sidenav\" aria-label=\"Chapitres du cours Excel\">\r\n      <span class=\"excrs__sidenav-label\">Chapitres<\/span>\r\n      <button class=\"excrs__navitem excrs--active\" onclick=\"excrsShow(0)\" aria-current=\"true\">\r\n        <span class=\"excrs__navitem-num\">01<\/span>Rappels essentiels\r\n      <\/button>\r\n      <button class=\"excrs__navitem\" onclick=\"excrsShow(1)\">\r\n        <span class=\"excrs__navitem-num\">02<\/span>Fonction SI\r\n      <\/button>\r\n      <button class=\"excrs__navitem\" onclick=\"excrsShow(2)\">\r\n        <span class=\"excrs__navitem-num\">03<\/span>ET \/ OU\r\n      <\/button>\r\n      <button class=\"excrs__navitem\" onclick=\"excrsShow(3)\">\r\n        <span class=\"excrs__navitem-num\">04<\/span>SI imbriqu\u00e9s\r\n      <\/button>\r\n      <button class=\"excrs__navitem\" onclick=\"excrsShow(4)\">\r\n        <span class=\"excrs__navitem-num\">05<\/span>MAX \/ MIN\r\n      <\/button>\r\n      <button class=\"excrs__navitem\" onclick=\"excrsShow(5)\">\r\n        <span class=\"excrs__navitem-num\">06<\/span>NB.SI \/ SOMME.SI\r\n      <\/button>\r\n      <button class=\"excrs__navitem\" onclick=\"excrsShow(6)\">\r\n        <span class=\"excrs__navitem-num\">07<\/span>RECHERCHEV\r\n      <\/button>\r\n      <button class=\"excrs__navitem\" onclick=\"excrsShow(7)\">\r\n        <span class=\"excrs__navitem-num\">08<\/span>Fonctions Texte\r\n      <\/button>\r\n      <button class=\"excrs__navitem\" onclick=\"excrsShow(8)\">\r\n        <span class=\"excrs__navitem-num\">09<\/span>Fonctions Date\r\n      <\/button>\r\n    <\/nav>\r\n\r\n    <!-- CONTENU -->\r\n    <div class=\"excrs__content-area\" id=\"excrs-scroll\">\r\n\r\n      <!-- \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\r\n           CH 1 \u2014 RAPPELS\r\n      \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550 -->\r\n      <article class=\"excrs__chapter excrs--visible\" id=\"excrs-ch0\">\r\n        <span class=\"excrs__ch-badge\" style=\"background:#1D6F4220;color:#4ade80;border:1px solid #1D6F4250\">\ud83d\udcca Rappels<\/span>\r\n        <h2 class=\"excrs__ch-title\">Rappels essentiels avant de commencer<\/h2>\r\n        <p class=\"excrs__ch-intro\">Avant d'aborder les fonctions avanc\u00e9es, voici les bases indispensables sur lesquelles tout repose : la syntaxe des formules, les r\u00e9f\u00e9rences de cellules et les types de donn\u00e9es.<\/p>\r\n\r\n        <p class=\"excrs__section-heading\">Anatomie d'une formule Excel<\/p>\r\n        <p class=\"excrs__para\">Toute formule commence par le signe <strong>=<\/strong>. Sans lui, Excel traite la saisie comme du texte. Une formule combine des <strong>fonctions<\/strong>, des <strong>r\u00e9f\u00e9rences de cellules<\/strong>, des <strong>op\u00e9rateurs<\/strong> et des <strong>valeurs<\/strong>.<\/p>\r\n\r\n        <div class=\"excrs__codeblock\">\r\n          <div class=\"excrs__codeblock-header\">\r\n            <div class=\"excrs__codeblock-left\">\r\n              <div class=\"excrs__win-dots\"><span class=\"excrs__dot-r\"><\/span><span class=\"excrs__dot-y\"><\/span><span class=\"excrs__dot-g\"><\/span><\/div>\r\n              <span class=\"excrs__codeblock-lang\">Formules Excel \u2014 syntaxe de base<\/span>\r\n            <\/div>\r\n            <button class=\"excrs__copybtn\" onclick=\"excrsCopy(this)\">\ud83d\udccb Copier<\/button>\r\n          <\/div>\r\n          <pre><span class=\"ex-cmt\">= Signe obligatoire + Fonction ( Arguments s\u00e9par\u00e9s par ; )<\/span>\r\n\r\n<span class=\"ex-fn\">SOMME<\/span>(<span class=\"ex-ref\">A1<\/span><span class=\"ex-op\">:<\/span><span class=\"ex-ref\">A10<\/span>)          <span class=\"ex-cmt\">\u2192 additionne les cellules A1 \u00e0 A10<\/span>\r\n<span class=\"ex-fn\">MOYENNE<\/span>(<span class=\"ex-ref\">B2<\/span><span class=\"ex-op\">:<\/span><span class=\"ex-ref\">B50<\/span>)        <span class=\"ex-cmt\">\u2192 moyenne de la plage B2:B50<\/span>\r\n<span class=\"ex-fn\">NB<\/span>(<span class=\"ex-ref\">C1<\/span><span class=\"ex-op\">:<\/span><span class=\"ex-ref\">C100<\/span>)            <span class=\"ex-cmt\">\u2192 nombre de cellules avec valeur num\u00e9rique<\/span>\r\n<span class=\"ex-fn\">NBVAL<\/span>(<span class=\"ex-ref\">D1<\/span><span class=\"ex-op\">:<\/span><span class=\"ex-ref\">D50<\/span>)          <span class=\"ex-cmt\">\u2192 nombre de cellules non vides<\/span>\r\n\r\n<span class=\"ex-cmt\">Op\u00e9rateurs arithm\u00e9tiques :<\/span>\r\n<span class=\"ex-ref\">A1<\/span> <span class=\"ex-op\">+<\/span> <span class=\"ex-ref\">B1<\/span>    <span class=\"ex-cmt\">addition<\/span>\r\n<span class=\"ex-ref\">A1<\/span> <span class=\"ex-op\">-<\/span> <span class=\"ex-ref\">B1<\/span>    <span class=\"ex-cmt\">soustraction<\/span>\r\n<span class=\"ex-ref\">A1<\/span> <span class=\"ex-op\">*<\/span> <span class=\"ex-ref\">B1<\/span>    <span class=\"ex-cmt\">multiplication<\/span>\r\n<span class=\"ex-ref\">A1<\/span> <span class=\"ex-op\">\/<\/span> <span class=\"ex-ref\">B1<\/span>    <span class=\"ex-cmt\">division<\/span>\r\n<span class=\"ex-ref\">A1<\/span> <span class=\"ex-op\">^<\/span> <span class=\"ex-num\">2<\/span>    <span class=\"ex-cmt\">puissance (A1 au carr\u00e9)<\/span>\r\n<span class=\"ex-ref\">A1<\/span> <span class=\"ex-op\">&amp;<\/span> <span class=\"ex-str\">\" ans\"<\/span>  <span class=\"ex-cmt\">concat\u00e9nation de texte<\/span><\/pre>\r\n        <\/div>\r\n\r\n        <p class=\"excrs__section-heading\">R\u00e9f\u00e9rences relatives vs absolues<\/p>\r\n        <p class=\"excrs__para\">C'est le concept le plus important pour copier des formules correctement. Une r\u00e9f\u00e9rence <strong>relative<\/strong> s'adapte quand tu la copies, une r\u00e9f\u00e9rence <strong>absolue<\/strong> reste fixe.<\/p>\r\n\r\n        <div class=\"excrs__codeblock\">\r\n          <div class=\"excrs__codeblock-header\">\r\n            <div class=\"excrs__codeblock-left\">\r\n              <div class=\"excrs__win-dots\"><span class=\"excrs__dot-r\"><\/span><span class=\"excrs__dot-y\"><\/span><span class=\"excrs__dot-g\"><\/span><\/div>\r\n              <span class=\"excrs__codeblock-lang\">R\u00e9f\u00e9rences Excel<\/span>\r\n            <\/div>\r\n            <button class=\"excrs__copybtn\" onclick=\"excrsCopy(this)\">\ud83d\udccb Copier<\/button>\r\n          <\/div>\r\n          <pre><span class=\"ex-ref\">A1<\/span>          <span class=\"ex-cmt\">Relative \u2014 ligne ET colonne s'adaptent \u00e0 la copie<\/span>\r\n<span class=\"ex-op\">$<\/span><span class=\"ex-ref\">A<\/span><span class=\"ex-op\">$<\/span><span class=\"ex-num\">1<\/span>       <span class=\"ex-cmt\">Absolue  \u2014 rien ne bouge (touche F4)<\/span>\r\n<span class=\"ex-op\">$<\/span><span class=\"ex-ref\">A<\/span><span class=\"ex-num\">1<\/span>        <span class=\"ex-cmt\">Mixte    \u2014 colonne A fixe, ligne s'adapte<\/span>\r\n<span class=\"ex-ref\">A<\/span><span class=\"ex-op\">$<\/span><span class=\"ex-num\">1<\/span>        <span class=\"ex-cmt\">Mixte    \u2014 ligne 1 fixe, colonne s'adapte<\/span>\r\n\r\n<span class=\"ex-cmt\">Exemple : calcul d'une TVA \u00e0 partir d'un taux fixe en B1<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-ref\">A2<\/span> <span class=\"ex-op\">*<\/span> <span class=\"ex-op\">$<\/span><span class=\"ex-ref\">B<\/span><span class=\"ex-op\">$<\/span><span class=\"ex-num\">1<\/span>   <span class=\"ex-cmt\">\u2190 $B$1 reste fixe m\u00eame en copiant vers le bas<\/span><\/pre>\r\n        <\/div>\r\n\r\n        <div class=\"excrs__cardgrid excrs--three\">\r\n          <div class=\"excrs__card\">\r\n            <span class=\"excrs__card-tag\">Texte<\/span>\r\n            <span class=\"excrs__card-desc\">\"Bonjour\" \u2014 entre guillemets. Toujours guillemets droits, jamais typographiques.<\/span>\r\n          <\/div>\r\n          <div class=\"excrs__card\">\r\n            <span class=\"excrs__card-tag\">Nombre<\/span>\r\n            <span class=\"excrs__card-desc\">42 ou 3,14 \u2014 pas de guillemets. S\u00e9parateur d\u00e9cimal : la virgule en France.<\/span>\r\n          <\/div>\r\n          <div class=\"excrs__card\">\r\n            <span class=\"excrs__card-tag\">Logique<\/span>\r\n            <span class=\"excrs__card-desc\">VRAI ou FAUX \u2014 valeurs bool\u00e9ennes retourn\u00e9es par les comparaisons.<\/span>\r\n          <\/div>\r\n        <\/div>\r\n\r\n        <div class=\"excrs__infobox excrs--info\">\r\n          <span class=\"excrs__infobox-icon\">\ud83d\udca1<\/span>\r\n          <p class=\"excrs__infobox-body\"><strong>Raccourci cl\u00e9 :<\/strong> appuie sur <code>F4<\/code> apr\u00e8s avoir cliqu\u00e9 sur une r\u00e9f\u00e9rence de cellule pour basculer entre les modes Relative \u2192 Absolue \u2192 Mixte ligne \u2192 Mixte colonne.<\/p>\r\n        <\/div>\r\n\r\n        <div class=\"excrs__footnav\">\r\n          <button class=\"excrs__footbtn\" disabled>\u2190 Pr\u00e9c\u00e9dent<\/button>\r\n          <span class=\"excrs__footcount\">1 \/ 9<\/span>\r\n          <button class=\"excrs__footbtn\" onclick=\"excrsShow(1)\">Suivant \u2192<\/button>\r\n        <\/div>\r\n      <\/article>\r\n\r\n      <!-- \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\r\n           CH 2 \u2014 FONCTION SI\r\n      \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550 -->\r\n      <article class=\"excrs__chapter\" id=\"excrs-ch1\">\r\n        <span class=\"excrs__ch-badge\" style=\"background:#1D6F4220;color:#4ade80;border:1px solid #1D6F4250\">\ud83d\udd00 Logique<\/span>\r\n        <h2 class=\"excrs__ch-title\">Fonction SI<\/h2>\r\n        <p class=\"excrs__ch-intro\">La fonction SI est la base de toute logique conditionnelle dans Excel. Elle \u00e9value une condition et retourne une valeur si elle est vraie, une autre si elle est fausse.<\/p>\r\n\r\n        <p class=\"excrs__section-heading\">Syntaxe<\/p>\r\n        <div class=\"excrs__formula-sig\">\r\n          <span class=\"excrs__fn\">SI<\/span>(<span class=\"excrs__arg\">test_logique<\/span> ; <span class=\"excrs__arg\">valeur_si_vrai<\/span> ; <span class=\"excrs__arg\">valeur_si_faux<\/span>)\r\n          <small>test_logique : une condition (ex: A1>10) | valeur_si_vrai : r\u00e9sultat si VRAI | valeur_si_faux : r\u00e9sultat si FAUX<\/small>\r\n        <\/div>\r\n\r\n        <p class=\"excrs__section-heading\">Op\u00e9rateurs de comparaison<\/p>\r\n        <table class=\"excrs__reftable\">\r\n          <thead><tr><th>Op\u00e9rateur<\/th><th>Signification<\/th><th>Exemple<\/th><\/tr><\/thead>\r\n          <tbody>\r\n            <tr><td>=<\/td><td>\u00c9gal \u00e0<\/td><td><code>A1=10<\/code> \u2192 VRAI si A1 vaut 10<\/td><\/tr>\r\n            <tr><td>&lt;&gt;<\/td><td>Diff\u00e9rent de<\/td><td><code>A1&lt;&gt;\"Oui\"<\/code> \u2192 VRAI si A1 \u2260 \"Oui\"<\/td><\/tr>\r\n            <tr><td>&gt;<\/td><td>Sup\u00e9rieur \u00e0<\/td><td><code>A1&gt;100<\/code> \u2192 VRAI si A1 d\u00e9passe 100<\/td><\/tr>\r\n            <tr><td>&gt;=<\/td><td>Sup\u00e9rieur ou \u00e9gal<\/td><td><code>A1&gt;=18<\/code> \u2192 VRAI si A1 \u2265 18<\/td><\/tr>\r\n            <tr><td>&lt;<\/td><td>Inf\u00e9rieur \u00e0<\/td><td><code>B2&lt;0<\/code> \u2192 VRAI si B2 est n\u00e9gatif<\/td><\/tr>\r\n            <tr><td>&lt;=<\/td><td>Inf\u00e9rieur ou \u00e9gal<\/td><td><code>B2&lt;=100<\/code> \u2192 VRAI si B2 \u2264 100<\/td><\/tr>\r\n          <\/tbody>\r\n        <\/table>\r\n\r\n        <p class=\"excrs__section-heading\">Exemples concrets<\/p>\r\n        <div class=\"excrs__codeblock\">\r\n          <div class=\"excrs__codeblock-header\">\r\n            <div class=\"excrs__codeblock-left\">\r\n              <div class=\"excrs__win-dots\"><span class=\"excrs__dot-r\"><\/span><span class=\"excrs__dot-y\"><\/span><span class=\"excrs__dot-g\"><\/span><\/div>\r\n              <span class=\"excrs__codeblock-lang\">Excel \u2014 fonction SI<\/span>\r\n            <\/div>\r\n            <button class=\"excrs__copybtn\" onclick=\"excrsCopy(this)\">\ud83d\udccb Copier<\/button>\r\n          <\/div>\r\n          <pre><span class=\"ex-cmt\">Exemple 1 : mention selon la note (note en B2)<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">SI<\/span>(<span class=\"ex-ref\">B2<\/span><span class=\"ex-op\">&gt;=<\/span><span class=\"ex-num\">10<\/span> ; <span class=\"ex-str\">\"Admis\"<\/span> ; <span class=\"ex-str\">\"Recal\u00e9\"<\/span>)\r\n\r\n<span class=\"ex-cmt\">Exemple 2 : valeur num\u00e9rique \u2014 bonus si CA > objectif<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">SI<\/span>(<span class=\"ex-ref\">C5<\/span><span class=\"ex-op\">&gt;<\/span><span class=\"ex-ref\">D5<\/span> ; <span class=\"ex-ref\">C5<\/span><span class=\"ex-op\">*<\/span><span class=\"ex-num\">0,1<\/span> ; <span class=\"ex-num\">0<\/span>)\r\n\r\n<span class=\"ex-cmt\">Exemple 3 : cellule vide ou non<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">SI<\/span>(<span class=\"ex-ref\">A1<\/span><span class=\"ex-op\">=<\/span><span class=\"ex-str\">\"\"<\/span> ; <span class=\"ex-str\">\"Non renseign\u00e9\"<\/span> ; <span class=\"ex-ref\">A1<\/span>)\r\n\r\n<span class=\"ex-cmt\">Exemple 4 : retourner une formule dans le si_vrai<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">SI<\/span>(<span class=\"ex-ref\">E2<\/span><span class=\"ex-op\">&gt;=<\/span><span class=\"ex-num\">10<\/span> ; <span class=\"ex-ref\">E2<\/span><span class=\"ex-op\">*<\/span><span class=\"ex-num\">1,05<\/span> ; <span class=\"ex-ref\">E2<\/span><span class=\"ex-op\">*<\/span><span class=\"ex-num\">0,95<\/span>)\r\n<span class=\"ex-cmt\">\u2192 +5% si \u226510, -5% sinon<\/span><\/pre>\r\n        <\/div>\r\n\r\n        <p class=\"excrs__section-heading\">R\u00e9sultat dans le tableur<\/p>\r\n        <div class=\"excrs__xltable-wrap\">\r\n          <table class=\"excrs__xltable\">\r\n            <thead>\r\n              <tr>\r\n                <th class=\"excrs__xl-colheader\"><\/th>\r\n                <th class=\"excrs__xl-colheader\">A<\/th>\r\n                <th class=\"excrs__xl-colheader\">B<\/th>\r\n                <th class=\"excrs__xl-colheader\">C<\/th>\r\n              <\/tr>\r\n            <\/thead>\r\n            <tbody>\r\n              <tr>\r\n                <td class=\"excrs__xl-rownum\">1<\/td>\r\n                <td class=\"excrs__xl-header-row\">\u00c9l\u00e8ve<\/td>\r\n                <td class=\"excrs__xl-header-row\">Note \/20<\/td>\r\n                <td class=\"excrs__xl-header-row\">R\u00e9sultat<\/td>\r\n              <\/tr>\r\n              <tr>\r\n                <td class=\"excrs__xl-rownum\">2<\/td>\r\n                <td>Martin<\/td>\r\n                <td class=\"excrs__xl-num\">14<\/td>\r\n                <td class=\"excrs__xl-formula\">= SI(B2>=10;\"Admis\";\"Recal\u00e9\")<\/td>\r\n              <\/tr>\r\n              <tr>\r\n                <td class=\"excrs__xl-rownum\">3<\/td>\r\n                <td>Sophie<\/td>\r\n                <td class=\"excrs__xl-num\">8<\/td>\r\n                <td class=\"excrs__xl-formula\">= SI(B3>=10;\"Admis\";\"Recal\u00e9\")<\/td>\r\n              <\/tr>\r\n              <tr>\r\n                <td class=\"excrs__xl-rownum\">4<\/td>\r\n                <td>Lucas<\/td>\r\n                <td class=\"excrs__xl-num\">12<\/td>\r\n                <td class=\"excrs__xl-formula\">= SI(B4>=10;\"Admis\";\"Recal\u00e9\")<\/td>\r\n              <\/tr>\r\n            <\/tbody>\r\n          <\/table>\r\n        <\/div>\r\n        <div class=\"excrs__xltable-wrap\">\r\n          <table class=\"excrs__xltable\">\r\n            <thead>\r\n              <tr>\r\n                <th class=\"excrs__xl-colheader\"><\/th>\r\n                <th class=\"excrs__xl-colheader\">A<\/th>\r\n                <th class=\"excrs__xl-colheader\">B<\/th>\r\n                <th class=\"excrs__xl-colheader\">C<\/th>\r\n              <\/tr>\r\n            <\/thead>\r\n            <tbody>\r\n              <tr>\r\n                <td class=\"excrs__xl-rownum\">2<\/td>\r\n                <td>Martin<\/td>\r\n                <td class=\"excrs__xl-num\">14<\/td>\r\n                <td class=\"excrs__xl-true\">Admis<\/td>\r\n              <\/tr>\r\n              <tr>\r\n                <td class=\"excrs__xl-rownum\">3<\/td>\r\n                <td>Sophie<\/td>\r\n                <td class=\"excrs__xl-num\">8<\/td>\r\n                <td class=\"excrs__xl-false\">Recal\u00e9<\/td>\r\n              <\/tr>\r\n              <tr>\r\n                <td class=\"excrs__xl-rownum\">4<\/td>\r\n                <td>Lucas<\/td>\r\n                <td class=\"excrs__xl-num\">12<\/td>\r\n                <td class=\"excrs__xl-true\">Admis<\/td>\r\n              <\/tr>\r\n            <\/tbody>\r\n          <\/table>\r\n        <\/div>\r\n\r\n        <div class=\"excrs__infobox excrs--warn\">\r\n          <span class=\"excrs__infobox-icon\">\u26a0\ufe0f<\/span>\r\n          <p class=\"excrs__infobox-body\"><strong>Attention aux guillemets !<\/strong> Les cha\u00eenes de texte doivent \u00eatre entre guillemets droits <code>\"Admis\"<\/code>. Les nombres et r\u00e9f\u00e9rences de cellules ne prennent pas de guillemets. \u00c9crire <code>\"10\"<\/code> au lieu de <code>10<\/code> compare du texte, pas un nombre \u2014 r\u00e9sultats impr\u00e9visibles !<\/p>\r\n        <\/div>\r\n\r\n        <div class=\"excrs__footnav\">\r\n          <button class=\"excrs__footbtn\" onclick=\"excrsShow(0)\">\u2190 Pr\u00e9c\u00e9dent<\/button>\r\n          <span class=\"excrs__footcount\">2 \/ 9<\/span>\r\n          <button class=\"excrs__footbtn\" onclick=\"excrsShow(2)\">Suivant \u2192<\/button>\r\n        <\/div>\r\n      <\/article>\r\n\r\n      <!-- \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\r\n           CH 3 \u2014 ET \/ OU\r\n      \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550 -->\r\n      <article class=\"excrs__chapter\" id=\"excrs-ch2\">\r\n        <span class=\"excrs__ch-badge\" style=\"background:#1a0d2e;color:#c586c0;border:1px solid #c586c040\">\ud83d\udd17 ET \/ OU<\/span>\r\n        <h2 class=\"excrs__ch-title\">Fonctions ET et OU<\/h2>\r\n        <p class=\"excrs__ch-intro\">ET et OU permettent de combiner plusieurs conditions dans un SI. Elles \u00e9valuent plusieurs tests logiques et retournent VRAI ou FAUX \u2014 toujours utilis\u00e9es \u00e0 l'int\u00e9rieur d'un SI.<\/p>\r\n\r\n        <p class=\"excrs__section-heading\">Syntaxe<\/p>\r\n        <div class=\"excrs__formula-sig\">\r\n          <span class=\"excrs__fn\">ET<\/span>(<span class=\"excrs__arg\">condition1<\/span> ; <span class=\"excrs__arg\">condition2<\/span> ; <span class=\"excrs__arg\">...<\/span>)\r\n          <small>\u2192 Retourne VRAI seulement si TOUTES les conditions sont vraies (comme \"et\" en fran\u00e7ais)<\/small>\r\n        <\/div>\r\n        <div class=\"excrs__formula-sig\">\r\n          <span class=\"excrs__fn\">OU<\/span>(<span class=\"excrs__arg\">condition1<\/span> ; <span class=\"excrs__arg\">condition2<\/span> ; <span class=\"excrs__arg\">...<\/span>)\r\n          <small>\u2192 Retourne VRAI si AU MOINS UNE condition est vraie (comme \"ou\" en fran\u00e7ais)<\/small>\r\n        <\/div>\r\n\r\n        <p class=\"excrs__section-heading\">Table de v\u00e9rit\u00e9<\/p>\r\n        <div class=\"excrs__xltable-wrap\">\r\n          <table class=\"excrs__xltable\">\r\n            <thead>\r\n              <tr>\r\n                <th class=\"excrs__xl-colheader\">Condition A<\/th>\r\n                <th class=\"excrs__xl-colheader\">Condition B<\/th>\r\n                <th class=\"excrs__xl-colheader\">ET(A;B)<\/th>\r\n                <th class=\"excrs__xl-colheader\">OU(A;B)<\/th>\r\n              <\/tr>\r\n            <\/thead>\r\n            <tbody>\r\n              <tr><td class=\"excrs__xl-true\">VRAI<\/td><td class=\"excrs__xl-true\">VRAI<\/td><td class=\"excrs__xl-true\">VRAI<\/td><td class=\"excrs__xl-true\">VRAI<\/td><\/tr>\r\n              <tr><td class=\"excrs__xl-true\">VRAI<\/td><td class=\"excrs__xl-false\">FAUX<\/td><td class=\"excrs__xl-false\">FAUX<\/td><td class=\"excrs__xl-true\">VRAI<\/td><\/tr>\r\n              <tr><td class=\"excrs__xl-false\">FAUX<\/td><td class=\"excrs__xl-true\">VRAI<\/td><td class=\"excrs__xl-false\">FAUX<\/td><td class=\"excrs__xl-true\">VRAI<\/td><\/tr>\r\n              <tr><td class=\"excrs__xl-false\">FAUX<\/td><td class=\"excrs__xl-false\">FAUX<\/td><td class=\"excrs__xl-false\">FAUX<\/td><td class=\"excrs__xl-false\">FAUX<\/td><\/tr>\r\n            <\/tbody>\r\n          <\/table>\r\n        <\/div>\r\n\r\n        <p class=\"excrs__section-heading\">Exemples \u2014 ET<\/p>\r\n        <div class=\"excrs__codeblock\">\r\n          <div class=\"excrs__codeblock-header\">\r\n            <div class=\"excrs__codeblock-left\">\r\n              <div class=\"excrs__win-dots\"><span class=\"excrs__dot-r\"><\/span><span class=\"excrs__dot-y\"><\/span><span class=\"excrs__dot-g\"><\/span><\/div>\r\n              <span class=\"excrs__codeblock-lang\">Excel \u2014 SI avec ET<\/span>\r\n            <\/div>\r\n            <button class=\"excrs__copybtn\" onclick=\"excrsCopy(this)\">\ud83d\udccb Copier<\/button>\r\n          <\/div>\r\n          <pre><span class=\"ex-cmt\">Admis si note \u2265 10 ET assiduit\u00e9 = \"Oui\"<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">SI<\/span>(<span class=\"ex-fn\">ET<\/span>(<span class=\"ex-ref\">B2<\/span><span class=\"ex-op\">&gt;=<\/span><span class=\"ex-num\">10<\/span> ; <span class=\"ex-ref\">C2<\/span><span class=\"ex-op\">=<\/span><span class=\"ex-str\">\"Oui\"<\/span>) ; <span class=\"ex-str\">\"Admis\"<\/span> ; <span class=\"ex-str\">\"Recal\u00e9\"<\/span>)\r\n\r\n<span class=\"ex-cmt\">Remise si quantit\u00e9 \u2265 100 ET client = \"Fid\u00e8le\"<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">SI<\/span>(<span class=\"ex-fn\">ET<\/span>(<span class=\"ex-ref\">D5<\/span><span class=\"ex-op\">&gt;=<\/span><span class=\"ex-num\">100<\/span> ; <span class=\"ex-ref\">E5<\/span><span class=\"ex-op\">=<\/span><span class=\"ex-str\">\"Fid\u00e8le\"<\/span>) ; <span class=\"ex-ref\">D5<\/span><span class=\"ex-op\">*<\/span><span class=\"ex-num\">0,85<\/span> ; <span class=\"ex-ref\">D5<\/span>)\r\n<span class=\"ex-cmt\">\u2192 -15% si les 2 conditions sont remplies<\/span>\r\n\r\n<span class=\"ex-cmt\">Stock critique si \u2265 5 ET \u2264 20 unit\u00e9s<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">SI<\/span>(<span class=\"ex-fn\">ET<\/span>(<span class=\"ex-ref\">F3<\/span><span class=\"ex-op\">&gt;=<\/span><span class=\"ex-num\">5<\/span> ; <span class=\"ex-ref\">F3<\/span><span class=\"ex-op\">&lt;=<\/span><span class=\"ex-num\">20<\/span>) ; <span class=\"ex-str\">\"Critique\"<\/span> ; <span class=\"ex-str\">\"OK\"<\/span>)<\/pre>\r\n        <\/div>\r\n\r\n        <p class=\"excrs__section-heading\">Exemples \u2014 OU<\/p>\r\n        <div class=\"excrs__codeblock\">\r\n          <div class=\"excrs__codeblock-header\">\r\n            <div class=\"excrs__codeblock-left\">\r\n              <div class=\"excrs__win-dots\"><span class=\"excrs__dot-r\"><\/span><span class=\"excrs__dot-y\"><\/span><span class=\"excrs__dot-g\"><\/span><\/div>\r\n              <span class=\"excrs__codeblock-lang\">Excel \u2014 SI avec OU<\/span>\r\n            <\/div>\r\n            <button class=\"excrs__copybtn\" onclick=\"excrsCopy(this)\">\ud83d\udccb Copier<\/button>\r\n          <\/div>\r\n          <pre><span class=\"ex-cmt\">Prioritaire si VIP OU commande > 1000\u20ac<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">SI<\/span>(<span class=\"ex-fn\">OU<\/span>(<span class=\"ex-ref\">B2<\/span><span class=\"ex-op\">=<\/span><span class=\"ex-str\">\"VIP\"<\/span> ; <span class=\"ex-ref\">C2<\/span><span class=\"ex-op\">&gt;<\/span><span class=\"ex-num\">1000<\/span>) ; <span class=\"ex-str\">\"Prioritaire\"<\/span> ; <span class=\"ex-str\">\"Standard\"<\/span>)\r\n\r\n<span class=\"ex-cmt\">Alerte si rupture OU d\u00e9lai d\u00e9pass\u00e9<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">SI<\/span>(<span class=\"ex-fn\">OU<\/span>(<span class=\"ex-ref\">D3<\/span><span class=\"ex-op\">=<\/span><span class=\"ex-num\">0<\/span> ; <span class=\"ex-ref\">E3<\/span><span class=\"ex-op\">&gt;<\/span><span class=\"ex-num\">30<\/span>) ; <span class=\"ex-str\">\"\u26a0 ALERTE\"<\/span> ; <span class=\"ex-str\">\"\u2713 OK\"<\/span>)\r\n\r\n<span class=\"ex-cmt\">Eligible si R\u00e9gion = \"Nord\" OU = \"Est\"<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">SI<\/span>(<span class=\"ex-fn\">OU<\/span>(<span class=\"ex-ref\">F5<\/span><span class=\"ex-op\">=<\/span><span class=\"ex-str\">\"Nord\"<\/span> ; <span class=\"ex-ref\">F5<\/span><span class=\"ex-op\">=<\/span><span class=\"ex-str\">\"Est\"<\/span>) ; <span class=\"ex-str\">\"\u00c9ligible\"<\/span> ; <span class=\"ex-str\">\"Hors zone\"<\/span>)<\/pre>\r\n        <\/div>\r\n\r\n        <div class=\"excrs__infobox excrs--excel\">\r\n          <span class=\"excrs__infobox-icon\">\ud83c\udfaf<\/span>\r\n          <p class=\"excrs__infobox-body\"><strong>Astuce :<\/strong> ET et OU peuvent accepter jusqu'\u00e0 <strong>255 conditions<\/strong>. Tu peux aussi les combiner : <code>SI(ET(A1>0 ; OU(B1=\"X\" ; C1=\"Y\")) ; \"Oui\" ; \"Non\")<\/code><\/p>\r\n        <\/div>\r\n\r\n        <div class=\"excrs__footnav\">\r\n          <button class=\"excrs__footbtn\" onclick=\"excrsShow(1)\">\u2190 Pr\u00e9c\u00e9dent<\/button>\r\n          <span class=\"excrs__footcount\">3 \/ 9<\/span>\r\n          <button class=\"excrs__footbtn\" onclick=\"excrsShow(3)\">Suivant \u2192<\/button>\r\n        <\/div>\r\n      <\/article>\r\n\r\n      <!-- \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\r\n           CH 4 \u2014 SI IMBRIQU\u00c9S\r\n      \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550 -->\r\n      <article class=\"excrs__chapter\" id=\"excrs-ch3\">\r\n        <span class=\"excrs__ch-badge\" style=\"background:#1a120a;color:#f59e0b;border:1px solid #f59e0b40\">\ud83e\ude86 Imbrication<\/span>\r\n        <h2 class=\"excrs__ch-title\">SI imbriqu\u00e9s \u2014 plusieurs niveaux<\/h2>\r\n        <p class=\"excrs__ch-intro\">Quand deux r\u00e9sultats ne suffisent pas, on imbrique des SI dans d'autres SI. Chaque valeur_si_faux peut elle-m\u00eame \u00eatre un nouveau SI \u2014 jusqu'\u00e0 64 niveaux dans Excel moderne.<\/p>\r\n\r\n        <p class=\"excrs__section-heading\">Principe d'imbrication<\/p>\r\n        <div class=\"excrs__codeblock\">\r\n          <div class=\"excrs__codeblock-header\">\r\n            <div class=\"excrs__codeblock-left\">\r\n              <div class=\"excrs__win-dots\"><span class=\"excrs__dot-r\"><\/span><span class=\"excrs__dot-y\"><\/span><span class=\"excrs__dot-g\"><\/span><\/div>\r\n              <span class=\"excrs__codeblock-lang\">Excel \u2014 structure SI imbriqu\u00e9s<\/span>\r\n            <\/div>\r\n            <button class=\"excrs__copybtn\" onclick=\"excrsCopy(this)\">\ud83d\udccb Copier<\/button>\r\n          <\/div>\r\n          <pre><span class=\"ex-cmt\">Structure de base (lire de gauche \u00e0 droite)<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">SI<\/span>( condition1 ;\r\n     r\u00e9sultat1 ;            <span class=\"ex-cmt\">\u2190 si condition1 = VRAI<\/span>\r\n     <span class=\"ex-fn\">SI<\/span>( condition2 ;\r\n          r\u00e9sultat2 ;       <span class=\"ex-cmt\">\u2190 si condition1 = FAUX et condition2 = VRAI<\/span>\r\n          r\u00e9sultat3         <span class=\"ex-cmt\">\u2190 si toutes les conditions = FAUX<\/span>\r\n     )\r\n)<\/pre>\r\n        <\/div>\r\n\r\n        <p class=\"excrs__section-heading\">Exemple 1 \u2014 Mentions scolaires<\/p>\r\n        <div class=\"excrs__codeblock\">\r\n          <div class=\"excrs__codeblock-header\">\r\n            <div class=\"excrs__codeblock-left\">\r\n              <div class=\"excrs__win-dots\"><span class=\"excrs__dot-r\"><\/span><span class=\"excrs__dot-y\"><\/span><span class=\"excrs__dot-g\"><\/span><\/div>\r\n              <span class=\"excrs__codeblock-lang\">Excel \u2014 mention selon note (B2)<\/span>\r\n            <\/div>\r\n            <button class=\"excrs__copybtn\" onclick=\"excrsCopy(this)\">\ud83d\udccb Copier<\/button>\r\n          <\/div>\r\n          <pre><span class=\"ex-op\">=<\/span><span class=\"ex-fn\">SI<\/span>(<span class=\"ex-ref\">B2<\/span><span class=\"ex-op\">&gt;=<\/span><span class=\"ex-num\">16<\/span> ; <span class=\"ex-str\">\"Tr\u00e8s bien\"<\/span> ;\r\n   <span class=\"ex-fn\">SI<\/span>(<span class=\"ex-ref\">B2<\/span><span class=\"ex-op\">&gt;=<\/span><span class=\"ex-num\">14<\/span> ; <span class=\"ex-str\">\"Bien\"<\/span> ;\r\n      <span class=\"ex-fn\">SI<\/span>(<span class=\"ex-ref\">B2<\/span><span class=\"ex-op\">&gt;=<\/span><span class=\"ex-num\">12<\/span> ; <span class=\"ex-str\">\"Assez bien\"<\/span> ;\r\n         <span class=\"ex-fn\">SI<\/span>(<span class=\"ex-ref\">B2<\/span><span class=\"ex-op\">&gt;=<\/span><span class=\"ex-num\">10<\/span> ; <span class=\"ex-str\">\"Passable\"<\/span> ; <span class=\"ex-str\">\"Insuffisant\"<\/span>))))\r\n\r\n<span class=\"ex-cmt\">Logique de lecture :<\/span>\r\n<span class=\"ex-cmt\">\u226516 \u2192 \"Tr\u00e8s bien\"<\/span>\r\n<span class=\"ex-cmt\">\u226514 \u2192 \"Bien\"       (donc entre 14 et 15,99)<\/span>\r\n<span class=\"ex-cmt\">\u226512 \u2192 \"Assez bien\" (donc entre 12 et 13,99)<\/span>\r\n<span class=\"ex-cmt\">\u226510 \u2192 \"Passable\"   (donc entre 10 et 11,99)<\/span>\r\n<span class=\"ex-cmt\"> &lt;10 \u2192 \"Insuffisant\"<\/span><\/pre>\r\n        <\/div>\r\n\r\n        <p class=\"excrs__section-heading\">Exemple 2 \u2014 Grille tarifaire<\/p>\r\n        <div class=\"excrs__codeblock\">\r\n          <div class=\"excrs__codeblock-header\">\r\n            <div class=\"excrs__codeblock-left\">\r\n              <div class=\"excrs__win-dots\"><span class=\"excrs__dot-r\"><\/span><span class=\"excrs__dot-y\"><\/span><span class=\"excrs__dot-g\"><\/span><\/div>\r\n              <span class=\"excrs__codeblock-lang\">Excel \u2014 remise selon quantit\u00e9 (D5)<\/span>\r\n            <\/div>\r\n            <button class=\"excrs__copybtn\" onclick=\"excrsCopy(this)\">\ud83d\udccb Copier<\/button>\r\n          <\/div>\r\n          <pre><span class=\"ex-cmt\">Quantit\u00e9 en D5, Prix unitaire en E5<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">SI<\/span>(<span class=\"ex-ref\">D5<\/span><span class=\"ex-op\">&gt;=<\/span><span class=\"ex-num\">500<\/span> ; <span class=\"ex-ref\">E5<\/span><span class=\"ex-op\">*<\/span><span class=\"ex-num\">0,70<\/span> ;    <span class=\"ex-cmt\">\u2265500 : -30%<\/span>\r\n   <span class=\"ex-fn\">SI<\/span>(<span class=\"ex-ref\">D5<\/span><span class=\"ex-op\">&gt;=<\/span><span class=\"ex-num\">200<\/span> ; <span class=\"ex-ref\">E5<\/span><span class=\"ex-op\">*<\/span><span class=\"ex-num\">0,80<\/span> ;   <span class=\"ex-cmt\">\u2265200 : -20%<\/span>\r\n      <span class=\"ex-fn\">SI<\/span>(<span class=\"ex-ref\">D5<\/span><span class=\"ex-op\">&gt;=<\/span><span class=\"ex-num\">100<\/span> ; <span class=\"ex-ref\">E5<\/span><span class=\"ex-op\">*<\/span><span class=\"ex-num\">0,90<\/span> ;  <span class=\"ex-cmt\">\u2265100 : -10%<\/span>\r\n         <span class=\"ex-ref\">E5<\/span>)))                    <span class=\"ex-cmt\">&lt;100 : prix normal<\/span><\/pre>\r\n        <\/div>\r\n\r\n        <div class=\"excrs__compare-grid\">\r\n          <div class=\"excrs__compare-panel excrs--bad\">\r\n            <span class=\"excrs__compare-label\">\u2717 Erreur fr\u00e9quente<\/span>\r\n            <pre>=SI(B2>=10;\"Passable\";\r\n   SI(B2>=12;\"Assez bien\";\r\n      ...))\r\n\/* Logique INVERS\u00c9E !\r\n   Si B2=14, la 1\u00e8re condition\r\n   est vraie \u2192 \"Passable\"\r\n   Les suivants ne sont\r\n   jamais \u00e9valu\u00e9s. *\/<\/pre>\r\n          <\/div>\r\n          <div class=\"excrs__compare-panel excrs--good\">\r\n            <span class=\"excrs__compare-label\">\u2713 Ordre correct (du + grand au + petit)<\/span>\r\n            <pre>=SI(B2>=16;\"Tr\u00e8s bien\";\r\n   SI(B2>=14;\"Bien\";\r\n      SI(B2>=12;\"Assez bien\";\r\n         SI(B2>=10;\"Passable\";\r\n            \"Insuffisant\"))))\r\n\/* Tester TOUJOURS du seuil\r\n   le plus \u00c9LEV\u00c9 au plus\r\n   BAS. *\/<\/pre>\r\n          <\/div>\r\n        <\/div>\r\n\r\n        <div class=\"excrs__infobox excrs--info\">\r\n          <span class=\"excrs__infobox-icon\">\ud83d\udca1<\/span>\r\n          <p class=\"excrs__infobox-body\"><strong>Alternative moderne \u2014 SI.CONDITIONS<\/strong> (Excel 2019+) : plus lisible que les SI imbriqu\u00e9s.<br><code>=SI.CONDITIONS(B2>=16;\"Tr\u00e8s bien\"; B2>=14;\"Bien\"; B2>=12;\"Assez bien\"; B2>=10;\"Passable\"; VRAI;\"Insuffisant\")<\/code><\/p>\r\n        <\/div>\r\n\r\n        <div class=\"excrs__footnav\">\r\n          <button class=\"excrs__footbtn\" onclick=\"excrsShow(2)\">\u2190 Pr\u00e9c\u00e9dent<\/button>\r\n          <span class=\"excrs__footcount\">4 \/ 9<\/span>\r\n          <button class=\"excrs__footbtn\" onclick=\"excrsShow(4)\">Suivant \u2192<\/button>\r\n        <\/div>\r\n      <\/article>\r\n\r\n      <!-- \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\r\n           CH 5 \u2014 MAX \/ MIN\r\n      \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550 -->\r\n      <article class=\"excrs__chapter\" id=\"excrs-ch4\">\r\n        <span class=\"excrs__ch-badge\" style=\"background:#63A0E01F;color:#63AAE0;border:1px solid #63B4E040\">\ud83d\udcc8 Statistiques<\/span>\r\n        <h2 class=\"excrs__ch-title\">MAX, MIN et variantes<\/h2>\r\n        <p class=\"excrs__ch-intro\">Les fonctions statistiques permettent d'extraire les valeurs extr\u00eames d'une plage, de les classer et d'effectuer des analyses rapides sur des donn\u00e9es num\u00e9riques.<\/p>\r\n\r\n        <p class=\"excrs__section-heading\">MAX et MIN \u2014 bases<\/p>\r\n        <div class=\"excrs__codeblock\">\r\n          <div class=\"excrs__codeblock-header\">\r\n            <div class=\"excrs__codeblock-left\">\r\n              <div class=\"excrs__win-dots\"><span class=\"excrs__dot-r\"><\/span><span class=\"excrs__dot-y\"><\/span><span class=\"excrs__dot-g\"><\/span><\/div>\r\n              <span class=\"excrs__codeblock-lang\">Excel \u2014 MAX, MIN et variantes<\/span>\r\n            <\/div>\r\n            <button class=\"excrs__copybtn\" onclick=\"excrsCopy(this)\">\ud83d\udccb Copier<\/button>\r\n          <\/div>\r\n          <pre><span class=\"ex-cmt\">Valeur maximale d'une plage<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">MAX<\/span>(<span class=\"ex-ref\">B2<\/span><span class=\"ex-op\">:<\/span><span class=\"ex-ref\">B50<\/span>)\r\n\r\n<span class=\"ex-cmt\">Valeur minimale<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">MIN<\/span>(<span class=\"ex-ref\">B2<\/span><span class=\"ex-op\">:<\/span><span class=\"ex-ref\">B50<\/span>)\r\n\r\n<span class=\"ex-cmt\">Plusieurs plages non contigu\u00ebs<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">MAX<\/span>(<span class=\"ex-ref\">B2<\/span><span class=\"ex-op\">:<\/span><span class=\"ex-ref\">B10<\/span> ; <span class=\"ex-ref\">D2<\/span><span class=\"ex-op\">:<\/span><span class=\"ex-ref\">D10<\/span> ; <span class=\"ex-ref\">F5<\/span>)\r\n\r\n<span class=\"ex-cmt\">2\u00e8me plus grande valeur (GRANDE.VALEUR)<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">GRANDE.VALEUR<\/span>(<span class=\"ex-ref\">B2<\/span><span class=\"ex-op\">:<\/span><span class=\"ex-ref\">B50<\/span> ; <span class=\"ex-num\">2<\/span>)   <span class=\"ex-cmt\">\u2190 2 = 2\u00e8me rang<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">GRANDE.VALEUR<\/span>(<span class=\"ex-ref\">B2<\/span><span class=\"ex-op\">:<\/span><span class=\"ex-ref\">B50<\/span> ; <span class=\"ex-num\">3<\/span>)   <span class=\"ex-cmt\">\u2190 3 = 3\u00e8me rang<\/span>\r\n\r\n<span class=\"ex-cmt\">2\u00e8me plus petite valeur (PETITE.VALEUR)<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">PETITE.VALEUR<\/span>(<span class=\"ex-ref\">B2<\/span><span class=\"ex-op\">:<\/span><span class=\"ex-ref\">B50<\/span> ; <span class=\"ex-num\">2<\/span>)\r\n\r\n<span class=\"ex-cmt\">Rang d'une valeur dans une plage<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">RANG<\/span>(<span class=\"ex-ref\">B2<\/span> ; <span class=\"ex-ref\">B<\/span><span class=\"ex-op\">$<\/span><span class=\"ex-num\">2<\/span><span class=\"ex-op\">:<\/span><span class=\"ex-ref\">B<\/span><span class=\"ex-op\">$<\/span><span class=\"ex-num\">50<\/span> ; <span class=\"ex-num\">0<\/span>)\r\n<span class=\"ex-cmt\">\u2190 0 = ordre d\u00e9croissant (1 = le plus grand)<\/span>\r\n<span class=\"ex-cmt\">\u2190 1 = ordre croissant (1 = le plus petit)<\/span><\/pre>\r\n        <\/div>\r\n\r\n        <p class=\"excrs__section-heading\">Combinaisons utiles avec SI<\/p>\r\n        <div class=\"excrs__codeblock\">\r\n          <div class=\"excrs__codeblock-header\">\r\n            <div class=\"excrs__codeblock-left\">\r\n              <div class=\"excrs__win-dots\"><span class=\"excrs__dot-r\"><\/span><span class=\"excrs__dot-y\"><\/span><span class=\"excrs__dot-g\"><\/span><\/div>\r\n              <span class=\"excrs__codeblock-lang\">Excel \u2014 MAX \/ MIN avec logique<\/span>\r\n            <\/div>\r\n            <button class=\"excrs__copybtn\" onclick=\"excrsCopy(this)\">\ud83d\udccb Copier<\/button>\r\n          <\/div>\r\n          <pre><span class=\"ex-cmt\">Valeur jamais inf\u00e9rieure \u00e0 0 (plancher)<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">MAX<\/span>(<span class=\"ex-ref\">A1<\/span> ; <span class=\"ex-num\">0<\/span>)\r\n<span class=\"ex-cmt\">\u2192 retourne A1 si positif, sinon 0<\/span>\r\n\r\n<span class=\"ex-cmt\">Valeur plafonn\u00e9e \u00e0 100<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">MIN<\/span>(<span class=\"ex-ref\">A1<\/span> ; <span class=\"ex-num\">100<\/span>)\r\n<span class=\"ex-cmt\">\u2192 retourne A1 si \u2264100, sinon 100<\/span>\r\n\r\n<span class=\"ex-cmt\">Valeur entre un plancher ET un plafond<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">MIN<\/span>(<span class=\"ex-fn\">MAX<\/span>(<span class=\"ex-ref\">A1<\/span> ; <span class=\"ex-num\">0<\/span>) ; <span class=\"ex-num\">100<\/span>)\r\n<span class=\"ex-cmt\">\u2192 toujours entre 0 et 100<\/span>\r\n\r\n<span class=\"ex-cmt\">Mettre en valeur le max dans SI<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">SI<\/span>(<span class=\"ex-ref\">B2<\/span><span class=\"ex-op\">=<\/span><span class=\"ex-fn\">MAX<\/span>(<span class=\"ex-op\">$<\/span><span class=\"ex-ref\">B<\/span><span class=\"ex-op\">$<\/span><span class=\"ex-num\">2<\/span><span class=\"ex-op\">:<\/span><span class=\"ex-op\">$<\/span><span class=\"ex-ref\">B<\/span><span class=\"ex-op\">$<\/span><span class=\"ex-num\">50<\/span>) ; <span class=\"ex-str\">\"\ud83c\udfc6 Meilleur\"<\/span> ; <span class=\"ex-str\">\"\"<\/span>)<\/pre>\r\n        <\/div>\r\n\r\n        <table class=\"excrs__reftable\">\r\n          <thead><tr><th>Fonction<\/th><th>R\u00f4le<\/th><th>Exemple<\/th><\/tr><\/thead>\r\n          <tbody>\r\n            <tr><td>MAX(plage)<\/td><td>Plus grande valeur de la plage<\/td><td><code>=MAX(B2:B100)<\/code><\/td><\/tr>\r\n            <tr><td>MIN(plage)<\/td><td>Plus petite valeur de la plage<\/td><td><code>=MIN(B2:B100)<\/code><\/td><\/tr>\r\n            <tr><td>GRANDE.VALEUR(plage;k)<\/td><td>k-i\u00e8me plus grande valeur<\/td><td><code>=GRANDE.VALEUR(B2:B100;3)<\/code><\/td><\/tr>\r\n            <tr><td>PETITE.VALEUR(plage;k)<\/td><td>k-i\u00e8me plus petite valeur<\/td><td><code>=PETITE.VALEUR(B2:B100;2)<\/code><\/td><\/tr>\r\n            <tr><td>RANG(valeur;plage;ordre)<\/td><td>Position d'une valeur dans la plage<\/td><td><code>=RANG(B2;$B$2:$B$50;0)<\/code><\/td><\/tr>\r\n            <tr><td>MEDIANE(plage)<\/td><td>Valeur m\u00e9diane (milieu statistique)<\/td><td><code>=MEDIANE(B2:B100)<\/code><\/td><\/tr>\r\n            <tr><td>ECARTYPE(plage)<\/td><td>\u00c9cart-type (dispersion des donn\u00e9es)<\/td><td><code>=ECARTYPE(B2:B100)<\/code><\/td><\/tr>\r\n          <\/tbody>\r\n        <\/table>\r\n\r\n        <div class=\"excrs__footnav\">\r\n          <button class=\"excrs__footbtn\" onclick=\"excrsShow(3)\">\u2190 Pr\u00e9c\u00e9dent<\/button>\r\n          <span class=\"excrs__footcount\">5 \/ 9<\/span>\r\n          <button class=\"excrs__footbtn\" onclick=\"excrsShow(5)\">Suivant \u2192<\/button>\r\n        <\/div>\r\n      <\/article>\r\n\r\n      <!-- \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\r\n           CH 6 \u2014 NB.SI \/ SOMME.SI\r\n      \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550 -->\r\n      <article class=\"excrs__chapter\" id=\"excrs-ch5\">\r\n        <span class=\"excrs__ch-badge\" style=\"background:#0d2218;color:#4ade80;border:1px solid #4ade8040\">\ud83d\udd22 Conditionnelles<\/span>\r\n        <h2 class=\"excrs__ch-title\">NB.SI, SOMME.SI, MOYENNE.SI<\/h2>\r\n        <p class=\"excrs__ch-intro\">Ces fonctions combinent un calcul (compter, additionner, faire une moyenne) avec un filtre conditionnel \u2014 sans avoir besoin de filtrer manuellement les donn\u00e9es.<\/p>\r\n\r\n        <p class=\"excrs__section-heading\">NB.SI \u2014 compter selon un crit\u00e8re<\/p>\r\n        <div class=\"excrs__formula-sig\">\r\n          <span class=\"excrs__fn\">NB.SI<\/span>(<span class=\"excrs__arg\">plage_crit\u00e8re<\/span> ; <span class=\"excrs__arg\">crit\u00e8re<\/span>)\r\n          <small>Compte le nombre de cellules dans plage_crit\u00e8re qui satisfont le crit\u00e8re<\/small>\r\n        <\/div>\r\n        <div class=\"excrs__codeblock\">\r\n          <div class=\"excrs__codeblock-header\">\r\n            <div class=\"excrs__codeblock-left\">\r\n              <div class=\"excrs__win-dots\"><span class=\"excrs__dot-r\"><\/span><span class=\"excrs__dot-y\"><\/span><span class=\"excrs__dot-g\"><\/span><\/div>\r\n              <span class=\"excrs__codeblock-lang\">Excel \u2014 NB.SI<\/span>\r\n            <\/div>\r\n            <button class=\"excrs__copybtn\" onclick=\"excrsCopy(this)\">\ud83d\udccb Copier<\/button>\r\n          <\/div>\r\n          <pre><span class=\"ex-cmt\">Combien de fois \"Paris\" appara\u00eet en colonne A<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">NB.SI<\/span>(<span class=\"ex-ref\">A2<\/span><span class=\"ex-op\">:<\/span><span class=\"ex-ref\">A100<\/span> ; <span class=\"ex-str\">\"Paris\"<\/span>)\r\n\r\n<span class=\"ex-cmt\">Combien de valeurs > 50<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">NB.SI<\/span>(<span class=\"ex-ref\">B2<\/span><span class=\"ex-op\">:<\/span><span class=\"ex-ref\">B100<\/span> ; <span class=\"ex-str\">\"&gt;50\"<\/span>)   <span class=\"ex-cmt\">\u2190 op\u00e9rateur entre guillemets !<\/span>\r\n\r\n<span class=\"ex-cmt\">Crit\u00e8re dans une cellule de r\u00e9f\u00e9rence<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">NB.SI<\/span>(<span class=\"ex-ref\">A2<\/span><span class=\"ex-op\">:<\/span><span class=\"ex-ref\">A100<\/span> ; <span class=\"ex-ref\">E1<\/span>)       <span class=\"ex-cmt\">\u2190 valeur de E1 comme crit\u00e8re<\/span>\r\n\r\n<span class=\"ex-cmt\">Crit\u00e8re avec joker * (tout ce qui contient \"tech\")<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">NB.SI<\/span>(<span class=\"ex-ref\">A2<\/span><span class=\"ex-op\">:<\/span><span class=\"ex-ref\">A100<\/span> ; <span class=\"ex-str\">\"*tech*\"<\/span>)\r\n\r\n<span class=\"ex-cmt\">Variante : NB.SI.ENS \u2014 plusieurs crit\u00e8res<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">NB.SI.ENS<\/span>(<span class=\"ex-ref\">A2<\/span><span class=\"ex-op\">:<\/span><span class=\"ex-ref\">A100<\/span> ; <span class=\"ex-str\">\"Paris\"<\/span> ; <span class=\"ex-ref\">B2<\/span><span class=\"ex-op\">:<\/span><span class=\"ex-ref\">B100<\/span> ; <span class=\"ex-str\">\"&gt;1000\"<\/span>)\r\n<span class=\"ex-cmt\">\u2192 compte les lignes o\u00f9 A=\"Paris\" ET B>1000<\/span><\/pre>\r\n        <\/div>\r\n\r\n        <p class=\"excrs__section-heading\">SOMME.SI \u2014 additionner selon un crit\u00e8re<\/p>\r\n        <div class=\"excrs__formula-sig\">\r\n          <span class=\"excrs__fn\">SOMME.SI<\/span>(<span class=\"excrs__arg\">plage_crit\u00e8re<\/span> ; <span class=\"excrs__arg\">crit\u00e8re<\/span> ; <span class=\"excrs__arg\">plage_somme<\/span>)\r\n          <small>Additionne les cellules de plage_somme dont la ligne correspondante dans plage_crit\u00e8re satisfait le crit\u00e8re<\/small>\r\n        <\/div>\r\n        <div class=\"excrs__codeblock\">\r\n          <div class=\"excrs__codeblock-header\">\r\n            <div class=\"excrs__codeblock-left\">\r\n              <div class=\"excrs__win-dots\"><span class=\"excrs__dot-r\"><\/span><span class=\"excrs__dot-y\"><\/span><span class=\"excrs__dot-g\"><\/span><\/div>\r\n              <span class=\"excrs__codeblock-lang\">Excel \u2014 SOMME.SI \/ SOMME.SI.ENS<\/span>\r\n            <\/div>\r\n            <button class=\"excrs__copybtn\" onclick=\"excrsCopy(this)\">\ud83d\udccb Copier<\/button>\r\n          <\/div>\r\n          <pre><span class=\"ex-cmt\">Total des ventes de la r\u00e9gion \"Nord\" (r\u00e9gion en A, montant en C)<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">SOMME.SI<\/span>(<span class=\"ex-ref\">A2<\/span><span class=\"ex-op\">:<\/span><span class=\"ex-ref\">A100<\/span> ; <span class=\"ex-str\">\"Nord\"<\/span> ; <span class=\"ex-ref\">C2<\/span><span class=\"ex-op\">:<\/span><span class=\"ex-ref\">C100<\/span>)\r\n\r\n<span class=\"ex-cmt\">Total des montants > 500\u20ac<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">SOMME.SI<\/span>(<span class=\"ex-ref\">C2<\/span><span class=\"ex-op\">:<\/span><span class=\"ex-ref\">C100<\/span> ; <span class=\"ex-str\">\"&gt;500\"<\/span> ; <span class=\"ex-ref\">C2<\/span><span class=\"ex-op\">:<\/span><span class=\"ex-ref\">C100<\/span>)\r\n\r\n<span class=\"ex-cmt\">Variante : SOMME.SI.ENS \u2014 r\u00e9gion \"Nord\" ET vendeur \"Martin\"<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">SOMME.SI.ENS<\/span>(<span class=\"ex-ref\">C2<\/span><span class=\"ex-op\">:<\/span><span class=\"ex-ref\">C100<\/span> ;    <span class=\"ex-cmt\">\u2190 plage \u00e0 sommer EN PREMIER<\/span>\r\n               <span class=\"ex-ref\">A2<\/span><span class=\"ex-op\">:<\/span><span class=\"ex-ref\">A100<\/span> ; <span class=\"ex-str\">\"Nord\"<\/span> ;\r\n               <span class=\"ex-ref\">B2<\/span><span class=\"ex-op\">:<\/span><span class=\"ex-ref\">B100<\/span> ; <span class=\"ex-str\">\"Martin\"<\/span>)<\/pre>\r\n        <\/div>\r\n\r\n        <div class=\"excrs__infobox excrs--warn\">\r\n          <span class=\"excrs__infobox-icon\">\u26a0\ufe0f<\/span>\r\n          <p class=\"excrs__infobox-body\"><strong>SOMME.SI vs SOMME.SI.ENS :<\/strong> attention \u00e0 l'ordre des arguments ! Dans <code>SOMME.SI<\/code>, la plage \u00e0 sommer est en <em>3\u00e8me<\/em> position. Dans <code>SOMME.SI.ENS<\/code>, elle est en <em>1\u00e8re<\/em> position. C'est un pi\u00e8ge classique.<\/p>\r\n        <\/div>\r\n\r\n        <p class=\"excrs__section-heading\">MOYENNE.SI \u2014 moyenne conditionnelle<\/p>\r\n        <div class=\"excrs__codeblock\">\r\n          <div class=\"excrs__codeblock-header\">\r\n            <div class=\"excrs__codeblock-left\">\r\n              <div class=\"excrs__win-dots\"><span class=\"excrs__dot-r\"><\/span><span class=\"excrs__dot-y\"><\/span><span class=\"excrs__dot-g\"><\/span><\/div>\r\n              <span class=\"excrs__codeblock-lang\">Excel \u2014 MOYENNE.SI<\/span>\r\n            <\/div>\r\n            <button class=\"excrs__copybtn\" onclick=\"excrsCopy(this)\">\ud83d\udccb Copier<\/button>\r\n          <\/div>\r\n          <pre><span class=\"ex-cmt\">Note moyenne des \u00e9l\u00e8ves de la classe \"TS1\" (classe en A, notes en B)<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">MOYENNE.SI<\/span>(<span class=\"ex-ref\">A2<\/span><span class=\"ex-op\">:<\/span><span class=\"ex-ref\">A100<\/span> ; <span class=\"ex-str\">\"TS1\"<\/span> ; <span class=\"ex-ref\">B2<\/span><span class=\"ex-op\">:<\/span><span class=\"ex-ref\">B100<\/span>)\r\n\r\n<span class=\"ex-cmt\">Moyenne des salaires > 2000\u20ac<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">MOYENNE.SI<\/span>(<span class=\"ex-ref\">C2<\/span><span class=\"ex-op\">:<\/span><span class=\"ex-ref\">C100<\/span> ; <span class=\"ex-str\">\"&gt;2000\"<\/span> ; <span class=\"ex-ref\">C2<\/span><span class=\"ex-op\">:<\/span><span class=\"ex-ref\">C100<\/span>)<\/pre>\r\n        <\/div>\r\n\r\n        <div class=\"excrs__footnav\">\r\n          <button class=\"excrs__footbtn\" onclick=\"excrsShow(4)\">\u2190 Pr\u00e9c\u00e9dent<\/button>\r\n          <span class=\"excrs__footcount\">6 \/ 9<\/span>\r\n          <button class=\"excrs__footbtn\" onclick=\"excrsShow(6)\">Suivant \u2192<\/button>\r\n        <\/div>\r\n      <\/article>\r\n\r\n      <!-- \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\r\n           CH 7 \u2014 RECHERCHEV\r\n      \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550 -->\r\n      <article class=\"excrs__chapter\" id=\"excrs-ch6\">\r\n        <span class=\"excrs__ch-badge\" style=\"background:#1a120a;color:#f59e0b;border:1px solid #f59e0b40\">\ud83d\udd0d Recherche<\/span>\r\n        <h2 class=\"excrs__ch-title\">RECHERCHEV \u2014 la fonction cl\u00e9<\/h2>\r\n        <p class=\"excrs__ch-intro\">RECHERCHEV (VLOOKUP) cherche une valeur dans la premi\u00e8re colonne d'un tableau et retourne une valeur de la m\u00eame ligne dans une autre colonne. Indispensable pour relier deux tables de donn\u00e9es.<\/p>\r\n\r\n        <p class=\"excrs__section-heading\">Syntaxe<\/p>\r\n        <div class=\"excrs__formula-sig\">\r\n          <span class=\"excrs__fn\">RECHERCHEV<\/span>(<span class=\"excrs__arg\">valeur_cherch\u00e9e<\/span> ; <span class=\"excrs__arg\">table_matrice<\/span> ; <span class=\"excrs__arg\">no_index_col<\/span> ; <span class=\"excrs__arg\">valeur_proche<\/span>)\r\n          <small>valeur_cherch\u00e9e : ce qu'on recherche | table_matrice : le tableau de r\u00e9f\u00e9rence (1\u00e8re col = cl\u00e9) | no_index_col : num\u00e9ro de la colonne \u00e0 retourner | valeur_proche : FAUX pour une correspondance exacte (recommand\u00e9)<\/small>\r\n        <\/div>\r\n\r\n        <p class=\"excrs__section-heading\">Exemple concret \u2014 Catalogue produits<\/p>\r\n        <div class=\"excrs__xltable-wrap\">\r\n          <table class=\"excrs__xltable\">\r\n            <thead>\r\n              <tr>\r\n                <th class=\"excrs__xl-colheader\"><\/th>\r\n                <th class=\"excrs__xl-colheader\">A \u2014 R\u00e9f.<\/th>\r\n                <th class=\"excrs__xl-colheader\">B \u2014 D\u00e9signation<\/th>\r\n                <th class=\"excrs__xl-colheader\">C \u2014 Prix HT<\/th>\r\n                <th class=\"excrs__xl-colheader\">D \u2014 Stock<\/th>\r\n              <\/tr>\r\n            <\/thead>\r\n            <tbody>\r\n              <tr><td class=\"excrs__xl-rownum\">1<\/td><td class=\"excrs__xl-header-row\">Code<\/td><td class=\"excrs__xl-header-row\">Produit<\/td><td class=\"excrs__xl-header-row\">Prix HT<\/td><td class=\"excrs__xl-header-row\">Stock<\/td><\/tr>\r\n              <tr><td class=\"excrs__xl-rownum\">2<\/td><td class=\"excrs__xl-num\">P001<\/td><td>Souris optique<\/td><td class=\"excrs__xl-num\">12,50 \u20ac<\/td><td class=\"excrs__xl-num\">85<\/td><\/tr>\r\n              <tr><td class=\"excrs__xl-rownum\">3<\/td><td class=\"excrs__xl-num\">P002<\/td><td>Clavier m\u00e9canique<\/td><td class=\"excrs__xl-num\">45,00 \u20ac<\/td><td class=\"excrs__xl-num\">32<\/td><\/tr>\r\n              <tr><td class=\"excrs__xl-rownum\">4<\/td><td class=\"excrs__xl-num\">P003<\/td><td>\u00c9cran 24\"<\/td><td class=\"excrs__xl-num\">189,00 \u20ac<\/td><td class=\"excrs__xl-num\">14<\/td><\/tr>\r\n              <tr><td class=\"excrs__xl-rownum\">5<\/td><td class=\"excrs__xl-num\">P004<\/td><td>Casque audio<\/td><td class=\"excrs__xl-num\">29,90 \u20ac<\/td><td class=\"excrs__xl-num\">0<\/td><\/tr>\r\n            <\/tbody>\r\n          <\/table>\r\n        <\/div>\r\n\r\n        <div class=\"excrs__codeblock\">\r\n          <div class=\"excrs__codeblock-header\">\r\n            <div class=\"excrs__codeblock-left\">\r\n              <div class=\"excrs__win-dots\"><span class=\"excrs__dot-r\"><\/span><span class=\"excrs__dot-y\"><\/span><span class=\"excrs__dot-g\"><\/span><\/div>\r\n              <span class=\"excrs__codeblock-lang\">Excel \u2014 RECHERCHEV sur le catalogue<\/span>\r\n            <\/div>\r\n            <button class=\"excrs__copybtn\" onclick=\"excrsCopy(this)\">\ud83d\udccb Copier<\/button>\r\n          <\/div>\r\n          <pre><span class=\"ex-cmt\">Je cherche le prix de P003 (code saisi en G2)<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">RECHERCHEV<\/span>(<span class=\"ex-ref\">G2<\/span> ; <span class=\"ex-op\">$<\/span><span class=\"ex-ref\">A<\/span><span class=\"ex-op\">$<\/span><span class=\"ex-num\">1<\/span><span class=\"ex-op\">:<\/span><span class=\"ex-op\">$<\/span><span class=\"ex-ref\">D<\/span><span class=\"ex-op\">$<\/span><span class=\"ex-num\">100<\/span> ; <span class=\"ex-num\">3<\/span> ; <span class=\"ex-fn\">FAUX<\/span>)\r\n<span class=\"ex-cmt\">                \u2191           \u2191                \u2191      \u2191<\/span>\r\n<span class=\"ex-cmt\">           G2=P003     tableau       col 3 = Prix  Exacte<\/span>\r\n<span class=\"ex-cmt\">                         (fig\u00e9)      (B=2, C=3, D=4)<\/span>\r\n\r\n<span class=\"ex-cmt\">R\u00e9cup\u00e9rer la d\u00e9signation (colonne 2)<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">RECHERCHEV<\/span>(<span class=\"ex-ref\">G2<\/span> ; <span class=\"ex-op\">$<\/span><span class=\"ex-ref\">A<\/span><span class=\"ex-op\">$<\/span><span class=\"ex-num\">1<\/span><span class=\"ex-op\">:<\/span><span class=\"ex-op\">$<\/span><span class=\"ex-ref\">D<\/span><span class=\"ex-op\">$<\/span><span class=\"ex-num\">100<\/span> ; <span class=\"ex-num\">2<\/span> ; <span class=\"ex-fn\">FAUX<\/span>)\r\n\r\n<span class=\"ex-cmt\">R\u00e9cup\u00e9rer le stock (colonne 4)<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">RECHERCHEV<\/span>(<span class=\"ex-ref\">G2<\/span> ; <span class=\"ex-op\">$<\/span><span class=\"ex-ref\">A<\/span><span class=\"ex-op\">$<\/span><span class=\"ex-num\">1<\/span><span class=\"ex-op\">:<\/span><span class=\"ex-op\">$<\/span><span class=\"ex-ref\">D<\/span><span class=\"ex-op\">$<\/span><span class=\"ex-num\">100<\/span> ; <span class=\"ex-num\">4<\/span> ; <span class=\"ex-fn\">FAUX<\/span>)<\/pre>\r\n        <\/div>\r\n\r\n        <p class=\"excrs__section-heading\">G\u00e9rer les erreurs #N\/A avec SIERREUR<\/p>\r\n        <div class=\"excrs__codeblock\">\r\n          <div class=\"excrs__codeblock-header\">\r\n            <div class=\"excrs__codeblock-left\">\r\n              <div class=\"excrs__win-dots\"><span class=\"excrs__dot-r\"><\/span><span class=\"excrs__dot-y\"><\/span><span class=\"excrs__dot-g\"><\/span><\/div>\r\n              <span class=\"excrs__codeblock-lang\">Excel \u2014 SIERREUR + RECHERCHEV<\/span>\r\n            <\/div>\r\n            <button class=\"excrs__copybtn\" onclick=\"excrsCopy(this)\">\ud83d\udccb Copier<\/button>\r\n          <\/div>\r\n          <pre><span class=\"ex-cmt\">Si le code n'existe pas \u2192 afficher message propre au lieu de #N\/A<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">SIERREUR<\/span>(\r\n   <span class=\"ex-fn\">RECHERCHEV<\/span>(<span class=\"ex-ref\">G2<\/span> ; <span class=\"ex-op\">$<\/span><span class=\"ex-ref\">A<\/span><span class=\"ex-op\">$<\/span><span class=\"ex-num\">1<\/span><span class=\"ex-op\">:<\/span><span class=\"ex-op\">$<\/span><span class=\"ex-ref\">D<\/span><span class=\"ex-op\">$<\/span><span class=\"ex-num\">100<\/span> ; <span class=\"ex-num\">3<\/span> ; <span class=\"ex-fn\">FAUX<\/span>) ;\r\n   <span class=\"ex-str\">\"Produit introuvable\"<\/span>\r\n)<\/pre>\r\n        <\/div>\r\n\r\n        <div class=\"excrs__compare-grid\">\r\n          <div class=\"excrs__compare-panel excrs--bad\">\r\n            <span class=\"excrs__compare-label\">\u2717 Limites de RECHERCHEV<\/span>\r\n            <pre>\u2192 Cherche TOUJOURS\r\n  dans la 1\u00e8re colonne\r\n\r\n\u2192 Ne peut pas regarder\r\n  \u00e0 GAUCHE de la cl\u00e9\r\n\r\n\u2192 Sensible \u00e0 l'ajout\r\n  de colonnes (le no.\r\n  d'index change)\r\n\r\n\u2192 Moins performant sur\r\n  tr\u00e8s grandes plages<\/pre>\r\n          <\/div>\r\n          <div class=\"excrs__compare-panel excrs--good\">\r\n            <span class=\"excrs__compare-label\">\u2713 Alternative moderne : INDEX + EQUIV<\/span>\r\n            <pre>=INDEX(C2:C100 ;\r\n       EQUIV(G2;A2:A100;0))\r\n\r\n\u2192 Cherche dans n'importe\r\n  quelle colonne\r\n\r\n\u2192 Peut retourner \u00e0 gauche\r\n\r\n\u2192 Plus robuste aux\r\n  modifications de tableau\r\n\r\n\u2192 Plus performant<\/pre>\r\n          <\/div>\r\n        <\/div>\r\n\r\n        <div class=\"excrs__infobox excrs--excel\">\r\n          <span class=\"excrs__infobox-icon\">\ud83d\ude80<\/span>\r\n          <p class=\"excrs__infobox-body\"><strong>Excel 2021 \/ Microsoft 365 :<\/strong> la fonction <code>RECHERCHEX<\/code> (XLOOKUP) remplace avantageusement RECHERCHEV \u2014 elle cherche dans n'importe quelle direction, g\u00e8re nativement les erreurs et retourne plusieurs colonnes d'un coup.<\/p>\r\n        <\/div>\r\n\r\n        <div class=\"excrs__footnav\">\r\n          <button class=\"excrs__footbtn\" onclick=\"excrsShow(5)\">\u2190 Pr\u00e9c\u00e9dent<\/button>\r\n          <span class=\"excrs__footcount\">7 \/ 9<\/span>\r\n          <button class=\"excrs__footbtn\" onclick=\"excrsShow(7)\">Suivant \u2192<\/button>\r\n        <\/div>\r\n      <\/article>\r\n\r\n      <!-- \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\r\n           CH 8 \u2014 FONCTIONS TEXTE\r\n      \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550 -->\r\n      <article class=\"excrs__chapter\" id=\"excrs-ch7\">\r\n        <span class=\"excrs__ch-badge\" style=\"background:#1a0d2e;color:#c586c0;border:1px solid #c586c040\">\ud83d\udd21 Texte<\/span>\r\n        <h2 class=\"excrs__ch-title\">Fonctions Texte<\/h2>\r\n        <p class=\"excrs__ch-intro\">Les fonctions texte permettent de manipuler, extraire, nettoyer et transformer des cha\u00eenes de caract\u00e8res \u2014 indispensable pour nettoyer des donn\u00e9es import\u00e9es ou construire des r\u00e9f\u00e9rences.<\/p>\r\n\r\n        <div class=\"excrs__codeblock\">\r\n          <div class=\"excrs__codeblock-header\">\r\n            <div class=\"excrs__codeblock-left\">\r\n              <div class=\"excrs__win-dots\"><span class=\"excrs__dot-r\"><\/span><span class=\"excrs__dot-y\"><\/span><span class=\"excrs__dot-g\"><\/span><\/div>\r\n              <span class=\"excrs__codeblock-lang\">Excel \u2014 fonctions texte essentielles<\/span>\r\n            <\/div>\r\n            <button class=\"excrs__copybtn\" onclick=\"excrsCopy(this)\">\ud83d\udccb Copier<\/button>\r\n          <\/div>\r\n          <pre><span class=\"ex-cmt\">GAUCHE \/ DROITE \/ MILIEU \u2014 extraction<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">GAUCHE<\/span>(<span class=\"ex-ref\">A1<\/span> ; <span class=\"ex-num\">3<\/span>)         <span class=\"ex-cmt\">\u2190 3 premiers caract\u00e8res<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">DROITE<\/span>(<span class=\"ex-ref\">A1<\/span> ; <span class=\"ex-num\">4<\/span>)         <span class=\"ex-cmt\">\u2190 4 derniers caract\u00e8res<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">MILIEU<\/span>(<span class=\"ex-ref\">A1<\/span> ; <span class=\"ex-num\">3<\/span> ; <span class=\"ex-num\">5<\/span>)    <span class=\"ex-cmt\">\u2190 5 caract\u00e8res \u00e0 partir du 3\u00e8me<\/span>\r\n\r\n<span class=\"ex-cmt\">NBCAR \u2014 longueur d'une cha\u00eene<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">NBCAR<\/span>(<span class=\"ex-ref\">A1<\/span>)               <span class=\"ex-cmt\">\u2190 nombre de caract\u00e8res<\/span>\r\n\r\n<span class=\"ex-cmt\">MAJUSCULE \/ MINUSCULE \/ NOMPROPRE<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">MAJUSCULE<\/span>(<span class=\"ex-ref\">A1<\/span>)           <span class=\"ex-cmt\">\u2190 TOUT EN MAJUSCULES<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">MINUSCULE<\/span>(<span class=\"ex-ref\">A1<\/span>)           <span class=\"ex-cmt\">\u2190 tout en minuscules<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">NOMPROPRE<\/span>(<span class=\"ex-ref\">A1<\/span>)           <span class=\"ex-cmt\">\u2190 Premi\u00e8re Lettre En Majuscule<\/span>\r\n\r\n<span class=\"ex-cmt\">SUPPRESPACE \u2014 supprime les espaces en trop<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">SUPPRESPACE<\/span>(<span class=\"ex-ref\">A1<\/span>)         <span class=\"ex-cmt\">\u2190 \" Jean  Dupont \" \u2192 \"Jean Dupont\"<\/span>\r\n\r\n<span class=\"ex-cmt\">CONCATENER \/ & \u2014 assembler des cha\u00eenes<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">CONCATENER<\/span>(<span class=\"ex-ref\">A1<\/span> ; <span class=\"ex-str\">\" \"<\/span> ; <span class=\"ex-ref\">B1<\/span>)\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-ref\">A1<\/span> <span class=\"ex-op\">&amp;<\/span> <span class=\"ex-str\">\" \"<\/span> <span class=\"ex-op\">&amp;<\/span> <span class=\"ex-ref\">B1<\/span>         <span class=\"ex-cmt\">\u2190 \u00e9quivalent, plus court<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">CONCAT<\/span>(<span class=\"ex-ref\">A1<\/span><span class=\"ex-op\">:<\/span><span class=\"ex-ref\">C1<\/span>)          <span class=\"ex-cmt\">\u2190 CONCAT accepte une plage (Excel 2019+)<\/span>\r\n\r\n<span class=\"ex-cmt\">CHERCHE \/ TROUVE \u2014 position d'un caract\u00e8re<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">CHERCHE<\/span>(<span class=\"ex-str\">\"@\"<\/span> ; <span class=\"ex-ref\">A1<\/span>)       <span class=\"ex-cmt\">\u2190 position de @ (insensible casse)<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">TROUVE<\/span>(<span class=\"ex-str\">\"@\"<\/span> ; <span class=\"ex-ref\">A1<\/span>)        <span class=\"ex-cmt\">\u2190 idem mais sensible \u00e0 la casse<\/span>\r\n\r\n<span class=\"ex-cmt\">SUBSTITUE \u2014 remplacer du texte<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">SUBSTITUE<\/span>(<span class=\"ex-ref\">A1<\/span> ; <span class=\"ex-str\">\"ancien\"<\/span> ; <span class=\"ex-str\">\"nouveau\"<\/span>)\r\n\r\n<span class=\"ex-cmt\">TEXTE \u2014 formater un nombre en texte<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">TEXTE<\/span>(<span class=\"ex-ref\">A1<\/span> ; <span class=\"ex-str\">\"0,00 \u20ac\"<\/span>)    <span class=\"ex-cmt\">\u2190 \"1234,5\" \u2192 \"1 234,50 \u20ac\"<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">TEXTE<\/span>(<span class=\"ex-ref\">A1<\/span> ; <span class=\"ex-str\">\"dd\/mm\/yyyy\"<\/span>) <span class=\"ex-cmt\">\u2190 date \u2192 \"15\/06\/2024\"<\/span><\/pre>\r\n        <\/div>\r\n\r\n        <p class=\"excrs__section-heading\">Cas pratique \u2014 extraire pr\u00e9nom et nom<\/p>\r\n        <div class=\"excrs__codeblock\">\r\n          <div class=\"excrs__codeblock-header\">\r\n            <div class=\"excrs__codeblock-left\">\r\n              <div class=\"excrs__win-dots\"><span class=\"excrs__dot-r\"><\/span><span class=\"excrs__dot-y\"><\/span><span class=\"excrs__dot-g\"><\/span><\/div>\r\n              <span class=\"excrs__codeblock-lang\">Excel \u2014 s\u00e9parer \"Pr\u00e9nom Nom\" en deux colonnes<\/span>\r\n            <\/div>\r\n            <button class=\"excrs__copybtn\" onclick=\"excrsCopy(this)\">\ud83d\udccb Copier<\/button>\r\n          <\/div>\r\n          <pre><span class=\"ex-cmt\">A1 contient \"Marie Dupont\" \u2014 trouver la position de l'espace<\/span>\r\n<span class=\"ex-cmt\">Position de l'espace :<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">CHERCHE<\/span>(<span class=\"ex-str\">\" \"<\/span> ; <span class=\"ex-ref\">A1<\/span>)       <span class=\"ex-cmt\">\u2192 6 (l'espace est au 6\u00e8me caract\u00e8re)<\/span>\r\n\r\n<span class=\"ex-cmt\">Extraire le pr\u00e9nom (avant l'espace) :<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">GAUCHE<\/span>(<span class=\"ex-ref\">A1<\/span> ; <span class=\"ex-fn\">CHERCHE<\/span>(<span class=\"ex-str\">\" \"<\/span> ; <span class=\"ex-ref\">A1<\/span>) <span class=\"ex-op\">-<\/span> <span class=\"ex-num\">1<\/span>)\r\n<span class=\"ex-cmt\">\u2192 \"Marie\"<\/span>\r\n\r\n<span class=\"ex-cmt\">Extraire le nom (apr\u00e8s l'espace) :<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">DROITE<\/span>(<span class=\"ex-ref\">A1<\/span> ; <span class=\"ex-fn\">NBCAR<\/span>(<span class=\"ex-ref\">A1<\/span>) <span class=\"ex-op\">-<\/span> <span class=\"ex-fn\">CHERCHE<\/span>(<span class=\"ex-str\">\" \"<\/span> ; <span class=\"ex-ref\">A1<\/span>))\r\n<span class=\"ex-cmt\">\u2192 \"Dupont\"<\/span><\/pre>\r\n        <\/div>\r\n\r\n        <div class=\"excrs__infobox excrs--info\">\r\n          <span class=\"excrs__infobox-icon\">\ud83d\udca1<\/span>\r\n          <p class=\"excrs__infobox-body\"><strong>Excel 365 \/ 2021<\/strong> : utilisez plut\u00f4t <code>=FRACTIONNER.TEXTE(A1;\" \")<\/code> qui s\u00e9pare automatiquement sur plusieurs colonnes \u2014 bien plus simple que GAUCHE\/DROITE\/CHERCHE.<\/p>\r\n        <\/div>\r\n\r\n        <div class=\"excrs__footnav\">\r\n          <button class=\"excrs__footbtn\" onclick=\"excrsShow(6)\">\u2190 Pr\u00e9c\u00e9dent<\/button>\r\n          <span class=\"excrs__footcount\">8 \/ 9<\/span>\r\n          <button class=\"excrs__footbtn\" onclick=\"excrsShow(8)\">Suivant \u2192<\/button>\r\n        <\/div>\r\n      <\/article>\r\n\r\n      <!-- \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\r\n           CH 9 \u2014 FONCTIONS DATE\r\n      \u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550\u2550 -->\r\n      <article class=\"excrs__chapter\" id=\"excrs-ch8\">\r\n        <span class=\"excrs__ch-badge\" style=\"background:#63A0E01F;color:#63AAE0;border:1px solid #63B4E040\">\ud83d\udcc5 Dates<\/span>\r\n        <h2 class=\"excrs__ch-title\">Fonctions Date et Heure<\/h2>\r\n        <p class=\"excrs__ch-intro\">Excel stocke les dates comme des nombres entiers (jours depuis le 01\/01\/1900). Comprendre ce principe permet de calculer des dur\u00e9es, des \u00e9ch\u00e9ances et d'extraire des informations temporelles.<\/p>\r\n\r\n        <div class=\"excrs__codeblock\">\r\n          <div class=\"excrs__codeblock-header\">\r\n            <div class=\"excrs__codeblock-left\">\r\n              <div class=\"excrs__win-dots\"><span class=\"excrs__dot-r\"><\/span><span class=\"excrs__dot-y\"><\/span><span class=\"excrs__dot-g\"><\/span><\/div>\r\n              <span class=\"excrs__codeblock-lang\">Excel \u2014 fonctions date essentielles<\/span>\r\n            <\/div>\r\n            <button class=\"excrs__copybtn\" onclick=\"excrsCopy(this)\">\ud83d\udccb Copier<\/button>\r\n          <\/div>\r\n          <pre><span class=\"ex-cmt\">DATE DU JOUR et MAINTENANT<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">AUJOURDHUI<\/span>()            <span class=\"ex-cmt\">\u2190 date du jour (se recalcule \u00e0 l'ouverture)<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">MAINTENANT<\/span>()            <span class=\"ex-cmt\">\u2190 date et heure actuelles<\/span>\r\n\r\n<span class=\"ex-cmt\">EXTRAIRE des composantes d'une date<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">JOUR<\/span>(<span class=\"ex-ref\">A1<\/span>)               <span class=\"ex-cmt\">\u2190 num\u00e9ro du jour (1-31)<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">MOIS<\/span>(<span class=\"ex-ref\">A1<\/span>)               <span class=\"ex-cmt\">\u2190 num\u00e9ro du mois (1-12)<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">ANNEE<\/span>(<span class=\"ex-ref\">A1<\/span>)              <span class=\"ex-cmt\">\u2190 ann\u00e9e en 4 chiffres<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">JOURSEM<\/span>(<span class=\"ex-ref\">A1<\/span> ; <span class=\"ex-num\">2<\/span>)        <span class=\"ex-cmt\">\u2190 1=Lun, 2=Mar, ... 7=Dim<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">NO.SEMAINE<\/span>(<span class=\"ex-ref\">A1<\/span> ; <span class=\"ex-num\">2<\/span>)     <span class=\"ex-cmt\">\u2190 num\u00e9ro de semaine ISO<\/span>\r\n\r\n<span class=\"ex-cmt\">CONSTRUIRE une date depuis des valeurs<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">DATE<\/span>(<span class=\"ex-num\">2024<\/span> ; <span class=\"ex-num\">12<\/span> ; <span class=\"ex-num\">31<\/span>)   <span class=\"ex-cmt\">\u2190 construit le 31\/12\/2024<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">DATE<\/span>(<span class=\"ex-fn\">ANNEE<\/span>(<span class=\"ex-ref\">A1<\/span>) ; <span class=\"ex-fn\">MOIS<\/span>(<span class=\"ex-ref\">A1<\/span>) <span class=\"ex-op\">+<\/span> <span class=\"ex-num\">1<\/span> ; <span class=\"ex-num\">1<\/span>)\r\n<span class=\"ex-cmt\">\u2190 premier jour du mois suivant<\/span>\r\n\r\n<span class=\"ex-cmt\">CALCULER des dur\u00e9es<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-ref\">B1<\/span> <span class=\"ex-op\">-<\/span> <span class=\"ex-ref\">A1<\/span>                  <span class=\"ex-cmt\">\u2190 nombre de jours entre A1 et B1<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">DATEDIF<\/span>(<span class=\"ex-ref\">A1<\/span> ; <span class=\"ex-ref\">B1<\/span> ; <span class=\"ex-str\">\"Y\"<\/span>)  <span class=\"ex-cmt\">\u2190 ann\u00e9es compl\u00e8tes entre A1 et B1<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">DATEDIF<\/span>(<span class=\"ex-ref\">A1<\/span> ; <span class=\"ex-ref\">B1<\/span> ; <span class=\"ex-str\">\"M\"<\/span>)  <span class=\"ex-cmt\">\u2190 mois complets<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">DATEDIF<\/span>(<span class=\"ex-ref\">A1<\/span> ; <span class=\"ex-ref\">B1<\/span> ; <span class=\"ex-str\">\"D\"<\/span>)  <span class=\"ex-cmt\">\u2190 jours complets<\/span>\r\n\r\n<span class=\"ex-cmt\">NB.JOURS.OUVRES \u2014 jours ouvr\u00e9s entre deux dates<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">NB.JOURS.OUVRES<\/span>(<span class=\"ex-ref\">A1<\/span> ; <span class=\"ex-ref\">B1<\/span>)\r\n<span class=\"ex-cmt\">\u2190 exclut automatiquement samedis et dimanches<\/span>\r\n\r\n<span class=\"ex-cmt\">SERIE.JOUR.OUVRE \u2014 date N jours ouvr\u00e9s plus tard<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">SERIE.JOUR.OUVRE<\/span>(<span class=\"ex-fn\">AUJOURDHUI<\/span>() ; <span class=\"ex-num\">30<\/span>)\r\n<span class=\"ex-cmt\">\u2190 date dans 30 jours ouvr\u00e9s<\/span><\/pre>\r\n        <\/div>\r\n\r\n        <p class=\"excrs__section-heading\">Cas pratiques courants<\/p>\r\n        <div class=\"excrs__codeblock\">\r\n          <div class=\"excrs__codeblock-header\">\r\n            <div class=\"excrs__codeblock-left\">\r\n              <div class=\"excrs__win-dots\"><span class=\"excrs__dot-r\"><\/span><span class=\"excrs__dot-y\"><\/span><span class=\"excrs__dot-g\"><\/span><\/div>\r\n              <span class=\"excrs__codeblock-lang\">Excel \u2014 cas pratiques dates<\/span>\r\n            <\/div>\r\n            <button class=\"excrs__copybtn\" onclick=\"excrsCopy(this)\">\ud83d\udccb Copier<\/button>\r\n          <\/div>\r\n          <pre><span class=\"ex-cmt\">\u00c2ge d'une personne (date de naissance en A1)<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">DATEDIF<\/span>(<span class=\"ex-ref\">A1<\/span> ; <span class=\"ex-fn\">AUJOURDHUI<\/span>() ; <span class=\"ex-str\">\"Y\"<\/span>) <span class=\"ex-op\">&amp;<\/span> <span class=\"ex-str\">\" ans\"<\/span>\r\n<span class=\"ex-cmt\">\u2192 \"32 ans\"<\/span>\r\n\r\n<span class=\"ex-cmt\">Retard d'une livraison (date pr\u00e9vue A1, livr\u00e9e B1)<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">SI<\/span>(<span class=\"ex-ref\">B1<\/span><span class=\"ex-op\">&gt;<\/span><span class=\"ex-ref\">A1<\/span> ; <span class=\"ex-ref\">B1<\/span><span class=\"ex-op\">-<\/span><span class=\"ex-ref\">A1<\/span> <span class=\"ex-op\">&amp;<\/span> <span class=\"ex-str\">\" jours de retard\"<\/span> ; <span class=\"ex-str\">\"Dans les d\u00e9lais\"<\/span>)\r\n\r\n<span class=\"ex-cmt\">Contrat expir\u00e9 ou actif (\u00e9ch\u00e9ance en A1)<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">SI<\/span>(<span class=\"ex-ref\">A1<\/span><span class=\"ex-op\">&lt;<\/span><span class=\"ex-fn\">AUJOURDHUI<\/span>() ; <span class=\"ex-str\">\"\u26a0 Expir\u00e9\"<\/span> ;\r\n   <span class=\"ex-fn\">SI<\/span>(<span class=\"ex-ref\">A1<\/span><span class=\"ex-op\">&lt;<\/span><span class=\"ex-fn\">AUJOURDHUI<\/span>()<span class=\"ex-op\">+<\/span><span class=\"ex-num\">30<\/span> ; <span class=\"ex-str\">\"\u23f3 Expire bient\u00f4t\"<\/span> ; <span class=\"ex-str\">\"\u2713 Actif\"<\/span>))\r\n\r\n<span class=\"ex-cmt\">Regrouper des dates par mois (pour tableaux crois\u00e9s)<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">TEXTE<\/span>(<span class=\"ex-ref\">A1<\/span> ; <span class=\"ex-str\">\"mmm yyyy\"<\/span>)      <span class=\"ex-cmt\">\u2192 \"juin 2024\"<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-fn\">TEXTE<\/span>(<span class=\"ex-ref\">A1<\/span> ; <span class=\"ex-str\">\"T\\T yyyy\"<\/span>)      <span class=\"ex-cmt\">\u2192 n\u00e9cessite un calcul de trimestre<\/span>\r\n<span class=\"ex-op\">=<\/span><span class=\"ex-str\">\"T\"<\/span> <span class=\"ex-op\">&amp;<\/span> <span class=\"ex-fn\">ENT<\/span>((<span class=\"ex-fn\">MOIS<\/span>(<span class=\"ex-ref\">A1<\/span>)<span class=\"ex-op\">-<\/span><span class=\"ex-num\">1<\/span>)<span class=\"ex-op\">\/<\/span><span class=\"ex-num\">3<\/span>)<span class=\"ex-op\">+<\/span><span class=\"ex-num\">1<\/span> <span class=\"ex-op\">&amp;<\/span> <span class=\"ex-str\">\" \"<\/span> <span class=\"ex-op\">&amp;<\/span> <span class=\"ex-fn\">ANNEE<\/span>(<span class=\"ex-ref\">A1<\/span>)\r\n<span class=\"ex-cmt\">\u2192 \"T2 2024\"<\/span><\/pre>\r\n        <\/div>\r\n\r\n        <table class=\"excrs__reftable\">\r\n          <thead><tr><th>Unit\u00e9 DATEDIF<\/th><th>Signification<\/th><\/tr><\/thead>\r\n          <tbody>\r\n            <tr><td>\"Y\"<\/td><td>Nombre d'ann\u00e9es compl\u00e8tes entre les deux dates<\/td><\/tr>\r\n            <tr><td>\"M\"<\/td><td>Nombre de mois complets<\/td><\/tr>\r\n            <tr><td>\"D\"<\/td><td>Nombre de jours<\/td><\/tr>\r\n            <tr><td>\"YM\"<\/td><td>Mois restants apr\u00e8s calcul des ann\u00e9es (pour \"X ans et Y mois\")<\/td><\/tr>\r\n            <tr><td>\"MD\"<\/td><td>Jours restants apr\u00e8s calcul des mois<\/td><\/tr>\r\n          <\/tbody>\r\n        <\/table>\r\n\r\n        <div class=\"excrs__infobox excrs--ok\">\r\n          <span class=\"excrs__infobox-icon\">\ud83c\udfc6<\/span>\r\n          <p class=\"excrs__infobox-body\"><strong>F\u00e9licitations \u2014 tu ma\u00eetrises maintenant les fonctions avanc\u00e9es Excel !<\/strong> Prochaines \u00e9tapes recommand\u00e9es : les <strong>tableaux crois\u00e9s dynamiques<\/strong> pour analyser de grands volumes de donn\u00e9es, les <strong>graphiques avanc\u00e9s<\/strong> et la <strong>mise en forme conditionnelle<\/strong> pour visualiser automatiquement les anomalies.<\/p>\r\n        <\/div>\r\n\r\n        <div class=\"excrs__footnav\">\r\n          <button class=\"excrs__footbtn\" onclick=\"excrsShow(7)\">\u2190 Pr\u00e9c\u00e9dent<\/button>\r\n          <span class=\"excrs__footcount\">9 \/ 9<\/span>\r\n          <button class=\"excrs__footbtn\" disabled>Fin du cours \ud83c\udf89<\/button>\r\n        <\/div>\r\n      <\/article>\r\n\r\n    <\/div><!-- fin .excrs__content-area -->\r\n  <\/div><!-- fin .excrs__body -->\r\n<\/div><!-- fin #excrs-root -->\r\n\r\n<script>\r\n(function() {\r\n  var excCur   = 0;\r\n  var excTotal = 9;\r\n\r\n  window.excrsShow = function(idx) {\r\n    document.getElementById('excrs-ch' + excCur).classList.remove('excrs--visible');\r\n    var oldBtn = document.querySelectorAll('.excrs__navitem')[excCur];\r\n    oldBtn.classList.remove('excrs--active');\r\n    oldBtn.removeAttribute('aria-current');\r\n\r\n    excCur = idx;\r\n\r\n    document.getElementById('excrs-ch' + excCur).classList.add('excrs--visible');\r\n    var newBtn = document.querySelectorAll('.excrs__navitem')[excCur];\r\n    newBtn.classList.add('excrs--active');\r\n    newBtn.setAttribute('aria-current', 'true');\r\n\r\n    var pct = Math.round((excCur + 1) \/ excTotal * 100);\r\n    document.getElementById('excrs-prog').style.width = pct + '%';\r\n    document.getElementById('excrs-counter').textContent = 'Chapitre ' + (excCur + 1) + ' \/ ' + excTotal;\r\n\r\n    var track = document.querySelector('.excrs__progress-track');\r\n    if (track) track.setAttribute('aria-valuenow', excCur + 1);\r\n\r\n    document.getElementById('excrs-scroll').scrollTop = 0;\r\n  };\r\n\r\n  window.excrsCopy = function(btn) {\r\n    var pre = btn.closest('.excrs__codeblock').querySelector('pre');\r\n    var text = pre.innerText || pre.textContent;\r\n    navigator.clipboard.writeText(text).then(function() {\r\n      btn.classList.add('excrs--copied');\r\n      btn.textContent = '\u2705 Copi\u00e9 !';\r\n      setTimeout(function() {\r\n        btn.classList.remove('excrs--copied');\r\n        btn.textContent = '\ud83d\udccb Copier';\r\n      }, 2000);\r\n    }).catch(function() {\r\n      var ta = document.createElement('textarea');\r\n      ta.value = text;\r\n      ta.style.cssText = 'position:fixed;opacity:0;top:0;left:0';\r\n      document.body.appendChild(ta);\r\n      ta.select();\r\n      try { document.execCommand('copy'); } catch(e) {}\r\n      document.body.removeChild(ta);\r\n      btn.textContent = '\u2705 Copi\u00e9 !';\r\n      setTimeout(function() { btn.textContent = '\ud83d\udccb Copier'; }, 2000);\r\n    });\r\n  };\r\n\r\n})();\r\n<\/script>\r\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>\u25c8 BTS CDUI \/ SIO Excel \u2014 Fonctions avanc\u00e9es \ud83d\udcca Niveau interm\u00e9diaire Chapitre 1 \/ 9 Chapitres 01Rappels essentiels 02Fonction SI 03ET \/ OU 04SI imbriqu\u00e9s 05MAX \/ MIN 06NB.SI \/ SOMME.SI 07RECHERCHEV 08Fonctions Texte 09Fonctions Date \ud83d\udcca Rappels Rappels essentiels avant de commencer Avant d&rsquo;aborder les fonctions avanc\u00e9es, voici les bases indispensables sur lesquelles [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":837,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-907","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-non-classe"],"_links":{"self":[{"href":"https:\/\/www.site-e-work.fr\/shop\/wp-json\/wp\/v2\/posts\/907","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.site-e-work.fr\/shop\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.site-e-work.fr\/shop\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.site-e-work.fr\/shop\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.site-e-work.fr\/shop\/wp-json\/wp\/v2\/comments?post=907"}],"version-history":[{"count":3,"href":"https:\/\/www.site-e-work.fr\/shop\/wp-json\/wp\/v2\/posts\/907\/revisions"}],"predecessor-version":[{"id":911,"href":"https:\/\/www.site-e-work.fr\/shop\/wp-json\/wp\/v2\/posts\/907\/revisions\/911"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.site-e-work.fr\/shop\/wp-json\/wp\/v2\/media\/837"}],"wp:attachment":[{"href":"https:\/\/www.site-e-work.fr\/shop\/wp-json\/wp\/v2\/media?parent=907"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.site-e-work.fr\/shop\/wp-json\/wp\/v2\/categories?post=907"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.site-e-work.fr\/shop\/wp-json\/wp\/v2\/tags?post=907"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}