Les bases de la structuration des formules dans Microsoft Excel

Nous ne sommes pas tous des mathématiciens, mais certaines tâches dans Microsoft Excel sont mieux réalisées à l’aide de formules. …

img.wp-smiley,img.emoji{display:inline !important;border:none !important;box-shadow:none !important;height:1em !important;width:1em !important;margin:0 .07em !important;vertical-align:-.1em !important;background:none !important;padding:0 !important;}.has-text-align-justify{text-align:justify;}body{--wp--preset--color--black:#000;--wp--preset--color--cyan-bluish-gray:#abb8c3;--wp--preset--color--white:#fff;--wp--preset--color--pale-pink:#f78da7;--wp--preset--color--vivid-red:#cf2e2e;--wp--preset--color--luminous-vivid-orange:#ff6900;--wp--preset--color--luminous-vivid-amber:#fcb900;--wp--preset--color--light-green-cyan:#7bdcb5;--wp--preset--color--vivid-green-cyan:#00d084;--wp--preset--color--pale-cyan-blue:#8ed1fc;--wp--preset--color--vivid-cyan-blue:#0693e3;--wp--preset--color--vivid-purple:#9b51e0;--wp--preset--gradient--vivid-cyan-blue-to-vivid-purple:linear-gradient(135deg,rgba(6,147,227,1) 0%,#9b51e0 100%);--wp--preset--gradient--light-green-cyan-to-vivid-green-cyan:linear-gradient(135deg,#7adcb4 0%,#00d082 100%);--wp--preset--gradient--luminous-vivid-amber-to-luminous-vivid-orange:linear-gradient(135deg,rgba(252,185,0,1) 0%,rgba(255,105,0,1) 100%);--wp--preset--gradient--luminous-vivid-orange-to-vivid-red:linear-gradient(135deg,rgba(255,105,0,1) 0%,#cf2e2e 100%);--wp--preset--gradient--very-light-gray-to-cyan-bluish-gray:linear-gradient(135deg,#eee 0%,#a9b8c3 100%);--wp--preset--gradient--cool-to-warm-spectrum:linear-gradient(135deg,#4aeadc 0%,#9778d1 20%,#cf2aba 40%,#ee2c82 60%,#fb6962 80%,#fef84c 100%);--wp--preset--gradient--blush-light-purple:linear-gradient(135deg,#ffceec 0%,#9896f0 100%);--wp--preset--gradient--blush-bordeaux:linear-gradient(135deg,#fecda5 0%,#fe2d2d 50%,#6b003e 100%);--wp--preset--gradient--luminous-dusk:linear-gradient(135deg,#ffcb70 0%,#c751c0 50%,#4158d0 100%);--wp--preset--gradient--pale-ocean:linear-gradient(135deg,#fff5cb 0%,#b6e3d4 50%,#33a7b5 100%);--wp--preset--gradient--electric-grass:linear-gradient(135deg,#caf880 0%,#71ce7e 100%);--wp--preset--gradient--midnight:linear-gradient(135deg,#020381 0%,#2874fc 100%);--wp--preset--duotone--dark-grayscale:url("#wp-duotone-dark-grayscale");--wp--preset--duotone--grayscale:url("#wp-duotone-grayscale");--wp--preset--duotone--purple-yellow:url("#wp-duotone-purple-yellow");--wp--preset--duotone--blue-red:url("#wp-duotone-blue-red");--wp--preset--duotone--midnight:url("#wp-duotone-midnight");--wp--preset--duotone--magenta-yellow:url("#wp-duotone-magenta-yellow");--wp--preset--duotone--purple-green:url("#wp-duotone-purple-green");--wp--preset--duotone--blue-orange:url("#wp-duotone-blue-orange");--wp--preset--font-size--small:13px;--wp--preset--font-size--medium:20px;--wp--preset--font-size--large:36px;--wp--preset--font-size--x-large:42px;}.has-black-color{color:var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-color{color:var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-color{color:var(--wp--preset--color--white) !important;}.has-pale-pink-color{color:var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-color{color:var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-color{color:var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-color{color:var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-color{color:var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-color{color:var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-color{color:var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-color{color:var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-color{color:var(--wp--preset--color--vivid-purple) !important;}.has-black-background-color{background-color:var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-background-color{background-color:var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-background-color{background-color:var(--wp--preset--color--white) !important;}.has-pale-pink-background-color{background-color:var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-background-color{background-color:var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-background-color{background-color:var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-background-color{background-color:var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-background-color{background-color:var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-background-color{background-color:var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-background-color{background-color:var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-background-color{background-color:var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-background-color{background-color:var(--wp--preset--color--vivid-purple) !important;}.has-black-border-color{border-color:var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-border-color{border-color:var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-border-color{border-color:var(--wp--preset--color--white) !important;}.has-pale-pink-border-color{border-color:var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-border-color{border-color:var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-border-color{border-color:var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-border-color{border-color:var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-border-color{border-color:var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-border-color{border-color:var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-border-color{border-color:var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-border-color{border-color:var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-border-color{border-color:var(--wp--preset--color--vivid-purple) !important;}.has-vivid-cyan-blue-to-vivid-purple-gradient-background{background:var(--wp--preset--gradient--vivid-cyan-blue-to-vivid-purple) !important;}.has-light-green-cyan-to-vivid-green-cyan-gradient-background{background:var(--wp--preset--gradient--light-green-cyan-to-vivid-green-cyan) !important;}.has-luminous-vivid-amber-to-luminous-vivid-orange-gradient-background{background:var(--wp--preset--gradient--luminous-vivid-amber-to-luminous-vivid-orange) !important;}.has-luminous-vivid-orange-to-vivid-red-gradient-background{background:var(--wp--preset--gradient--luminous-vivid-orange-to-vivid-red) !important;}.has-very-light-gray-to-cyan-bluish-gray-gradient-background{background:var(--wp--preset--gradient--very-light-gray-to-cyan-bluish-gray) !important;}.has-cool-to-warm-spectrum-gradient-background{background:var(--wp--preset--gradient--cool-to-warm-spectrum) !important;}.has-blush-light-purple-gradient-background{background:var(--wp--preset--gradient--blush-light-purple) !important;}.has-blush-bordeaux-gradient-background{background:var(--wp--preset--gradient--blush-bordeaux) !important;}.has-luminous-dusk-gradient-background{background:var(--wp--preset--gradient--luminous-dusk) !important;}.has-pale-ocean-gradient-background{background:var(--wp--preset--gradient--pale-ocean) !important;}.has-electric-grass-gradient-background{background:var(--wp--preset--gradient--electric-grass) !important;}.has-midnight-gradient-background{background:var(--wp--preset--gradient--midnight) !important;}.has-small-font-size{font-size:var(--wp--preset--font-size--small) !important;}.has-medium-font-size{font-size:var(--wp--preset--font-size--medium) !important;}.has-large-font-size{font-size:var(--wp--preset--font-size--large) !important;}.has-x-large-font-size{font-size:var(--wp--preset--font-size--x-large) !important;}img#wpstats{display:none;}body.custom-background{background-color:#dbdbdb;}html:not( .jetpack-lazy-images-js-enabled ):not( .js ) .jetpack-lazy-image{display:none;}a{color:#386fa7;}a:hover,a:focus,.section-two .post .entry-header .entry-meta a:hover,.section-two .post .entry-header .entry-meta a:focus,.section-two .post .entry-header .entry-title a:hover,.section-two .post .entry-header .entry-title a:focus,.section-three .post .entry-header .entry-meta a:hover,.section-three .post .entry-header .entry-meta a:focus,.section-three .post .entry-header .entry-title a:hover,.section-three .post .entry-header .entry-title a:focus,.section-four .post .entry-header .entry-meta a:hover,.section-four .post .entry-header .entry-meta a:focus,.section-four .post .entry-header .entry-title a:hover,.section-four .post .entry-header .entry-title a:focus,.section-five .post .entry-meta a:hover,.section-five .post .entry-meta a:focus,.section-five .post .entry-title a:hover,.section-five .post .entry-title a:focus,.section-five .post .btn-detail a:hover,.section-five .post .btn-detail a:focus,#primary .post .entry-meta a:hover,#primary .post .entry-meta a:focus,#primary .post .entry-header .entry-title a:hover,#primary .post .entry-header .entry-title a:focus,#primary .post .entry-footer .btn-readmore:hover,#primary .post .entry-footer .btn-readmore:focus,.widget ul li a:hover,.widget ul li a:focus,.mobile-main-navigation ul li a:hover,.mobile-main-navigation ul li a:focus,.mobile-main-navigation ul li:hover > a,.mobile-main-navigation ul li:focus > a,.mobile-main-navigation ul .current-menu-item > a,.mobile-main-navigation ul .current-menu-ancestor > a,.mobile-main-navigation ul .current_page_item > a,.mobile-main-navigation ul .current_page_ancestor > a,.mobile-secondary-menu ul li a:hover,.mobile-secondary-menu ul li a:focus,.mobile-secondary-menu ul li:hover > a,.mobile-secondary-menu ul li:focus > a,.mobile-secondary-menu ul .current-menu-item > a,.mobile-secondary-menu ul .current-menu-ancestor > a,.mobile-secondary-menu ul .current_page_item > a,.mobile-secondary-menu ul .current_page_ancestor > a{color:#386fa7;}.mobile-menu .social-networks li a:hover,.mobile-menu .social-networks li a:focus{border-color:#386fa7;background:#386fa7;}.main-navigation .current_page_item > a,.main-navigation .current-menu-item > a,.main-navigation .current_page_ancestor > a,.main-navigation .current-menu-ancestor > a,.main-navigation li:hover > a,.main-navigation li.focus > a,.main-navigation ul li a:hover,.main-navigation ul li a:focus{border-top-color:#386fa7;color:#386fa7;}.main-navigation ul ul :hover > a,.main-navigation ul ul .focus > a{background:#386fa7;color:#fff;}.all-post .post .entry-title a:hover,.all-post .post .entry-title a:focus{color:#386fa7;}.section-two .header .header-title a:hover,.section-two .header .header-title a:focus,.section-three .header .header-title a:hover,.section-three .header .header-title a:focus,.videos .header .header-title a:hover,.videos .header .header-title a:focus{text-decoration:none;color:#386fa7;}.section-five .btn-holder a:before{border-color:#386fa7;background:#386fa7;}.pagination .current,.pagination a:hover,.pagination a:focus,.widget.widget_calendar caption{background:#386fa7;}#secondary .widget.widget_rss ul li a,#secondary .widget.widget_text ul li a{color:#386fa7;}.widget.widget_tag_cloud a:hover,.widget.widget_tag_cloud a:focus{background:#386fa7;}.site-header .header-t,.secondary-menu ul ul,.ticker-swipe{background:#386fa7;}.comments-area .comment-body .reply a:hover,.comments-area .comment-body .reply a:focus{background:#386fa7;border-color:#386fa7;}button,input[type="button"],input[type="reset"],input[type="submit"]{border-color:#386fa7;color:#386fa7;}button:hover,input[type="button"]:hover,input[type="reset"]:hover,input[type="submit"]:hover,button:focus,input[type="button"]:focus,input[type="reset"]:focus,input[type="submit"]:focus{background:#386fa7;border-color:#386fa7;}.widget.widget_calendar table tbody td a{background:#386fa7;}.search #primary .post .entry-header .entry-link,.search #primary .page .entry-header .entry-link{color:#386fa7;}.error404 .error-holder h1{color:#386fa7;}