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

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

September 17, 2021

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

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

تتحقق الدالة SIERREUR من Excel مما إذا كانت القيمة المدخلة خطأ ، ثم تقوم بإرجاع نفس القيمة إذا لم يكن هناك خطأ أو تم تحديد قيمة أخرى في حالة حدوث خطأ.

=SIERREUR(valeur, valeur_si_erreur)

حالة عملية

لنأخذ مثال وظيفة RechercheV التي تعرض عدد النقاط وفقًا لرقم الملف الذي تم إدخاله:

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

المشكلة في هذه الحالة هي أنه سيتم عرض خطأ إذا لم يتم العثور على نتائج:

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

بدون وظيفة SIERREUR، سيتعين علينا استخدام الدالة SI بالإضافة إلى وظيفة أخرى لاختبار ما إذا كانت الدالة RechercheV تُرجع خطأً وإرجاع نتيجة دالة RechercheV إذا كان كل شيء على ما يرام أو قيمة أخرى في حالة حدوث خطأ:

=SI(ESTERREUR(RECHERCHEV(E2;A2:C11;3;FAUX));"-";RECHERCHEV(E2;A2:C11;3;FAUX))

لذلك فإن الصيغة طويلة بشكل غير ضروري ووظيفة RechercheV موجودة مرتين ...

تتيح الدالة SIERREUR تبسيط كل هذا عن طريق اختبار قيمة وإرجاع هذه القيمة نفسها مباشرةً إذا لم يكن هناك خطأ (أو خطأ آخر في حالة حدوث خطأ):

=SIERREUR(RECHERCHEV(E2;A2:C11;3;FAUX);"-")

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

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

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

Comments

No comments

Post a Comment

Reading Mode :

Font Size

+

16

-

lines height

+

2

-

