Home معادلات إكسيل

كيفية استعمال الدالة OU في الاكسل

September 17, 2021

كيفية استعمال الدالة OU في الاكسل

في هذه المقالة سيتم التطرق لشرح كيفية استعمال الدالة OU والتي تعتبر من الدوال المهمة في الإكسيل.

تتحقق وظيفة OU Excel إذا كان أحد الاختبارات على الأقل هو الصحيح، لكنهل ترجع خطأفقط إذا كانت جميع الاختبارات خاطئة

.

تُستخدم هذه الوظيفة عمومًا مع وظائف أخرى كما في المثال التالي مع وظيفة SI .

=OU(test_1; test_2; etc)

مثال على الاستخدام

الهدف هنا هو التحقق مما إذا كان المستخدم مسجلاً في الدورة التدريبية 4 عن طريق اختبار ما إذا كانت قيمة خلية العمود B أو في العمود C تساوي 4:

كيفية استعمال الدالة OU في الاكسل

نبدأ بتحديد وظيفة SI وأدخل القيمة "Value_if_vrais" و "Value_if_faux":

كيفية استعمال الدالة OU في الاكسل

انقر الآن على "Logic_test" وحدد وظيفة ou من القائمة المنسدلة:

كيفية استعمال الدالة OU في الاكسل

نقوم بإكمال الاختبارات المراد إجراؤها:

كيفية استعمال الدالة OU في الاكسل

=SI(OU(B2=4;C2=4);"Inscrit";"-")

لذلك تقوم الصيغة بإرجاع "المسجل" لأن أحد الاختبارات على الأقل هو صحيح :

كيفية استعمال الدالة OU في الاكسل

ثم نقوم بتمديد الصيغة لتطبيقها على الخلايا الأخرى:

كيفية استعمال الدالة OU في الاكسل

Tags معادلات إكسيل

Latest articles from : معادلات إكسيل

Comments

No comments

Post a Comment

Reading Mode :

Font Size

+

16

-

lines height

+

2

-