window['__wavt'] = 'AOuZoY69rgHoiFHIT_Tv0T3KOXDCFnwoMg:1734791159721';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d7172743834752994373','//www.practiceexcel-365.com/2021/07/practiceexecl365.html','7172743834752994373'); _WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '7172743834752994373', 'title': 'Practice Excel365 | Free Excel Courses', 'url': 'https://www.practiceexcel-365.com/2021/07/practiceexecl365.html', 'canonicalUrl': 'https://www.practiceexcel-365.com/2021/07/practiceexecl365.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': '', '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/1865959200896259949/comments/default\x22 /\x3e\n', 'meTag': '', 'adsenseClientId': 'ca-pub-6657372632750930', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': true, 'adsenseAutoAds': true, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/361ce9cf7a112c52', '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': 'X', 'key': 'twitter', 'shareMessage': 'Share to X', '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': '1865959200896259949', 'postImageThumbnailUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirOWkW0wiwIsbMi-GUPcYNpozdmV1Qh9EujfrZdI1_jf95zM6rTWcr3x5n_DhfvdB5Qtyj-VDX99Nu6Hhft_v8VpCBSvsGNV1Hfqi2rHf7mpF0PaBWF3HFLH5sZSdzPRsgZwVPqY8HLpQ/s72-c/SIERREUR+1.png', 'postImageUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirOWkW0wiwIsbMi-GUPcYNpozdmV1Qh9EujfrZdI1_jf95zM6rTWcr3x5n_DhfvdB5Qtyj-VDX99Nu6Hhft_v8VpCBSvsGNV1Hfqi2rHf7mpF0PaBWF3HFLH5sZSdzPRsgZwVPqY8HLpQ/s16000/SIERREUR+1.png', 'pageName': '\u0643\u064a\u0641\u064a\u0629 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u0627\u0644\u062f\u0627\u0644\u0629 SIERREUR \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 SIERREUR \u0641\u064a \u0627\u0644\u0627\u0643\u0633\u0644', 'metaDescription': '\u062f\u0648\u0646 \u0648\u0638\u064a\u0641\u0629 SIERREUR\u060c \u0633\u064a\u062a\u0639\u064a\u0646 \u0639\u0644\u064a\u0646\u0627 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u062f\u0627\u0644\u0629 SI \u0628\u0627\u0644\u0625\u0636\u0627\u0641\u0629 \u0625\u0644\u0649 \u0648\u0638\u064a\u0641\u0629 \u0623\u062e\u0631\u0649 \u0644\u0627\u062e\u062a\u0628\u0627\u0631 \u0645\u0627 \u0625\u0630\u0627 \u0643\u0627\u0646\u062a \u0627\u0644\u062f\u0627\u0644\u0629 RechercheV \u062a\u064f\u0631\u062c\u0639 \u062e\u0637\u0623\u064b \u0648\u0625\u0631\u062c\u0627\u0639 \u0646\u062a\u064a\u062c\u0629 \u062f\u0627\u0644\u0629 Recherch'}}, {'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 SIERREUR \u0641\u064a \u0627\u0644\u0627\u0643\u0633\u0644', 'description': '\u062f\u0648\u0646 \u0648\u0638\u064a\u0641\u0629 SIERREUR\u060c \u0633\u064a\u062a\u0639\u064a\u0646 \u0639\u0644\u064a\u0646\u0627 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u062f\u0627\u0644\u0629 SI \u0628\u0627\u0644\u0625\u0636\u0627\u0641\u0629 \u0625\u0644\u0649 \u0648\u0638\u064a\u0641\u0629 \u0623\u062e\u0631\u0649 \u0644\u0627\u062e\u062a\u0628\u0627\u0631 \u0645\u0627 \u0625\u0630\u0627 \u0643\u0627\u0646\u062a \u0627\u0644\u062f\u0627\u0644\u0629 RechercheV \u062a\u064f\u0631\u062c\u0639 \u062e\u0637\u0623\u064b \u0648\u0625\u0631\u062c\u0627\u0639 \u0646\u062a\u064a\u062c\u0629 \u062f\u0627\u0644\u0629 Recherch', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirOWkW0wiwIsbMi-GUPcYNpozdmV1Qh9EujfrZdI1_jf95zM6rTWcr3x5n_DhfvdB5Qtyj-VDX99Nu6Hhft_v8VpCBSvsGNV1Hfqi2rHf7mpF0PaBWF3HFLH5sZSdzPRsgZwVPqY8HLpQ/s16000/SIERREUR+1.png', 'url': 'https://www.practiceexcel-365.com/2021/07/practiceexecl365.html', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 1865959200896259949}}, {'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': '\u0627\u0639\u0644\u0627\u0646 \u0627\u0633\u0641\u0644 \u0627\u0644\u0642\u0627\u0626\u0645\u0629 \u0627\u0644\u0639\u0644\u0648\u064a\u0629 \u0644\u0644\u062d\u0627\u0633\u0648\u0628', 'type': 'HTML', 'sectionId': 'Topa3lan-sc', 'id': 'HTML100'}, {'title': '\u0627\u0639\u0644\u0627\u0646 \u0627\u0633\u0641\u0644 \u0627\u0644\u0642\u0627\u0626\u0645\u0629 \u0627\u0644\u0639\u0644\u0648\u064a\u0629 \u0644\u0644\u0647\u0627\u062a\u0641', 'type': 'HTML', 'sectionId': 'Topa3lan-sc2', 'id': 'HTML101'}, {'title': 'Blog Posts', 'type': 'Blog', 'sectionId': 'Tempnec', 'id': 'Blog1', 'posts': [{'id': '1865959200896259949', 'title': '\u0643\u064a\u0641\u064a\u0629 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u0627\u0644\u062f\u0627\u0644\u0629 SIERREUR \u0641\u064a \u0627\u0644\u0627\u0643\u0633\u0644', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirOWkW0wiwIsbMi-GUPcYNpozdmV1Qh9EujfrZdI1_jf95zM6rTWcr3x5n_DhfvdB5Qtyj-VDX99Nu6Hhft_v8VpCBSvsGNV1Hfqi2rHf7mpF0PaBWF3HFLH5sZSdzPRsgZwVPqY8HLpQ/s16000/SIERREUR+1.png', 'showInlineAds': false}], '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': '\u0623\u0639\u0644\u0627\u0646 \u0627\u0648\u0644 \u0627\u0644\u0645\u0648\u0636\u0648\u0639', 'type': 'HTML', 'sectionId': 'PostA3lan', 'id': 'HTML201'}, {'title': '\u0627\u0639\u0644\u0627\u0646 \u0628\u0639\u062f \u0643\u0644 \u0639\u0646\u0648\u0627\u0646 [\u0645\u062a\u0643\u0631\u0631]', 'type': 'HTML', 'sectionId': 'PostA3lan2', 'id': 'HTML222'}, {'title': '\u0627\u0639\u0644\u0627\u0646 \u0628\u0639\u062f \u0643\u0644 \u0641\u0642\u0631\u0629 [\u0645\u062a\u0643\u0631\u0631]', 'type': 'HTML', 'sectionId': 'PostA3lan2', 'id': 'HTML223'}, {'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': 'Fiver', 'type': 'HTML', 'sectionId': 'Postnw6', 'id': 'HTML3'}, {'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('_HTMLView', new _WidgetInfo('HTML100', 'Topa3lan-sc', document.getElementById('HTML100'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML101', 'Topa3lan-sc2', document.getElementById('HTML101'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'Tempnec', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/3846405171-lbx.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/1964470060-lightbox_bundle.css'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML201', 'PostA3lan', document.getElementById('HTML201'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML222', 'PostA3lan2', document.getElementById('HTML222'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML223', 'PostA3lan2', document.getElementById('HTML223'), {}, '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': 'AOuZoY4PyB8WxV6WmOQGrbIQS1Q76t8_iA:1734791159722', 'submitUrl': 'https://www.blogger.com/contact-form.do'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList4', 'sidepar', document.getElementById('LinkList4'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML3', 'Postnw6', document.getElementById('HTML3'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList2', 'footer-social', document.getElementById('LinkList2'), {}, 'displayModeFull'));