window['__wavt'] = 'AOuZoY4ZCQGn5rTRoJyqhjZtDw06yhVQig:1713958689945';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d7172743834752994373','//www.practiceexcel-365.com/2021/07/fonction-excel-ou.html','7172743834752994373'); _WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '7172743834752994373', 'title': 'Practice Excel365 | Free Excel Courses', 'url': 'https://www.practiceexcel-365.com/2021/07/fonction-excel-ou.html', 'canonicalUrl': 'https://www.practiceexcel-365.com/2021/07/fonction-excel-ou.html', 'homepageUrl': 'https://www.practiceexcel-365.com/', 'searchUrl': 'https://www.practiceexcel-365.com/search', 'canonicalHomepageUrl': 'https://www.practiceexcel-365.com/', 'blogspotFaviconUrl': 'https://www.practiceexcel-365.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': true, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': 'UA-204466697-1', 'encoding': 'UTF-8', 'locale': 'en', 'localeUnderscoreDelimited': 'en', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Practice Excel365 | Free Excel Courses - Atom\x22 href\x3d\x22https://www.practiceexcel-365.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22Practice Excel365 | Free Excel Courses - RSS\x22 href\x3d\x22https://www.practiceexcel-365.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Practice Excel365 | Free Excel Courses - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/7172743834752994373/posts/default\x22 /\x3e\n\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Practice Excel365 | Free Excel Courses - Atom\x22 href\x3d\x22https://www.practiceexcel-365.com/feeds/8693070202707679137/comments/default\x22 /\x3e\n', 'meTag': '', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': true, 'adsenseAutoAds': false, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/a492d7e068c3786e', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Get link', 'key': 'link', 'shareMessage': 'Get link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Share to Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'Twitter', 'key': 'twitter', 'shareMessage': 'Share to Twitter', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Share to Pinterest', 'target': 'pinterest'}, {'name': 'Email', 'key': 'email', 'shareMessage': 'Email', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27en\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': true, 'jumpLinkMessage': 'Read more \xbb', 'pageType': 'item', 'postId': '8693070202707679137', 'postImageThumbnailUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj06UB4Z457NDIR-xRtBvC7msu3qtT55ifE3u57d0HXO8yZqAjuLK5MPM53mf_hdkL91FLEMDBf6mWkluNvwgTW-MyuLYb6WkJgncCYkIFfqwV9-WCFP1YieiSjDdaGvVkmbrqPzcuwrwQ/s72-c/OU+1.png', 'postImageUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj06UB4Z457NDIR-xRtBvC7msu3qtT55ifE3u57d0HXO8yZqAjuLK5MPM53mf_hdkL91FLEMDBf6mWkluNvwgTW-MyuLYb6WkJgncCYkIFfqwV9-WCFP1YieiSjDdaGvVkmbrqPzcuwrwQ/s16000/OU+1.png', 'pageName': '\u0643\u064a\u0641\u064a\u0629 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u0627\u0644\u062f\u0627\u0644\u0629 OU \u0641\u064a \u0627\u0644\u0627\u0643\u0633\u0644', 'pageTitle': 'Practice Excel365 | Free Excel Courses: \u0643\u064a\u0641\u064a\u0629 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u0627\u0644\u062f\u0627\u0644\u0629 OU \u0641\u064a \u0627\u0644\u0627\u0643\u0633\u0644', 'metaDescription': '\u062a\u062a\u062d\u0642\u0642 \u0648\u0638\u064a\u0641\u0629 OU Excel \u0625\u0630\u0627 \u0643\u0627\u0646 \u0623\u062d\u062f \u0627\u0644\u0627\u062e\u062a\u0628\u0627\u0631\u0627\u062a \u0639\u0644\u0649 \u0627\u0644\u0623\u0642\u0644 \u0647\u0648 \u0627\u0644\u0635\u062d\u064a\u062d\u060c \u0644\u0643\u0646\u0647\u0644 \u062a\u0631\u062c\u0639 \u062e\u0637\u0623\u0641\u0642\u0637 \u0625\u0630\u0627 \u0643\u0627\u0646\u062a \u062c\u0645\u064a\u0639 \u0627\u0644\u0627\u062e\u062a\u0628\u0627\u0631\u0627\u062a \u062e\u0627\u0637\u0626\u0629\n\n .\n\n\u062a\u064f\u0633\u062a\u062e\u062f\u0645 \u0647\u0630\u0647 \u0627\u0644\u0648\u0638\u064a\u0641\u0629 \u0639\u0645\u0648\u0645\u064b\u0627 \u0645\u0639 \u0648'}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'Edit', 'linkCopiedToClipboard': 'Link copied to clipboard!', 'ok': 'Ok', 'postLink': 'Post Link'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'Custom', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': '\u0643\u064a\u0641\u064a\u0629 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u0627\u0644\u062f\u0627\u0644\u0629 OU \u0641\u064a \u0627\u0644\u0627\u0643\u0633\u0644', 'description': '\u062a\u062a\u062d\u0642\u0642 \u0648\u0638\u064a\u0641\u0629 OU Excel \u0625\u0630\u0627 \u0643\u0627\u0646 \u0623\u062d\u062f \u0627\u0644\u0627\u062e\u062a\u0628\u0627\u0631\u0627\u062a \u0639\u0644\u0649 \u0627\u0644\u0623\u0642\u0644 \u0647\u0648 \u0627\u0644\u0635\u062d\u064a\u062d\u060c \u0644\u0643\u0646\u0647\u0644 \u062a\u0631\u062c\u0639 \u062e\u0637\u0623\u0641\u0642\u0637 \u0625\u0630\u0627 \u0643\u0627\u0646\u062a \u062c\u0645\u064a\u0639 \u0627\u0644\u0627\u062e\u062a\u0628\u0627\u0631\u0627\u062a \u062e\u0627\u0637\u0626\u0629\n\n .\n\n\u062a\u064f\u0633\u062a\u062e\u062f\u0645 \u0647\u0630\u0647 \u0627\u0644\u0648\u0638\u064a\u0641\u0629 \u0639\u0645\u0648\u0645\u064b\u0627 \u0645\u0639 \u0648', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj06UB4Z457NDIR-xRtBvC7msu3qtT55ifE3u57d0HXO8yZqAjuLK5MPM53mf_hdkL91FLEMDBf6mWkluNvwgTW-MyuLYb6WkJgncCYkIFfqwV9-WCFP1YieiSjDdaGvVkmbrqPzcuwrwQ/s16000/OU+1.png', 'url': 'https://www.practiceexcel-365.com/2021/07/fonction-excel-ou.html', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 8693070202707679137}}, {'name': 'widgets', 'data': [{'title': 'BlogArchive', 'type': 'BlogArchive', 'sectionId': 'sitting', 'id': 'BlogArchive400'}, {'title': 'BlogLabels', 'type': 'Label', 'sectionId': 'sitting', 'id': 'Label400'}, {'title': 'Pages', 'type': 'PageList', 'sectionId': 'pages', 'id': 'PageList1'}, {'title': '\u0645\u0648\u0627\u0642\u0639 \u0627\u0644\u062a\u0648\u0627\u0635\u0644 \u0627\u0644\u0625\u062c\u062a\u0645\u0627\u0639\u064a', 'type': 'LinkList', 'sectionId': 'topsocialL', 'id': 'LinkList3'}, {'title': 'Practice Excel365 | Free Excel Courses (Header)', 'type': 'Header', 'sectionId': 'logo', 'id': 'Header1'}, {'title': '\u0627\u0644\u0642\u0627\u0626\u0645\u0629 \u0627\u0644\u0631\u0626\u064a\u0633\u064a\u0629', 'type': 'LinkList', 'sectionId': 'menu', 'id': 'LinkList22'}, {'title': 'Blog Posts', 'type': 'Blog', 'sectionId': 'Tempnec', 'id': 'Blog1', 'posts': [{'id': '8693070202707679137', 'title': '\u0643\u064a\u0641\u064a\u0629 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u0627\u0644\u062f\u0627\u0644\u0629 OU \u0641\u064a \u0627\u0644\u0627\u0643\u0633\u0644', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj06UB4Z457NDIR-xRtBvC7msu3qtT55ifE3u57d0HXO8yZqAjuLK5MPM53mf_hdkL91FLEMDBf6mWkluNvwgTW-MyuLYb6WkJgncCYkIFfqwV9-WCFP1YieiSjDdaGvVkmbrqPzcuwrwQ/s16000/OU+1.png', 'showInlineAds': true}], 'headerByline': {'regionName': 'header1', 'items': [{'name': 'share', 'label': ''}, {'name': 'timestamp', 'label': '-'}]}, 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'comments', 'label': 'comments'}, {'name': 'icons', 'label': ''}]}, {'regionName': 'footer2', 'items': [{'name': 'labels', 'label': ''}]}], 'allBylineItems': [{'name': 'share', 'label': ''}, {'name': 'timestamp', 'label': '-'}, {'name': 'comments', 'label': 'comments'}, {'name': 'icons', 'label': ''}, {'name': 'labels', 'label': ''}]}, {'title': 'Contact Form', 'type': 'ContactForm', 'sectionId': 'AddOns', 'id': 'ContactForm200'}, {'title': '\u0645\u0648\u0627\u0642\u0639 \u0627\u0644\u062a\u0648\u0627\u0635\u0644 \u0627\u0644\u0625\u062c\u062a\u0645\u0627\u0639\u064a', 'type': 'LinkList', 'sectionId': 'sidepar', 'id': 'LinkList4'}, {'title': '\u0645\u0648\u0627\u0642\u0639 \u0627\u0644\u062a\u0648\u0627\u0635\u0644 \u0627\u0644\u0625\u062c\u062a\u0645\u0627\u0639\u064a', 'type': 'LinkList', 'sectionId': 'footer-social', 'id': 'LinkList2'}]}]); _WidgetManager._RegisterWidget('_BlogArchiveView', new _WidgetInfo('BlogArchive400', 'sitting', document.getElementById('BlogArchive400'), {'languageDirection': 'ltr', 'loadingMessage': 'Loading\x26hellip;'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label400', 'sitting', document.getElementById('Label400'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_PageListView', new _WidgetInfo('PageList1', 'pages', document.getElementById('PageList1'), {'title': 'Pages', 'links': [{'isCurrentPage': false, 'href': 'http://www.practiceexcel-365.com/', 'title': 'Home'}, {'isCurrentPage': false, 'href': 'https://www.practiceexcel-365.com/p/privacy-policy.html', 'id': '9039293699451073275', 'title': 'Privacy Policy'}, {'isCurrentPage': false, 'href': 'https://www.practiceexcel-365.com/p/who-are-we.html', 'id': '3848084781500635721', 'title': 'Who We Are'}, {'isCurrentPage': false, 'href': 'https://www.practiceexcel-365.com/p/contact-us.html', 'id': '5696516493396065643', 'title': 'Contact Us'}, {'isCurrentPage': false, 'href': 'https://www.practiceexcel-365.com/p/blog-page.html', 'id': '4724947008150640905', 'title': 'Frequently Asked Questions'}], 'mobile': false, 'showPlaceholder': true, 'hasCurrentPage': false}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList3', 'topsocialL', document.getElementById('LinkList3'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HeaderView', new _WidgetInfo('Header1', 'logo', document.getElementById('Header1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList22', 'menu', document.getElementById('LinkList22'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'Tempnec', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/692272730-lbx.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/13464135-lightbox_bundle.css'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_ContactFormView', new _WidgetInfo('ContactForm200', 'AddOns', document.getElementById('ContactForm200'), {'contactFormMessageSendingMsg': 'Sending...', 'contactFormMessageSentMsg': 'Your message has been sent.', 'contactFormMessageNotSentMsg': 'Message could not be sent. Please try again later.', 'contactFormInvalidEmailMsg': 'A valid email address is required.', 'contactFormEmptyMessageMsg': 'Message field cannot be empty.', 'title': 'Contact Form', 'blogId': '7172743834752994373', 'contactFormNameMsg': 'Name', 'contactFormEmailMsg': 'Email', 'contactFormMessageMsg': 'Message', 'contactFormSendMsg': 'Send', 'contactFormToken': 'AOuZoY7y7-Q9G5TVrzGphUcXcbdA4hEtig:1713958689946', 'submitUrl': 'https://www.blogger.com/contact-form.do'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList4', 'sidepar', document.getElementById('LinkList4'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList2', 'footer-social', document.getElementById('LinkList2'), {}, 'displayModeFull'));