{"id":8932,"date":"2020-09-14T16:34:27","date_gmt":"2020-09-14T12:04:27","guid":{"rendered":"https:\/\/maktabkhooneh.org\/mag\/?p=8932"},"modified":"2026-04-06T22:11:48","modified_gmt":"2026-04-06T18:41:48","slug":"most-useful-formula-inexcel","status":"publish","type":"post","link":"https:\/\/maktabkhooneh.org\/mag\/most-useful-formula-inexcel\/","title":{"rendered":"\u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u062a\u0631\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644\u200c \u0647\u0627\u06cc \u0627\u06a9\u0633\u0644"},"content":{"rendered":"\n<p><span style=\"font-size: 14px;\">\u0627\u06a9\u0633\u0644 \u0627\u0628\u0632\u0627\u0631\u06cc \u0627\u0631\u0632\u0634\u0645\u0646\u062f \u0627\u0633\u062a\u060c \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u0628\u0631\u0627\u06cc \u0633\u0631\u0639\u062a \u0628\u062e\u0634\u06cc\u062f\u0646 \u0628\u0647 \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0635\u0641\u062d\u0647 \u06af\u0633\u062a\u0631\u062f\u0647 \u0648 \u062a\u0628\u062f\u06cc\u0644 \u0634\u062f\u0646 \u0628\u0647 \u06cc\u06a9 \u0627\u0633\u062a\u0627\u062f \u0627\u06a9\u0633\u0644\u060c \u0628\u0627\u06cc\u062f \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u062a\u0631\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u0647\u0627\u06cc \u0627\u06a9\u0633\u0644 \u0631\u0627 \u0628\u0634\u0646\u0627\u0633\u06cc\u062f. \u062a\u0627 \u0628\u0647 \u062d\u0627\u0644 \u0628\u0627 \u0628\u062e\u0634\u200c\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u0648 \u0648\u06cc\u0698\u06af\u06cc\u200c\u0647\u0627\u06cc \u0645\u0641\u06cc\u062f\u06cc \u0627\u0632 \u0628\u0631\u0646\u0627\u0645\u0647 \u0627\u06a9\u0633\u0644 \u0622\u0634\u0646\u0627 \u0634\u062f\u0647\u200c\u0627\u06cc\u062f \u0648 \u0627\u06a9\u0646\u0648\u0646 \u0648\u0642\u062a \u0622\u0646 \u0627\u0633\u062a \u06a9\u0647 \u0645\u0641\u06cc\u062f\u062a\u0631\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627 \u0631\u0627 \u062f\u0631 \u0646\u0631\u0645\u200c\u0627\u0641\u0632\u0627\u0631 \u0627\u06a9\u0634 \u0628\u0634\u0646\u0627\u0633\u06cc\u062f. \u0627\u06a9\u0633\u0644 \u0627\u0628\u0632\u0627\u0631\u06cc \u0627\u0631\u0632\u0634\u0645\u0646\u062f \u0627\u0633\u062a \u0632\u06cc\u0631\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0645\u062d\u0633\u0628\u0627\u062a \u0631\u06cc\u0627\u0636\u06cc \u0632\u06cc\u0627\u062f\u06cc \u0631\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u062e\u0648\u062f\u06a9\u0627\u0631 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u062f. \u0634\u0631\u062d \u0645\u0641\u06cc\u062f\u062a\u0631\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627 \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/span><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u062a\u0639\u0631\u06cc\u0641 \u062a\u0627\u0628\u0639 \u0648 \u0641\u0631\u0645\u0648\u0644\u200c \u0647\u0627\u06cc \u0627\u06a9\u0633\u0644<\/h2>\n\n\n\n<p>\u062f\u0631 \u0627\u06a9\u0633\u0644\u060c \u062a\u0648\u0627\u0628\u0639 \u0648 \u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627 \u0627\u0628\u0632\u0627\u0631\u0647\u0627\u06cc \u0642\u062f\u0631\u062a\u0645\u0646\u062f\u06cc \u0647\u0633\u062a\u0646\u062f \u06a9\u0647 \u0628\u0647 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0627\u06cc\u0646 \u0627\u0645\u06a9\u0627\u0646 \u0631\u0627 \u0645\u06cc\u200c\u062f\u0647\u0646\u062f \u062a\u0627 \u0645\u062d\u0627\u0633\u0628\u0627\u062a \u067e\u06cc\u0686\u06cc\u062f\u0647 \u0631\u0627 \u0628\u0647 \u0631\u0627\u062d\u062a\u06cc \u0648 \u062f\u0642\u062a \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u0646\u062f. \u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627 \u0634\u0627\u0645\u0644 \u0645\u062c\u0645\u0648\u0639\u0647\u200c\u0627\u06cc \u0627\u0632 \u0645\u0642\u0627\u062f\u06cc\u0631\u060c \u0645\u062a\u063a\u06cc\u0631\u0647\u0627 \u0648 \u0639\u0645\u0644\u06af\u0631\u0647\u0627 \u0647\u0633\u062a\u0646\u062f \u06a9\u0647 \u0628\u0627 \u06cc\u06a9\u062f\u06cc\u06af\u0631 \u062a\u0631\u06a9\u06cc\u0628 \u0645\u06cc\u200c\u0634\u0648\u0646\u062f \u062a\u0627 \u0646\u062a\u06cc\u062c\u0647\u200c\u0627\u06cc \u0645\u0634\u062e\u0635 \u062a\u0648\u0644\u06cc\u062f \u06a9\u0646\u0646\u062f. \u062a\u0648\u0627\u0628\u0639 \u0628\u0647 \u0637\u0648\u0631 \u067e\u06cc\u0634\u200c\u0641\u0631\u0636 \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0645\u0648\u062c\u0648\u062f \u0647\u0633\u062a\u0646\u062f \u0648 \u0628\u0647 \u06a9\u0627\u0631\u0628\u0631 \u0627\u06cc\u0646 \u0627\u0645\u06a9\u0627\u0646 \u0631\u0627 \u0645\u06cc\u200c\u062f\u0647\u0646\u062f \u06a9\u0647 \u0627\u0646\u0648\u0627\u0639 \u0645\u062d\u0627\u0633\u0628\u0627\u062a \u0631\u06cc\u0627\u0636\u06cc\u060c \u0645\u0646\u0637\u0642\u06cc\u060c \u0645\u062a\u0646\u06cc \u0648 \u062a\u0627\u0631\u06cc\u062e \u0631\u0627 \u0628\u0627 \u0633\u0631\u0639\u062a \u0648 \u062f\u0642\u062a \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u0646\u062f.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u062a\u0627\u0628\u0639 \u0648 \u0641\u0631\u0645\u0648\u0644\u200c \u0647\u0627\u06cc \u0627\u06a9\u0633\u0644 \u067e\u0631 \u06a9\u0627\u0631\u0628\u0631\u062f<\/h2>\n\n\n<div class=\"jet-listing-grid--50192\" style=\"\"><style><\/style><section class=\"zht-related-post\" itemscope=\"\" itemtype=\"https:\/\/schema.org\/Article\" role=\"region\"\n  aria-label=\"Related article\">\n  <div class=\"zht-related-post-section-label\">\n    \u0645\u0637\u0627\u0644\u0628 \u0645\u0631\u062a\u0628\u0637\n  <\/div>\n  <img fetchpriority=\"high\" decoding=\"async\" width=\"300\" height=\"169\" src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2020\/08\/\u0641\u0631\u0645\u0648\u0644-\u0646\u0648\u06cc\u0633\u06cc-\u062f\u0631-\u0627\u06a9\u0633\u0644-3-300x169.jpg.webp\" class=\"attachment-medium size-medium wp-post-image\" alt=\"\u0641\u0631\u0645\u0648\u0644 \u0646\u0648\u06cc\u0633\u06cc \u062f\u0631 \u0627\u06a9\u0633\u0644\" srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2020\/08\/\u0641\u0631\u0645\u0648\u0644-\u0646\u0648\u06cc\u0633\u06cc-\u062f\u0631-\u0627\u06a9\u0633\u0644-3-300x169.jpg.webp 300w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2020\/08\/\u0641\u0631\u0645\u0648\u0644-\u0646\u0648\u06cc\u0633\u06cc-\u062f\u0631-\u0627\u06a9\u0633\u0644-3-768x432.jpg.webp 768w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2020\/08\/\u0641\u0631\u0645\u0648\u0644-\u0646\u0648\u06cc\u0633\u06cc-\u062f\u0631-\u0627\u06a9\u0633\u0644-3.jpg 1000w\" sizes=\"(max-width: 300px) 100vw, 300px\" title=\"\">\n  <a href=\"https:\/\/maktabkhooneh.org\/mag\/formula-writing-in-excel\/\" class=\"zht-related-post-title\"\n    itemprop=\"headline\" target=\"_blank\">\u0641\u0631\u0645\u0648\u0644 \u0646\u0648\u06cc\u0633\u06cc \u062f\u0631 \u0627\u06a9\u0633\u0644<\/a>\n<\/section><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span style=\"font-size: 14px;\">\u062c\u0645\u0639 (SUM):<\/span><\/h2>\n\n\n\n<h2 class=\"wp-block-heading\"><span style=\"font-size: 14px;\">&nbsp;\u0645\u062a\u0648\u0633\u0637(AVERAGE) \u0627\u0632 \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u062a\u0631\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u0647\u0627\u06cc \u0627\u06a9\u0633\u0644<\/span><\/h2>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"1377\" height=\"633\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2020\/09\/Excel-2016-SUM-formula-with-six-parameters.png\" alt=\"\u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u062a\u0631\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u0647\u0627\u06cc \u0627\u06a9\u0633\u0644\" class=\"wp-image-8933 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2020\/09\/Excel-2016-SUM-formula-with-six-parameters.png 1377w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2020\/09\/Excel-2016-SUM-formula-with-six-parameters-300x138.png.webp 300w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2020\/09\/Excel-2016-SUM-formula-with-six-parameters-1024x471.png.webp 1024w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2020\/09\/Excel-2016-SUM-formula-with-six-parameters-768x353.png.webp 768w\" data-sizes=\"(max-width: 1377px) 100vw, 1377px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1377px; --smush-placeholder-aspect-ratio: 1377\/633;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p><span style=\"font-size: 14px;\"><\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">SUM \u0628\u0647 \u0634\u0645\u0627 \u0627\u06cc\u0646 \u0627\u0645\u06a9\u0627\u0646 \u0631\u0627 \u0645\u06cc\u200c\u062f\u0647\u062f \u06a9\u0647 \u0647\u0631 \u062a\u0639\u062f\u0627\u062f \u0633\u062a\u0648\u0646 \u06cc\u0627 \u0631\u062f\u06cc\u0641 \u0631\u0627 \u0628\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u0622\u0646 \u06cc\u0627 \u062a\u0627\u06cc\u067e \u06a9\u0631\u062f\u0646 \u0622\u0646\u0647\u0627 \u062c\u0645\u0639 \u06a9\u0646\u06cc\u062f\u060c \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644:<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">= SUM (A1: A8<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">\u062a\u0645\u0627\u0645 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0631\u0627 \u0628\u06cc\u0646 A1 \u0648 A8 \u0648 \u063a\u06cc\u0631\u0647 \u062c\u0645\u0639 \u0645\u06cc \u06a9\u0646\u062f.<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">COUNT \u062a\u0639\u062f\u0627\u062f \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u06cc\u06a9 \u0622\u0631\u0627\u06cc\u0647 \u0631\u0627 \u06a9\u0647 \u0645\u0642\u062f\u0627\u0631 \u0639\u062f\u062f\u06cc \u062f\u0631 \u0622\u0646\u200c\u0647\u0627 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u0631\u0627\u060c \u0645\u062d\u0627\u0633\u0628\u0647 \u0645\u06cc\u200c\u06a9\u0646\u062f. \u0627\u06cc\u0646 \u0628\u0631\u0627\u06cc \u062a\u0639\u06cc\u06cc\u0646 \u0627\u06cc\u0646\u06a9\u0647 \u0622\u06cc\u0627 \u06a9\u0633\u06cc \u067e\u0648\u0644 \u067e\u0631\u062f\u0627\u062e\u062a \u06a9\u0631\u062f\u0647 \u0627\u0633\u062a \u06cc\u0627 \u062f\u0631 \u0633\u0627\u06cc\u0631 \u0634\u0631\u0627\u06cc\u0637 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0645\u0641\u06cc\u062f \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f.<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">AVERAGE \u0647\u0645\u0627\u0646\u0637\u0648\u0631 \u06a9\u0647 \u0627\u0632 \u0627\u0633\u0645\u0634 \u067e\u06cc\u062f\u0627\u0633\u062a \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u0627\u0639\u062f\u0627\u062f\u06cc \u0631\u0627 \u06a9\u0647 \u0648\u0627\u0631\u062f \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f \u0645\u06cc\u200c\u06af\u06cc\u0631\u062f.<\/span><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span style=\"font-size: 14px;\">\u0636\u0631\u0628(Multiplication) \u062f\u0631 \u0627\u06a9\u0633\u0644<\/span><\/h4>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"931\" height=\"875\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2020\/09\/8XRru.png\" alt=\"\u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u062a\u0631\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u0647\u0627\u06cc \u0627\u06a9\u0633\u0644\" class=\"wp-image-8934 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2020\/09\/8XRru.png 931w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2020\/09\/8XRru-300x282.png.webp 300w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2020\/09\/8XRru-768x722.png.webp 768w\" data-sizes=\"(max-width: 931px) 100vw, 931px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 931px; --smush-placeholder-aspect-ratio: 931\/875;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p><span style=\"font-size: 14px;\"><\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u0641\u0631\u0645\u0648\u0644 \u0636\u0631\u0628 \u062f\u0631 \u0627\u06a9\u0633\u0644\u060c \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc\u06cc \u0631\u0627 \u06a9\u0647 \u062f\u0631 \u0642\u0627\u0644\u0628 \u0636\u0631\u0628 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f :<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">= A1 * B1<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">\u062f\u0631 \u0627\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u0627\u0632 \u0633\u062a\u0627\u0631\u0647 \u0628\u0631\u0627\u06cc \u0636\u0631\u0628 \u0633\u0644\u0648\u0644 A1 \u062f\u0631 \u0633\u0644\u0648\u0644 B1 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644\u060c \u0627\u06af\u0631 A1 10 \u0648 B1 6 \u0628\u0648\u062f \u060c = A1 * B1 \u0645\u0642\u062f\u0627\u0631 \u06f6\u06f0 \u0631\u0627 \u0646\u0634\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f.<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0628\u0631\u0627\u06cc \u0636\u0631\u0628 \u062f\u0648 \u06cc\u0627 \u0686\u0646\u062f \u0645\u0642\u062f\u0627\u0631 \u062f\u0631 \u0635\u0641\u062d\u0647 \u06af\u0633\u062a\u0631\u062f\u0647 \u0627\u06a9\u0633\u0644\u060c \u06cc\u06a9 \u0633\u0644\u0648\u0644 \u062e\u0627\u0644\u06cc \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f. \u0633\u067e\u0633\u060c \u0645\u0642\u0627\u062f\u06cc\u0631 \u06cc\u0627 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc\u06cc \u0631\u0627 \u06a9\u0647 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u062f\u0631 \u0642\u0627\u0644\u0628 \u0636\u0631\u0628 \u06a9\u0646\u06cc \u060c \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f :<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">= A1 * B1 * C1 &#8230; \u0648<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0633\u062a\u0627\u0631\u0647 \u0628\u0647 \u0637\u0648\u0631 \u0645\u0648\u062b\u0631 \u0647\u0631 \u0645\u0642\u062f\u0627\u0631 \u0645\u0648\u062c\u0648\u062f \u062f\u0631 \u0641\u0631\u0645\u0648\u0644 \u0631\u0627 \u0636\u0631\u0628 \u0645\u06cc\u200c\u06a9\u0646\u062f.<\/span><\/p>\n\n\n<div class=\"jet-listing-grid--50192\" style=\"\"><section class=\"zht-related-post\" itemscope=\"\" itemtype=\"https:\/\/schema.org\/Article\" role=\"region\"\n  aria-label=\"Related article\">\n  <div class=\"zht-related-post-section-label\">\n    \u0645\u0637\u0627\u0644\u0628 \u0645\u0631\u062a\u0628\u0637\n  <\/div>\n  <img decoding=\"async\" width=\"300\" height=\"300\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2020\/09\/Microsoft-Excel-300x300.jpeg.webp\" class=\"attachment-medium size-medium wp-post-image lazyload\" alt=\"\u0645\u062e\u0641\u06cc \u06a9\u0631\u062f\u0646 \u0633\u0637\u0631 \u0648 \u0633\u062a\u0648\u0646 \u062f\u0631 \u0627\u06a9\u0633\u0644\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2020\/09\/Microsoft-Excel-300x300.jpeg.webp 300w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2020\/09\/Microsoft-Excel-1024x1024.jpeg.webp 1024w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2020\/09\/Microsoft-Excel-150x150.jpeg.webp 150w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2020\/09\/Microsoft-Excel-768x768.jpeg.webp 768w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2020\/09\/Microsoft-Excel.jpeg 1200w\" data-sizes=\"(max-width: 300px) 100vw, 300px\" title=\"\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 300px; --smush-placeholder-aspect-ratio: 300\/300;\">\n  <a href=\"https:\/\/maktabkhooneh.org\/mag\/hiding-rows-and-column-in-excel\/\" class=\"zht-related-post-title\"\n    itemprop=\"headline\" target=\"_blank\">\u0645\u062e\u0641\u06cc \u06a9\u0631\u062f\u0646 \u0633\u0637\u0631 \u0648 \u0633\u062a\u0648\u0646 \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0648 \u0631\u0648\u0634\u200c\u0647\u0627\u06cc \u0622\u0646<\/a>\n<\/section><\/div>\n\n\n<h4 class=\"wp-block-heading\"><span style=\"font-size: 14px;\">\u062a\u0642\u0633\u06cc\u0645(Division)<\/span><\/h4>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u0641\u0631\u0645\u0648\u0644 \u062a\u0642\u0633\u06cc\u0645 \u062f\u0631 \u0627\u06a9\u0633\u0644\u060c \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc\u06cc \u0631\u0627 \u06a9\u0647 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u062a\u0642\u0633\u06cc\u0645 \u06a9\u0646\u06cc\u062f \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f:<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">= A1 \/ B1<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0627\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u0628\u0631\u0627\u06cc \u062a\u0642\u0633\u06cc\u0645 \u0633\u0644\u0648\u0644 A1 \u0628\u0647 \u0633\u0644\u0648\u0644 B1 \u0627\u0632 \u06cc\u06a9 \u0628\u0631\u0634 \u0631\u0648 \u0628\u0647 \u062c\u0644\u0648\u060c &#8220;\/&#8221; \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u06a9\u0646\u062f.\u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644\u060c \u0627\u06af\u0631 A1 5 \u0648 B1 10 \u0628\u0627\u0634\u062f\u060c = A1 \/ B1 \u0645\u0642\u062f\u0627\u0631 \u0627\u0639\u0634\u0627\u0631\u06cc \u06f0\u066b\u06f5 \u0631\u0627 \u0646\u0634\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f.<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">\u062a\u0642\u0633\u06cc\u0645 \u062f\u0631 \u0627\u06a9\u0633\u0644 \u06cc\u06a9\u06cc \u0627\u0632 \u0633\u0627\u062f\u0647\u200c\u062a\u0631\u06cc\u0646 \u06a9\u0627\u0631\u0647\u0627\u06cc\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u062f. \u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u0627\u06cc\u0646 \u06a9\u0627\u0631\u060c \u06cc\u06a9 \u0633\u0644\u0648\u0644 \u062e\u0627\u0644\u06cc \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f\u060c \u06cc\u06a9 \u0639\u0644\u0627\u0645\u062a \u0628\u0631\u0627\u0628\u0631 \u0628\u0627 &#8220;=&#8221; \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f \u0648 \u0622\u0646 \u0631\u0627 \u0628\u0627 \u062f\u0648 \u0645\u0642\u062f\u0627\u0631\u06cc (\u06cc\u0627 \u0628\u06cc\u0634\u062a\u0631) \u06a9\u0647 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u0628\u0627 \u06cc\u06a9 \u0628\u0631\u0634 \u0631\u0648 \u0628\u0647 \u062c\u0644\u0648\u060c &#8220;\/&#8221; \u062f\u0631 \u0645\u06cc\u0627\u0646 \u062a\u0642\u0633\u06cc\u0645 \u06a9\u0646\u06cc\u062f. \u0646\u062a\u06cc\u062c\u0647 \u0628\u0627\u06cc\u062f \u062f\u0631 \u0642\u0627\u0644\u0628 \u0632\u06cc\u0631 \u0628\u0627\u0634\u062f:<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">= B2 \/ A2<\/span><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span style=\"font-size: 14px;\">\u0639\u0645\u0644\u06a9\u0631\u062f Not<\/span><\/h4>\n\n\n\n<p><span style=\"font-size: 14px;\">\u062a\u0627 \u0628\u0647 \u062d\u0627\u0644 \u062f\u0631 \u06cc\u06a9 \u0644\u06cc\u0633\u062a \u0648\u0627\u0642\u0639\u0627\u064b \u0637\u0648\u0644\u0627\u0646\u06cc \u0627\u0632 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062c\u0633\u062a\u062c\u0648 \u06a9\u0631\u062f\u0647\u200c\u0627\u06cc\u062f \u0648 \u0622\u0631\u0632\u0648 \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0628\u062a\u0648\u0627\u0646\u06cc\u062f \u062a\u0645\u0627\u0645 \u0648\u0631\u0648\u062f\u06cc\u200c\u0647\u0627\u06cc\u06cc \u0631\u0627 \u06a9\u0647 \u0627\u0639\u0645\u0627\u0644 \u0646\u0645\u06cc\u200c\u0634\u0648\u0646\u062f \u062d\u0630\u0641 \u06a9\u0646\u06cc\u062f\u061f \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644\u060c \u0645\u0646 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u0645 \u0647\u0645\u0647 \u0686\u06cc\u0632 \u062f\u0631 \u0645\u0648\u0631\u062f \u0627\u0646\u0631\u0698\u06cc \u062c\u0627\u06cc\u06af\u0632\u06cc\u0646 \u0628\u0647 \u062c\u0632 \u0647\u0633\u062a\u0647 \u0627\u06cc (\u06cc\u0627 \u0646\u0647) \u0645\u0648\u062c\u0648\u062f \u0631\u0627 \u0628\u0628\u06cc\u0646\u0645.<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">\u062f\u0631 \u0627\u06a9\u0633\u0644\u060c \u0627\u06cc\u0646 \u06cc\u06a9 \u06a9\u0627\u0631 \u0622\u0633\u0627\u0646 \u0627\u0633\u062a. \u0644\u06cc\u0633\u062a\u06cc \u0627\u0632 \u0686\u0646\u062f \u0634\u0631\u06a9\u062a\u06cc \u06a9\u0647 \u062f\u0627\u0631\u0627\u06cc \u0645\u0646\u0627\u0628\u0639 \u0645\u062e\u062a\u0644\u0641 \u0627\u0646\u0631\u0698\u06cc \u0631\u0627 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc\u200c\u062f\u0647\u0646\u062f \u062a\u0647\u06cc\u0647 \u06a9\u0646\u06cc\u062f \u0648 \u0627\u06cc\u0646\u06a9\u0647 \u0627\u06cc\u0646 \u0645\u0646\u0627\u0628\u0639 \u0686\u0647 \u0647\u0633\u062a\u0646\u062f (\u0633\u062a\u0648\u0646 \u0647\u0627\u06cc A \u060c B \u060c C \u061b \u0627\u0632 \u0631\u062f\u06cc\u0641 \u06f4 \u0634\u0631\u0648\u0639 \u0645\u06cc \u0634\u0648\u062f). \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0631\u0627 \u062f\u0631 \u0633\u0644\u0648\u0644 C4 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f:<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\"><strong>=NOT(B4=&#8221;<\/strong><strong>\u0647\u0633\u062a\u0647\u200c\u0627\u06cc<\/strong><strong>&#8220;)<\/strong>.<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0633\u067e\u0633 \u0641\u0631\u0645\u0648\u0644 \u0631\u0627 \u0627\u0632 C4 \u0628\u0647 C5: C28 \u06a9\u067e\u06cc \u06a9\u0646\u06cc\u062f.<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0627\u06af\u0631 \u067e\u0627\u0633\u062e \u062f\u0631\u0633\u062a \u0628\u0627\u0634\u062f\u060c \u0645\u0646\u0628\u0639 \u0627\u0646\u0631\u0698\u06cc \u0647\u0633\u062a\u0647\u200c\u0627\u06cc \u0646\u06cc\u0633\u062a. \u0627\u06af\u0631 \u067e\u0627\u0633\u062e \u0646\u0627\u062f\u0631\u0633\u062a \u0628\u0627\u0634\u062f\u060c \u0645\u0646\u0628\u0639 \u0627\u0646\u0631\u0698\u06cc \u0647\u0633\u062a\u0647\u200c\u0627\u06cc \u0627\u0633\u062a. \u0628\u0644\u0647\u060c \u067e\u0627\u0633\u062e \u0645\u0639\u06a9\u0648\u0633 \u0627\u0633\u062a \u0648 \u0634\u0645\u0627 \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0628\u0644\u0627\u0641\u0627\u0635\u0644\u0647 \u0646\u06cc\u0627\u0632\u06cc \u0628\u0647 \u0627\u06cc\u0646 \u0639\u0645\u0644\u06a9\u0631\u062f \u0646\u0628\u06cc\u0646\u06cc\u062f\u060c \u0627\u0645\u0627 \u0627\u06af\u0631 \u06a9\u0627\u0631\u0628\u0631 \u0645\u0634\u062a\u0627\u0642 \u0627\u06a9\u0633\u0644 \u0628\u0627\u0634\u06cc\u062f\u060c \u062f\u0644\u0627\u06cc\u0644 \u0632\u06cc\u0627\u062f\u06cc \u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u062f\u0631 \u0622\u06cc\u0646\u062f\u0647 \u062e\u0648\u0627\u0647\u06cc\u062f \u06cc\u0627\u0641\u062a.<\/span><\/p>\n\n\n<div class=\"jet-listing-grid--50192\" style=\"\"><section class=\"zht-related-post\" itemscope=\"\" itemtype=\"https:\/\/schema.org\/Article\" role=\"region\"\n  aria-label=\"Related article\">\n  <div class=\"zht-related-post-section-label\">\n    \u0645\u0637\u0627\u0644\u0628 \u0645\u0631\u062a\u0628\u0637\n  <\/div>\n  <img decoding=\"async\" width=\"300\" height=\"240\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2020\/09\/81744_6857_8-300x240.jpg.webp\" class=\"attachment-medium size-medium wp-post-image lazyload\" alt=\"\u062a\u0627\u0628\u0639 Match \u062f\u0631 \u0627\u06a9\u0633\u0644 \u062a\u0627\u0628\u0639 Index\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2020\/09\/81744_6857_8-300x240.jpg.webp 300w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2020\/09\/81744_6857_8-768x614.jpg.webp 768w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2020\/09\/81744_6857_8.jpg 1000w\" data-sizes=\"(max-width: 300px) 100vw, 300px\" title=\"\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 300px; --smush-placeholder-aspect-ratio: 300\/240;\">\n  <a href=\"https:\/\/maktabkhooneh.org\/mag\/match-function-in-excel\/\" class=\"zht-related-post-title\"\n    itemprop=\"headline\" target=\"_blank\">\u06a9\u0627\u0631 \u0628\u0627 \u062a\u0627\u0628\u0639 Match \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0628\u0647 \u0632\u0628\u0627\u0646 \u0633\u0627\u062f\u0647<\/a>\n<\/section><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span style=\"font-size: 14px;\">\u062a\u0627\u0628\u0639 \u0634\u0631\u0637\u06cc (IF) \u06cc\u06a9\u06cc \u0627\u0632 \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u062a\u0631\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u0647\u0627\u06cc \u0627\u06a9\u0633\u0644<\/span><\/h2>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0639\u0628\u0627\u0631\u0627\u062a IF \u062f\u0631 \u0628\u0633\u06cc\u0627\u0631\u06cc \u0627\u0632 \u0645\u0648\u0627\u0631\u062f \u0628\u0633\u06cc\u0627\u0631 \u0645\u0641\u06cc\u062f \u0647\u0633\u062a\u0646\u062f \u0648 \u0627\u06cc\u0646 \u0639\u0645\u0644\u06a9\u0631\u062f \u0628\u0647 \u0634\u0645\u0627 \u0627\u0645\u06a9\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f \u062f\u0631 \u0635\u0648\u0631\u062a \u0645\u0639\u062a\u0628\u0631 \u06cc\u0627 \u0646\u0627\u062f\u0631\u0633\u062a \u0628\u0648\u062f\u0646 \u0645\u062a\u0646\u060c \u0645\u062a\u0646 \u0631\u0627 \u062e\u0627\u0631\u062c \u06a9\u0646\u06cc\u062f. \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644 \u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f:<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">= IF (A1&gt; A2 \u060c &#8220;GOOD&#8221; \u060c &#8220;BAD&#8221;)<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">\u062f\u0631 \u0627\u06cc\u0646 \u062d\u0627\u0644\u062a A1&gt; A2 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u060c &#8220;GOOD&#8221; \u062f\u0631 \u0635\u0648\u0631\u062a \u062f\u0631\u0633\u062a \u0628\u0648\u062f\u0646\u060c \u062e\u0631\u0648\u062c\u06cc \u0648 &#8220;BAD \u062f\u0631 \u0635\u0648\u0631\u062a \u0646\u0627\u062f\u0631\u0633\u062a \u0628\u0648\u062f\u0646\u060c \u062e\u0631\u0648\u062c\u06cc \u0627\u0633\u062a.<\/span><\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"1912\" height=\"1012\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2020\/09\/entering-data-with-if-function-3123603-2-5bf19dd646e0fb00267d033b-1.jpg\" alt=\"\u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u062a\u0631\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u0647\u0627\u06cc \u0627\u06a9\u0633\u0644\" class=\"wp-image-8935 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2020\/09\/entering-data-with-if-function-3123603-2-5bf19dd646e0fb00267d033b-1.jpg 1912w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2020\/09\/entering-data-with-if-function-3123603-2-5bf19dd646e0fb00267d033b-1-300x159.jpg 300w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2020\/09\/entering-data-with-if-function-3123603-2-5bf19dd646e0fb00267d033b-1-1024x542.jpg.webp 1024w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2020\/09\/entering-data-with-if-function-3123603-2-5bf19dd646e0fb00267d033b-1-768x406.jpg.webp 768w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2020\/09\/entering-data-with-if-function-3123603-2-5bf19dd646e0fb00267d033b-1-1536x813.jpg 1536w\" data-sizes=\"(max-width: 1912px) 100vw, 1912px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1912px; --smush-placeholder-aspect-ratio: 1912\/1012;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p><span style=\"font-size: 14px;\"><\/span><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span style=\"font-size: 14px;\">SUMIF \u060c COUNTIF \u060c AVERAGEIF<\/span><\/h4>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0627\u06cc\u0646 \u062a\u0648\u0627\u0628\u0639 \u062a\u0631\u06a9\u06cc\u0628\u06cc \u0627\u0632 \u062a\u0648\u0627\u0628\u0639 SUM \u060c COUNT \u060c AVERAGE \u0628\u0627 \u067e\u06cc\u0648\u0633\u062a \u0628\u0647 \u0639\u0628\u0627\u0631\u0627\u062a IF \u0647\u0633\u062a\u0646\u062f. \u0633\u0627\u062e\u062a\u0627\u0631 \u0647\u0645\u0647 \u0627\u06cc\u0646 \u062a\u0648\u0627\u0628\u0639 \u0628\u0647 \u06cc\u06a9 \u0634\u06a9\u0644 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc\u200c\u0634\u0648\u062f:<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">= FUNCTION (\u062f\u0627\u0645\u0646\u0647 \u060c \u0645\u0639\u06cc\u0627\u0631\u0647\u0627 \u060c \u062f\u0627\u0645\u0646\u0647 \u0639\u0645\u0644\u06a9\u0631\u062f)<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u062f\u0631 SUM \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f:<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">SUM (A1: A15\u060c &#8220;GOOD&#8221;\u060c B1: B13)<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0627\u06af\u0631 \u0645\u0642\u0627\u062f\u06cc\u0631 A1 \u062a\u0627 A15 \u0647\u0645\u0647 \u062e\u0648\u0628 \u0628\u0627\u0634\u0646\u062f\u060c \u0627\u06cc\u0646 B1 \u062a\u0627 B13 \u0631\u0627 \u0627\u0636\u0627\u0641\u0647 \u0645\u06cc\u200c\u06a9\u0646\u062f.<\/span><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span style=\"font-size: 14px;\">\u062d\u062f\u0627\u06a9\u062b\u0631(MAX) \u0648 \u062d\u062f\u0627\u0642\u0644(MIN)<\/span><\/h4>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0627\u06cc\u0646 \u062a\u0648\u0627\u0628\u0639 \u0628\u0633\u06cc\u0627\u0631 \u0633\u0627\u062f\u0647 \u0647\u0633\u062a\u0646 \u060c \u06a9\u0627\u0641\u06cc\u0633\u062a \u0633\u062a\u0648\u0646 \u06cc\u0627 \u0631\u062f\u06cc\u0641 \u0627\u0639\u062f\u0627\u062f\u06cc \u06a9\u0647 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f \u062a\u0627 \u062a\u0627\u06cc\u067e \u0634\u0648\u0646\u062f \u0648 \u0628\u0633\u062a\u0647 \u0628\u0647 \u0639\u0645\u0644\u06a9\u0631\u062f\u06cc \u06a9\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f\u060c MAX \u06cc\u0627 MIN \u062a\u0648\u0644\u06cc\u062f \u0645\u06cc\u200c\u0634\u0648\u062f. \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">= MAX (A1: A10)<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">\u062d\u062f\u0627\u06a9\u062b\u0631 \u0645\u0642\u062f\u0627\u0631 \u0639\u062f\u062f\u06cc \u0631\u0627 \u062f\u0631 \u0622\u0646 \u0631\u062f\u06cc\u0641\u200c\u0647\u0627 \u062a\u0648\u0644\u06cc\u062f \u0645\u06cc\u200c\u06a9\u0646\u062f.<\/span><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span style=\"font-size: 14px;\">AND<\/span><\/h4>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u06cc\u06a9 \u0639\u0645\u0644\u06a9\u0631\u062f \u0645\u0646\u0637\u0642\u06cc \u062f\u06cc\u06af\u0631 \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0627\u0633\u062a \u0648 \u0628\u0631\u0631\u0633\u06cc \u0645\u06cc\u200c\u06a9\u0646\u062f \u06a9\u0647 \u0628\u0631\u062e\u06cc \u0645\u0648\u0627\u0631\u062f \u062f\u0631\u0633\u062a \u0647\u0633\u062a\u0646\u062f \u06cc\u0627 \u0646\u0627\u062f\u0631\u0633\u062a. \u0628\u0631\u0627\u06cc \u0645\u062b\u0627\u0644 \u060c \u0627\u06af\u0631 AND A1 \u062e\u0648\u0628 \u0628\u0627\u0634\u062f \u0648 \u0645\u0642\u062f\u0627\u0631 B2 \u0628\u0632\u0631\u06af\u062a\u0631 \u0627\u0632 \u06f1\u06f0 \u0628\u0627\u0634\u062f:<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">= AND (A1 = &#8220;GOOD&#8221;\u060c B2&gt; 10)<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0634\u0645\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0645\u0642\u0627\u062f\u06cc\u0631 \u0628\u06cc\u0634\u062a\u0631 \u0627\u0632 \u062f\u0648 \u0631\u0627 \u0646\u06cc\u0632 \u0628\u0647 \u0631\u0627\u062d\u062a\u06cc \u0628\u0627 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0646 \u0648\u06cc\u0631\u06af\u0648\u0644 \u062f\u06cc\u06af\u0631 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f.<\/span><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span style=\"font-size: 14px;\">\u0627\u0646\u062a\u062e\u0627\u0628 (choose)<\/span><\/h4>\n\n\n\n<p><span style=\"font-size: 14px;\">\u062a\u0627\u0628\u0639 CHOOSE \u0628\u0631\u0627\u06cc \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0633\u0646\u0627\u0631\u06cc\u0648 \u062f\u0631 \u0645\u062f\u0644 \u0633\u0627\u0632\u06cc \u0645\u0627\u0644\u06cc \u0639\u0627\u0644\u06cc \u0627\u0633\u062a. \u0628\u0647 \u0634\u0645\u0627 \u0627\u0645\u06a9\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f \u0628\u06cc\u0646 \u062a\u0639\u062f\u0627\u062f \u0645\u0634\u062e\u0635\u06cc \u06af\u0632\u06cc\u0646\u0647 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f \u0648 \u0686\u06cc\u0632\u06cc \u0631\u0627 \u06a9\u0647 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0631\u062f\u0647 \u0627\u06cc\u062f \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u06a9\u0646\u06cc\u062f. \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644\u060c \u062a\u0635\u0648\u0631 \u06a9\u0646\u06cc\u062f \u0628\u0631\u0627\u06cc \u0631\u0634\u062f \u062f\u0631\u0622\u0645\u062f \u0633\u0627\u0644 \u0622\u06cc\u0646\u062f\u0647 \u0633\u0647 \u0641\u0631\u0636\u06cc\u0647 \u0645\u062a\u0641\u0627\u0648\u062a \u062f\u0627\u0631\u06cc\u062f: \u06f5\u066a \u060c \u06f1\u06f2\u066a \u0648 \u06f1\u06f8\u066a. \u0627\u06af\u0631 \u0628\u0647 \u0627\u06a9\u0633\u0644 \u0628\u06af\u0648\u06cc\u06cc\u062f \u06af\u0632\u06cc\u0646\u0647 \u0634\u0645\u0627\u0631\u0647 \u06f2 \u0631\u0627 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f\u060c \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 CHOOSE \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u06f1\u06f2\u066a \u0631\u0627 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u06a9\u0646\u06cc\u062f.<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">= CHOOSE (\u0627\u0646\u062a\u062e\u0627\u0628 \u060c \u06af\u0632\u06cc\u0646\u0647 \u06f1 \u060c \u06af\u0632\u06cc\u0646\u0647 \u06f2 \u060c \u06af\u0632\u06cc\u0646\u0647 \u06f3)<\/span><\/p>\n\n\n<div class=\"jet-listing-grid--50192\" style=\"\"><section class=\"zht-related-post\" itemscope=\"\" itemtype=\"https:\/\/schema.org\/Article\" role=\"region\"\n  aria-label=\"Related article\">\n  <div class=\"zht-related-post-section-label\">\n    \u0645\u0637\u0627\u0644\u0628 \u0645\u0631\u062a\u0628\u0637\n  <\/div>\n  <img decoding=\"async\" width=\"300\" height=\"180\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2020\/09\/Conditional-Formatting-in-Excel-300x180.jpg.webp\" class=\"attachment-medium size-medium wp-post-image lazyload\" alt=\"\u062a\u0627\u0628\u0639 \u0634\u0631\u0637\u06cc \u062f\u0631 \u0627\u06a9\u0633\u0644\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2020\/09\/Conditional-Formatting-in-Excel-300x180.jpg.webp 300w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2020\/09\/Conditional-Formatting-in-Excel-768x461.jpg.webp 768w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2020\/09\/Conditional-Formatting-in-Excel.jpg 1000w\" data-sizes=\"(max-width: 300px) 100vw, 300px\" title=\"\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 300px; --smush-placeholder-aspect-ratio: 300\/180;\">\n  <a href=\"https:\/\/maktabkhooneh.org\/mag\/what-is-the-use-of-the-conditional-function-in-excel\/\" class=\"zht-related-post-title\"\n    itemprop=\"headline\" target=\"_blank\">\u062a\u0627\u0628\u0639 \u0634\u0631\u0637\u06cc \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0686\u0647 \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u062f\u0627\u0631\u062f\u061f<\/a>\n<\/section><\/div>\n\n\n<h4 class=\"wp-block-heading\"><span style=\"font-size: 14px;\">VLOOKUP<\/span><\/h4>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u0628\u0647 \u0634\u0645\u0627 \u0627\u0645\u06a9\u0627\u0646 \u0631\u0627 \u0645\u06cc\u200c\u062f\u0647\u062f \u06a9\u0647 \u0686\u06cc\u0632\u06cc \u0631\u0627 \u062f\u0631 \u0633\u062a\u0648\u0646 \u0633\u0645\u062a \u0686\u067e \u0635\u0641\u062d\u0647 \u06af\u0633\u062a\u0631\u062f\u0647 \u062c\u0633\u062a\u062c\u0648 \u06a9\u0646\u06cc\u062f \u0648 \u0622\u0646 \u0631\u0627 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u0645\u0642\u062f\u0627\u0631 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u06a9\u0646\u06cc\u062f. \u0645\u062b\u0627\u0644\u06cc \u0627\u0632 \u0646\u062d\u0648\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u0628\u0647 \u0634\u0631\u062d \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">= VLOOKUP (\u0645\u0642\u062f\u0627\u0631 \u062c\u0633\u062a\u062c\u0648 \u060c \u062c\u062f\u0648\u0644 \u062f\u0631 \u062d\u0627\u0644 \u062c\u0633\u062a\u062c\u0648 \u060c \u0634\u0645\u0627\u0631\u0647 \u0641\u0647\u0631\u0633\u062a \u060c \u0634\u0646\u0627\u0633\u0647 \u0645\u0631\u062a\u0628 \u0633\u0627\u0632\u06cc)<\/span><\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"1044\" height=\"813\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2020\/09\/003_Vlookup.jpg\" alt=\"\u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u062a\u0631\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u0647\u0627\u06cc \u0627\u06a9\u0633\u0644 Vlookup\" class=\"wp-image-8936 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2020\/09\/003_Vlookup.jpg 1044w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2020\/09\/003_Vlookup-300x234.jpg.webp 300w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2020\/09\/003_Vlookup-1024x797.jpg.webp 1024w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2020\/09\/003_Vlookup-768x598.jpg.webp 768w\" data-sizes=\"(max-width: 1044px) 100vw, 1044px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1044px; --smush-placeholder-aspect-ratio: 1044\/813;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p><span style=\"font-size: 14px;\"><\/span><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span style=\"font-size: 14px;\">CONCATENATE<\/span><\/h4>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0627\u0644\u062d\u0627\u0642 \u0646\u0647 \u062a\u0646\u0647\u0627 \u06cc\u06a9 \u06a9\u0644\u0645\u0647 \u062e\u0627\u0631\u0642 \u0627\u0644\u0639\u0627\u062f\u0647 \u0628\u0631\u0627\u06cc \u06af\u0641\u062a\u0646 \u0627\u0633\u062a\u060c \u0628\u0644\u06a9\u0647 \u062f\u0631 \u0635\u0648\u0631\u062a \u0646\u06cc\u0627\u0632 \u0628\u0647 \u062a\u0631\u06a9\u06cc\u0628 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062f\u0631 \u06cc\u06a9 \u0633\u0644\u0648\u0644 \u0639\u0645\u0644\u06a9\u0631\u062f \u0645\u0641\u06cc\u062f\u06cc \u0646\u06cc\u0632 \u0627\u0633\u062a. \u0628\u0631\u0627\u06cc \u0645\u062b\u0627\u0644 \u0628\u06af\u0648\u06cc\u06cc\u062f \u06a9\u0647 \u0628\u0647 \u062a\u0631\u062a\u06cc\u0628 \u062f\u0631 \u0633\u0644\u0648\u0644 \u0647\u0627\u06cc A1 \u0648 A2 \u0646\u0627\u0645 \u0648 \u0646\u0627\u0645 \u062e\u0627\u0646\u0648\u0627\u062f\u06af\u06cc \u062f\u0627\u0634\u062a\u0647 \u0627\u06cc\u062f. \u0634\u0645\u0627<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">= CONCATENATE (A1 \u060c &#8220;&#8221; \u060c B2)<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0631\u0627 \u062a\u0627\u06cc\u067e \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f\u060c \u062a\u0627 \u0646\u0627\u0645\u200c\u0647\u0627 \u0631\u0627 \u062f\u0631 \u06cc\u06a9 \u0633\u0644\u0648\u0644 \u062a\u0631\u06a9\u06cc\u0628 \u06a9\u0646\u062f \u0648 &#8220;&#8221; \u0628\u06cc\u0646 \u0622\u0646\u0647\u0627 \u0641\u0627\u0635\u0644\u0647 \u0645\u06cc \u062f\u0647\u062f.<\/span><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span style=\"font-size: 14px;\">PROPER<\/span><\/h4>\n\n\n\n<p><span style=\"font-size: 14px;\">PROPER \u0632\u0645\u0627\u0646\u06cc \u0645\u0641\u06cc\u062f \u0627\u0633\u062a \u06a9\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0634\u0645\u0627 \u0645\u062a\u0646 \u0632\u06cc\u0627\u062f\u06cc \u0628\u0627 \u0642\u0627\u0644\u0628 \u0639\u062c\u06cc\u0628 \u0648 \u063a\u0631\u06cc\u0628 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u062f \u06a9\u0647 \u0628\u0647 \u0646\u0638\u0631 \u0645\u06cc\u200c\u0631\u0633\u062f \u062f\u0631 \u062c\u0627\u06cc \u0627\u0634\u062a\u0628\u0627\u0647 \u0642\u0631\u0627\u0631 \u06af\u0631\u0641\u062a\u0647 \u0628\u0627\u0634\u062f.<\/span><\/p>\n\n\n<div class=\"jet-listing-grid--50192\" style=\"\"><section class=\"zht-related-post\" itemscope=\"\" itemtype=\"https:\/\/schema.org\/Article\" role=\"region\"\n  aria-label=\"Related article\">\n  <div class=\"zht-related-post-section-label\">\n    \u0645\u0637\u0627\u0644\u0628 \u0645\u0631\u062a\u0628\u0637\n  <\/div>\n  <img decoding=\"async\" width=\"300\" height=\"169\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2020\/08\/\u06af\u0632\u0627\u0631\u0634-\u06af\u06cc\u0631\u06cc-\u062f\u0631-\u0627\u06a9\u0633\u0644-4-300x169.jpg.webp\" class=\"attachment-medium size-medium wp-post-image lazyload\" alt=\"\u06af\u0632\u0627\u0631\u0634 \u06af\u06cc\u0631\u06cc \u062f\u0631 \u0627\u06a9\u0633\u0644\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2020\/08\/\u06af\u0632\u0627\u0631\u0634-\u06af\u06cc\u0631\u06cc-\u062f\u0631-\u0627\u06a9\u0633\u0644-4-300x169.jpg.webp 300w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2020\/08\/\u06af\u0632\u0627\u0631\u0634-\u06af\u06cc\u0631\u06cc-\u062f\u0631-\u0627\u06a9\u0633\u0644-4-768x432.jpg.webp 768w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2020\/08\/\u06af\u0632\u0627\u0631\u0634-\u06af\u06cc\u0631\u06cc-\u062f\u0631-\u0627\u06a9\u0633\u0644-4.jpg 1000w\" data-sizes=\"(max-width: 300px) 100vw, 300px\" title=\"\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 300px; --smush-placeholder-aspect-ratio: 300\/169;\">\n  <a href=\"https:\/\/maktabkhooneh.org\/mag\/reporting-in-excel\/\" class=\"zht-related-post-title\"\n    itemprop=\"headline\" target=\"_blank\">\u0645\u0639\u062c\u0632\u0647 \u0627\u06a9\u0633\u0644 \u0628\u0631\u0627\u06cc \u06af\u0632\u0627\u0631\u0634 \u06af\u06cc\u0631\u06cc<\/a>\n<\/section><\/div>\n\n\n<h3 class=\"wp-block-heading\"><span style=\"font-size: 14px;\">\u062a\u06a9\u0631\u0627\u0631 (Rept) \u06cc\u06a9\u06cc \u0627\u0632 \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u062a\u0631\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u0647\u0627\u06cc \u0627\u06a9\u0633\u0644<\/span><\/h3>\n\n\n\n<p><span style=\"font-size: 14px;\">\u062f\u0631 \u0627\u06a9\u0633\u0644\u060c \u0627\u06cc\u0646 \u0648\u06cc\u0698\u06af\u06cc \u0628\u0627 \u0639\u0645\u0644\u06a9\u0631\u062f REPT \u0627\u062f\u0627\u0631\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0627\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u062e\u06cc\u0644\u06cc \u06a9\u0627\u0631\u0622\u0645\u062f \u0646\u06cc\u0633\u062a \u0632\u06cc\u0631\u0627 \u0628\u0627\u06cc\u062f \u06a9\u0627\u0631\u0627\u06a9\u062a\u0631 \u0631\u0627 \u0628\u0647 \u0641\u0631\u0645\u0648\u0644 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f\u060c \u0633\u067e\u0633 \u0645\u0634\u062e\u0635 \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0686\u0646\u062f \u0628\u0627\u0631 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u0622\u0646 \u0634\u062e\u0635\u06cc\u062a \u062a\u06a9\u0631\u0627\u0631 \u0634\u0648\u062f. \u0627\u06cc\u0646 \u0628\u062f\u0627\u0646 \u0645\u0639\u0646\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0627\u06af\u0631 \u0639\u0631\u0636 \u0633\u0644\u0648\u0644 \u0627\u0641\u0632\u0627\u06cc\u0634 \u06cc\u0627\u0628\u062f \u060c \u0634\u062e\u0635\u06cc\u062a \u062a\u06a9\u0631\u0627\u0631 \u0646\u0634\u062f\u0647 \u0627\u0633\u062a \u0648 \u0627\u06af\u0631 \u0639\u0631\u0636 \u0633\u0644\u0648\u0644 \u06a9\u0627\u0647\u0634 \u06cc\u0627\u0628\u062f\u060c \u0634\u062e\u0635\u06cc\u062a \u062a\u06a9\u0631\u0627\u0631 \u0634\u062f\u0647 \u0628\u0647 \u0633\u0644\u0648\u0644 \u0645\u062c\u0627\u0648\u0631 \u0645\u0646\u062a\u0642\u0644 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">= REPT (&#8220;*&#8221; \u060c \u06f5)\u061b = REPT (&#8220;-&#8221; \u060c \u06f1\u06f0) \u060c = REPT (&#8220;+&#8221; \u060c \u06f1\u06f2).<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0647\u0631 \u06a9\u0627\u0631\u0627\u06a9\u062a\u0631 \u0631\u0627 \u0631\u0648\u06cc \u0635\u0641\u062d\u0647 \u06a9\u0644\u06cc\u062f \u0628\u0647 \u0647\u0645\u0631\u0627\u0647 \u0646\u0645\u0627\u062f\u0647\u0627 \u062a\u06a9\u0631\u0627\u0631 \u06a9\u0646\u06cc\u062f.<\/span><\/p>\n\n\n<div class=\"jet-listing-grid--56206\" style=\"\"><div class=\"jet-listing-dynamic-field-block zht-maktab-khooneh-learn cb-ud1ng69u\"data-is-block=\"jet-engine\/dynamic-field\"><div class=\"jet-listing-dynamic-field__content\" >\r\n<div class=\"zht-learn-card\">\r\n    <div class=\"zht-learn-title-section\">\r\n        <div class=\"zht-learn-card-icon\">\r\n            <svg viewBox=\"0 0 24 24\" fill=\"currentColor\" width=\"24\" height=\"24\">\r\n                <path d=\"M12 2C6.48 2 2 6.48 2 12s4.48 10 10 10 10-4.48 10-10S17.52 2 12 2zm-2 15l-5-5 1.41-1.41L10 14.17l7.59-7.59L19 8l-9 9z\" \/>\r\n            <\/svg>\r\n        <\/div>\r\n        \r\n        <!-- \u0639\u0646\u0648\u0627\u0646 \u062a\u0628\u062f\u06cc\u0644 \u0634\u062f\u0647 \u0628\u0647 \u0644\u06cc\u0646\u06a9 -->\r\n        <a href=\"https:\/\/maktabkhooneh.org\/learn\/office\/\" class=\"zht-learn-card-title\" target=\"_blank\" rel=\"noopener noreferrer\">\r\n            \u062f\u0648\u0631\u0647\u200c\u0647\u0627\u06cc \u0622\u0645\u0648\u0632\u0634 \u0622\u0641\u06cc\u0633        <\/a>\r\n    <\/div>\r\n\r\n    <!-- \u062f\u06a9\u0645\u0647 \u062a\u0628\u062f\u06cc\u0644 \u0634\u062f\u0647 \u0628\u0647 \u062a\u06af button -->\r\n    <!-- \u0627\u0632 onclick \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u062f\u0647 \u062a\u0627 \u0628\u0647 \u0645\u062d\u0636 \u06a9\u0644\u06cc\u06a9 \u0644\u06cc\u0646\u06a9 \u0631\u0627 \u0628\u0627\u0632 \u06a9\u0646\u062f -->\r\n    <button class=\"zht-learn-card-btn\" data-course-url=\"https:\/\/maktabkhooneh.org\/learn\/office\/\" onclick=\"window.open(this.getAttribute('data-course-url'), '_blank');\">\r\n        \u0634\u0631\u0648\u0639 \u06cc\u0627\u062f\u06af\u06cc\u0631\u06cc\r\n    <\/button>\r\n<\/div><\/div><\/div><\/div>\n\n\n<h4 class=\"wp-block-heading\"><span style=\"font-size: 14px;\">\u062f\u0631\u0635\u062f(Percentage)<\/span><\/h4>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u0641\u0631\u0645\u0648\u0644 \u062f\u0631\u0635\u062f \u062f\u0631 \u0627\u06a9\u0633\u0644\u060c \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc\u06cc \u0631\u0627 \u06a9\u0647 \u062f\u0631\u0635\u062f\u06cc \u0631\u0627 \u0628\u0631\u0627\u06cc \u0622\u0646\u200c\u0647\u0627 \u067e\u06cc\u062f\u0627 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f \u0628\u0627 \u0642\u0627\u0644\u0628\u060c = A1 \/ B1 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f. \u0628\u0631\u0627\u06cc \u062a\u0628\u062f\u06cc\u0644 \u0645\u0642\u062f\u0627\u0631 \u0627\u0639\u0634\u0627\u0631\u06cc \u062d\u0627\u0635\u0644 \u0628\u0647 \u06cc\u06a9 \u062f\u0631\u0635\u062f\u060c \u0633\u0644\u0648\u0644 \u0631\u0627 \u0628\u0631\u062c\u0633\u062a\u0647 \u06a9\u0646\u06cc\u062f\u060c \u0631\u0648\u06cc Home \u06a9\u0644\u06cc\u06a9 \u06a9\u0646\u06cc\u062f \u0648 \u0627\u0632 \u0644\u06cc\u0633\u062a \u06a9\u0634\u0648\u06cc\u06cc \u0627\u0639\u062f\u0627\u062f &#8220;\u062f\u0631\u0635\u062f&#8221; \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.\u0641\u0631\u0645\u0648\u0644 \u0627\u06a9\u0633\u0644 \u0628\u0631\u0627\u06cc \u062f\u0631\u0635\u062f\u0647\u0627 \u0641\u06cc \u0646\u0641\u0633\u0647 \u0648\u062c\u0648\u062f \u0646\u062f\u0627\u0631\u062f\u060c \u0627\u0645\u0627 \u0627\u06a9\u0633\u0644 \u062a\u0628\u062f\u06cc\u0644 \u0645\u0642\u062f\u0627\u0631 \u0647\u0631 \u0633\u0644\u0648\u0644 \u0631\u0627 \u0628\u0647 \u062f\u0631\u0635\u062f \u0622\u0633\u0627\u0646 \u0645\u06cc\u200c\u06a9\u0646\u062f\u060c \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u062e\u0648\u062f\u062a\u0627\u0646 \u062f\u0631 \u0645\u062d\u0627\u0633\u0628\u0647 \u0648 \u0648\u0627\u0631\u062f \u06a9\u0631\u062f\u0646 \u0645\u062c\u062f\u062f \u0627\u0639\u062f\u0627\u062f \u06af\u06cc\u0631 \u0646\u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f.<\/span><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span style=\"font-size: 14px;\">\u0644\u06cc\u0646\u06a9 \u06a9\u0631\u062f\u0646 \u0628\u0631\u06af\u0647 (Linking Worksheets<strong>)<\/strong><\/span><\/h3>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0634\u0645\u0627 \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0646\u06cc\u0627\u0632 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f \u0627\u0632 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u06cc\u06a9 \u0633\u0644\u0648\u0644 \u0648 \u06cc\u0627 \u0641\u0631\u0645\u0648\u0644 \u0646\u0648\u0634\u062a\u0647 \u0634\u062f\u0647 \u0627\u0632 \u0633\u0644\u0648\u0644\u06cc \u062f\u0631 \u0628\u0631\u06af\u0647 \u062c\u0627\u0631\u06cc&nbsp; \u062f\u0631 \u0628\u0631\u06af\u0647 \u0627\u06cc \u062f\u06cc\u06af\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f. \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0627 \u06a9\u0645\u06a9 \u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u0648 \u0628\u0627 \u062a\u0627\u06cc\u067e \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0647 \u0631\u0627\u062d\u062a\u06cc \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u062f:<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0633\u0644\u0648\u0644 \u0645\u0631\u062c\u0639!\u0646\u0627\u0645 \u0635\u0641\u062d\u0647 \u0645\u0631\u062c\u0639 =<\/span><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span style=\"font-size: 14px;\">\u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc (CONDITIONAL FORMATTING) \u062f\u0631 \u0627\u06a9\u0633\u0644<\/span><\/h3>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u0627\u0632 \u0646\u0638\u0631 \u0641\u0646\u06cc \u06cc\u06a9 \u0641\u0631\u0645\u0648\u0644 \u0646\u06cc\u0633\u062a\u060c \u0627\u0645\u0627 \u0627\u0628\u0632\u0627\u0631\u06cc \u0641\u0648\u0642 \u0627\u0644\u0639\u0627\u062f\u0647 \u0645\u0641\u06cc\u062f \u0627\u0633\u062a \u06a9\u0647 \u062f\u0631\u0633\u062a \u062f\u0631 \u0627\u06a9\u0633\u0644 \u062a\u0639\u0628\u06cc\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a.\u0627\u06af\u0631 \u0628\u0647 \u062e\u0627\u0646\u0647(home) \u0628\u0631\u0648\u06cc\u062f -&gt; \u0633\u0628\u06a9 \u0647\u0627 Styles) (-&gt; \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0645\u0634\u0631\u0648\u0637 (CONDITIONAL FORMATTING)\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u06af\u0632\u06cc\u0646\u0647\u200c\u0647\u0627\u06cc \u0632\u06cc\u0627\u062f\u06cc \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u062f\u0631 \u0635\u0648\u0631\u062a \u0635\u062d\u062a \u0628\u0631\u062e\u06cc \u0645\u0648\u0627\u0631\u062f \u062e\u0631\u0648\u062c\u06cc \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u062f. \u0634\u0645\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0633\u06cc\u0627\u0631\u06cc \u0627\u0632 \u0627\u06cc\u0646 \u06a9\u0627\u0631\u0647\u0627 \u0631\u0627 \u0628\u0627 \u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0642\u0628\u0644\u0627\u064b \u0630\u06a9\u0631 \u0634\u062f \u0647\u0645 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u062f\u060c \u0627\u0645\u0627 \u0686\u0631\u0627 \u0627\u062c\u0627\u0632\u0647 \u0646\u0645\u06cc\u200c\u062f\u0647\u06cc\u062f \u0627\u06a9\u0633\u0644 \u06a9\u0627\u0631\u0647\u0627\u06cc \u0633\u062e\u062a \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u062f.<\/span><\/p>\n\n\n<div class=\"jet-listing-grid--50192\" style=\"\"><section class=\"zht-related-post\" itemscope=\"\" itemtype=\"https:\/\/schema.org\/Article\" role=\"region\"\n  aria-label=\"Related article\">\n  <div class=\"zht-related-post-section-label\">\n    \u0645\u0637\u0627\u0644\u0628 \u0645\u0631\u062a\u0628\u0637\n  <\/div>\n  <img decoding=\"async\" width=\"300\" height=\"200\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2020\/08\/\u0641\u0627\u0631\u0633\u06cc-\u06a9\u0631\u062f\u0646-\u0627\u0639\u062f\u0627\u062f-\u062f\u0631-\u0627\u06a9\u0633\u0644-1-300x200.jpg.webp\" class=\"attachment-medium size-medium wp-post-image lazyload\" alt=\"\u0641\u0627\u0631\u0633\u06cc \u06a9\u0631\u062f\u0646 \u0627\u0639\u062f\u0627\u062f \u062f\u0631 \u0627\u06a9\u0633\u0644\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2020\/08\/\u0641\u0627\u0631\u0633\u06cc-\u06a9\u0631\u062f\u0646-\u0627\u0639\u062f\u0627\u062f-\u062f\u0631-\u0627\u06a9\u0633\u0644-1-300x200.jpg.webp 300w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2020\/08\/\u0641\u0627\u0631\u0633\u06cc-\u06a9\u0631\u062f\u0646-\u0627\u0639\u062f\u0627\u062f-\u062f\u0631-\u0627\u06a9\u0633\u0644-1-768x512.jpg.webp 768w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2020\/08\/\u0641\u0627\u0631\u0633\u06cc-\u06a9\u0631\u062f\u0646-\u0627\u0639\u062f\u0627\u062f-\u062f\u0631-\u0627\u06a9\u0633\u0644-1.jpg 1000w\" data-sizes=\"(max-width: 300px) 100vw, 300px\" title=\"\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 300px; --smush-placeholder-aspect-ratio: 300\/200;\">\n  <a href=\"https:\/\/maktabkhooneh.org\/mag\/persianize-numbers-in-excel\/\" class=\"zht-related-post-title\"\n    itemprop=\"headline\" target=\"_blank\">\u0686\u06af\u0648\u0646\u0647 \u0627\u0639\u062f\u0627\u062f \u0631\u0627 \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0641\u0627\u0631\u0633\u06cc \u06a9\u0646\u06cc\u0645\u061f<\/a>\n<\/section><\/div>\n\n\n<h4 class=\"wp-block-heading\"><span style=\"font-size: 14px;\">INDEX + MATCH<\/span><\/h4>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0627\u06cc\u0646 \u062a\u0631\u06a9\u06cc\u0628 \u062a\u0648\u0627\u0628\u0639 \u0628\u0647 \u0634\u0645\u0627 \u0627\u0645\u06a9\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f \u062a\u0627 \u0645\u062d\u062f\u0648\u062f\u06cc\u062a\u200c\u0647\u0627\u06cc \u0622\u0632\u0627\u0631 \u062f\u0647\u0646\u062f\u0647 VLOOKUP \u0631\u0627 \u062f\u0648\u0631 \u0628\u0632\u0646\u06cc\u062f. \u0628\u0627 \u062a\u0631\u06a9\u06cc\u0628 \u0627\u06cc\u0646 \u062a\u0648\u0627\u0628\u0639 \u0645\u0627\u0646\u0646\u062f \u0627\u06cc\u0646<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">&nbsp;= INDEX (\u0644\u06cc\u0633\u062a \u0645\u0642\u0627\u062f\u06cc\u0631 \u060c MATCH (\u0622\u0646\u0686\u0647 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u062f \u062c\u0633\u062a\u062c\u0648 \u06a9\u0646\u06cc\u062f \u060c \u0633\u062a\u0648\u0646 \u062c\u0633\u062a\u062c\u0648 \u060c \u0645\u0631\u062a\u0628 \u0633\u0627\u0632\u06cc \u0634\u0646\u0627\u0633\u0647)) \u060c<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u06cc\u06a9 \u0635\u0641\u062d\u0647 \u06af\u0633\u062a\u0631\u062f\u0647 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0645\u0642\u0627\u062f\u06cc\u0631 \u062c\u0633\u062a\u062c\u0648 \u06a9\u0646\u06cc\u062f \u0628\u0647 \u062c\u0627\u06cc \u0627\u06cc\u0646\u06a9\u0647 \u0645\u062c\u0628\u0648\u0631 \u0634\u0648\u06cc\u062f \u0641\u0642\u0637 \u0633\u062a\u0648\u0646 \u0633\u0645\u062a \u0686\u067e \u0631\u0627 \u062c\u0633\u062a\u062c\u0648 \u06a9\u0646\u06cc\u062f .<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">XNPV \u0648 XIRR<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0627\u06af\u0631 \u062a\u062d\u0644\u06cc\u0644\u200c\u06af\u0631\u06cc \u0647\u0633\u062a\u06cc\u062f \u06a9\u0647 \u062f\u0631 \u0628\u0627\u0646\u06a9\u062f\u0627\u0631\u06cc \u0633\u0631\u0645\u0627\u06cc\u0647 \u06af\u0630\u0627\u0631\u06cc\u060c \u062a\u062d\u0642\u06cc\u0642\u0627\u062a \u0633\u0647\u0627\u0645\u060c \u0628\u0631\u0646\u0627\u0645\u0647 \u0631\u06cc\u0632\u06cc \u0648 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0645\u0627\u0644\u06cc (FP&amp;A) \u06cc\u0627 \u0647\u0631 \u0632\u0645\u06cc\u0646\u0647 \u0645\u0627\u0644\u06cc \u062f\u06cc\u06af\u0631\u06cc \u06a9\u0647 \u0646\u06cc\u0627\u0632 \u0628\u0647 \u062a\u062e\u0641\u06cc\u0641 \u062f\u0631 \u062c\u0631\u06cc\u0627\u0646 \u0646\u0642\u062f\u06cc \u062f\u0627\u0631\u062f\u060c \u06a9\u0627\u0631 \u0645\u06cc\u200c\u06a9\u0646\u062f \u060c \u0627\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u0647\u0627 \u06cc\u06a9 \u0646\u062c\u0627\u062a \u062f\u0647\u0646\u062f\u0647 \u0647\u0633\u062a\u0646\u062f:<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">= XNPV (\u0646\u0631\u062e \u062a\u062e\u0641\u06cc\u0641 \u060c \u062c\u0631\u06cc\u0627\u0646 \u0647\u0627\u06cc \u0646\u0642\u062f\u06cc \u060c \u062a\u0627\u0631\u06cc\u062e \u0647\u0627)<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0628\u0647 \u0632\u0628\u0627\u0646 \u0633\u0627\u062f\u0647\u060c XNPV \u0648 XIRR \u0628\u0647 \u0634\u0645\u0627 &nbsp;\u0627\u06cc\u0646 \u0627\u0645\u06a9\u0627\u0646 \u0631\u0627 \u0645\u06cc\u200c\u062f\u0647\u0646\u062f \u06a9\u0647 \u062a\u0627\u0631\u06cc\u062e\u200c\u0647\u0627\u06cc \u0645\u0634\u062e\u0635\u06cc \u0631\u0627 \u0628\u0631\u0627\u06cc \u0647\u0631 \u062c\u0631\u06cc\u0627\u0646 \u0646\u0642\u062f\u06cc \u0645\u0646\u0641\u0631\u062f \u06a9\u0647 \u062a\u062e\u0641\u06cc\u0641 \u062f\u0627\u0631\u062f \u0627\u0639\u0645\u0627\u0644 \u06a9\u0646\u06cc\u062f. \u0645\u0634\u06a9\u0644\u06cc \u06a9\u0647 \u062f\u0631 \u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627\u06cc NPV \u0648 IRR \u0627\u06a9\u0633\u0644 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u0641\u0631\u0636 \u0645\u06cc\u200c\u06a9\u0646\u0646\u062f \u0628\u0627\u0632\u0647\u200c\u0647\u0627\u06cc \u0632\u0645\u0627\u0646\u06cc \u0628\u06cc\u0646 \u062c\u0631\u06cc\u0627\u0646 \u0646\u0642\u062f\u06cc \u0628\u0631\u0627\u0628\u0631 \u0647\u0633\u062a\u0646\u062f. \u0628\u0647 \u0637\u0648\u0631 \u0645\u0639\u0645\u0648\u0644\u060c \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u062a\u062d\u0644\u06cc\u0644\u200c\u06af\u0631\u060c \u0645\u0648\u0642\u0639\u06cc\u062a\u200c\u0647\u0627\u06cc\u06cc \u062e\u0648\u0627\u0647\u06cc\u062f \u062f\u0627\u0634\u062a \u06a9\u0647 \u062c\u0631\u06cc\u0627\u0646\u200c\u0647\u0627\u06cc \u0646\u0642\u062f\u06cc \u0628\u0647 \u0637\u0648\u0631 \u06cc\u06a9\u0646\u0648\u0627\u062e\u062a \u062a\u0646\u0638\u06cc\u0645 \u0646\u0645\u06cc\u200c\u0634\u0648\u0646\u062f \u0648 \u0627\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u0631\u0627\u0647 \u062d\u0644 \u0622\u0646 \u0627\u0633\u062a.<\/span><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span style=\"font-size: 14px;\">PMT \u0648 IPMT<\/span><\/h4>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0627\u06af\u0631 \u062f\u0631 \u0628\u0627\u0646\u06a9\u062f\u0627\u0631\u06cc \u062a\u062c\u0627\u0631\u06cc\u060c \u0627\u0645\u0644\u0627\u06a9 \u0648 \u0645\u0633\u062a\u063a\u0644\u0627\u062a\u060c FP&amp;A \u06cc\u0627 \u0647\u0631 \u0645\u0648\u0642\u0639\u06cc\u062a \u062f\u06cc\u06af\u0631\u060c \u062a\u062d\u0644\u06cc\u0644\u200c\u06af\u0631 \u0645\u0627\u0644\u06cc &nbsp;\u0647\u0633\u062a\u06cc\u062f \u06a9\u0647 \u0628\u0627 \u0628\u0631\u0646\u0627\u0645\u0647\u200c\u0647\u0627\u06cc \u0628\u062f\u0647\u06cc \u0633\u0631\u0648\u06a9\u0627\u0631 \u062f\u0627\u0631\u062f\u060c \u0628\u0627\u06cc\u062f \u0627\u06cc\u0646 \u062f\u0648 \u0641\u0631\u0645\u0648\u0644 \u0631\u0627 \u062f\u0642\u06cc\u0642 \u06cc\u0627\u062f \u0628\u06af\u06cc\u0631\u06cc\u062f:<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0641\u0631\u0645\u0648\u0644 PMT \u0627\u0631\u0632\u0634 \u067e\u0631\u062f\u0627\u062e\u062a \u0628\u0631\u0627\u0628\u0631 \u0631\u0627 \u062f\u0631 \u0637\u0648\u0644 \u0639\u0645\u0631 \u0648\u0627\u0645 \u060c\u0628\u0647 \u0634\u0645\u0627 \u0645\u06cc\u200c\u062f\u0647\u062f. \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0622\u0646 \u0628\u0647 \u0647\u0645\u0631\u0627\u0647 IPMT (\u06a9\u0647 \u067e\u0631\u062f\u0627\u062e\u062a \u0633\u0648\u062f \u0628\u0631\u0627\u06cc \u0647\u0645\u0627\u0646 \u0646\u0648\u0639 \u0648\u0627\u0645 \u0631\u0627 \u0628\u0647 \u0634\u0645\u0627 \u0645\u06cc\u200c\u06af\u0648\u06cc\u062f) \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f\u060c \u0633\u067e\u0633 \u067e\u0631\u062f\u0627\u062e\u062a \u0627\u0635\u0644 \u0648 \u0633\u0648\u062f \u0631\u0627 \u062c\u062f\u0627 \u06a9\u0646\u06cc\u062f.<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">= PMT (\u0646\u0631\u062e \u0628\u0647\u0631\u0647 \u060c # \u062f\u0648\u0631\u0647 \u060c \u0627\u0631\u0632\u0634 \u0641\u0639\u0644\u06cc)<\/span><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span style=\"font-size: 14px;\">LEN \u0648 TRIM<\/span><\/h4>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0641\u0631\u0645\u0648\u0644 \u0647\u0627: = LEN (\u0645\u062a\u0646) \u0648 = TRIM (\u0645\u062a\u0646)<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0627\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627 \u06a9\u0645\u06cc \u06a9\u0645\u062a\u0631 \u0631\u0627\u06cc\u062c \u0647\u0633\u062a\u0646\u062f\u060c \u0627\u0645\u0627 \u0645\u0637\u0645\u0626\u0646\u0627\u064b \u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627\u06cc \u0628\u0633\u06cc\u0627\u0631 \u067e\u06cc\u0686\u06cc\u062f\u0647 \u0627\u0645\u0627 \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u0647\u0633\u062a\u0646\u062f. \u0627\u06cc\u0646 \u0628\u0631\u0646\u0627\u0645\u0647\u200c\u0647\u0627 \u0628\u0631\u0627\u06cc \u062a\u062d\u0644\u06cc\u0644 \u06af\u0631\u0627\u0646 \u0645\u0627\u0644\u06cc \u06a9\u0647 \u0646\u06cc\u0627\u0632 \u0628\u0647 \u062a\u0646\u0638\u06cc\u0645 \u0648 \u062f\u0633\u062a\u06a9\u0627\u0631\u06cc \u0645\u0642\u062f\u0627\u0631 \u0632\u06cc\u0627\u062f\u06cc \u0627\u0632 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062f\u0627\u0631\u0646\u062f \u0628\u0633\u06cc\u0627\u0631 \u0645\u0646\u0627\u0633\u0628 \u0627\u0633\u062a. \u0645\u062a\u0623\u0633\u0641\u0627\u0646\u0647\u060c \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0628\u0647 \u062f\u0633\u062a \u0645\u06cc\u200c\u0622\u0648\u0631\u06cc\u0645 \u0647\u0645\u06cc\u0634\u0647 \u06a9\u0627\u0645\u0644\u0627\u064b \u0645\u0646\u0638\u0645 \u0646\u06cc\u0633\u062a\u0646\u062f \u0648 \u06af\u0627\u0647\u06cc \u0627\u0648\u0642\u0627\u062a \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0645\u0648\u0627\u0631\u062f\u06cc \u0645\u0627\u0646\u0646\u062f \u0641\u0636\u0627\u0647\u0627\u06cc \u0627\u0636\u0627\u0641\u06cc \u062f\u0631 \u0627\u0628\u062a\u062f\u0627 \u06cc\u0627 \u0627\u0646\u062a\u200c\u0647\u0627\u06cc \u0633\u0644\u0648\u0644\u200c\u0647\u0627 \u0648\u062c\u0648\u062f \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u062f<\/span><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span style=\"font-size: 14px;\"><strong>&nbsp;<\/strong><strong>\u062a\u0627\u0628\u0639<\/strong><strong>&nbsp; <\/strong><strong>(<\/strong><strong>Clean<\/strong><strong>):<\/strong><\/span><\/h4>\n\n\n\n<p><span style=\"font-size: 14px;\"><strong>&nbsp;<\/strong>\u0627\u0632 \u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0628\u0631\u0627\u06cc \u062d\u0630\u0641 \u0634\u06a9\u0633\u062a\u06af\u06cc \u062e\u0637\u0648\u0637 \u062f\u0631 \u0647\u0631 \u0633\u0644\u0648\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f\u060c \u0628\u0647 \u062c\u0627\u06cc \u062a\u0627\u0628\u0639&nbsp;trim<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">\u062a\u0648\u0627\u0628\u0639 CELL \u060c LEFT \u060c MID \u0648 RIGHT<\/span><\/p>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0627\u06cc\u0646 \u062a\u0648\u0627\u0628\u0639 \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u0627\u06a9\u0633\u0644 \u0631\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0628\u0627 \u0647\u0645 \u062a\u0631\u06a9\u06cc\u0628 \u06a9\u0631\u062f \u0648 \u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627\u06cc \u0628\u0633\u06cc\u0627\u0631 \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u0648 \u067e\u06cc\u0686\u06cc\u062f\u0647\u200c\u0627\u06cc \u0631\u0627 \u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0631\u062f. \u0639\u0645\u0644\u06a9\u0631\u062f CELL \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0645\u062e\u062a\u0644\u0641\u06cc \u0631\u0627 \u062f\u0631 \u0645\u0648\u0631\u062f \u0645\u062d\u062a\u0648\u06cc\u0627\u062a \u0633\u0644\u0648\u0644 (\u0645\u0627\u0646\u0646\u062f \u0646\u0627\u0645 \u060c \u0645\u062d\u0644 \u060c \u0633\u0637\u0631 \u060c \u0633\u062a\u0648\u0646 \u0648 \u0645\u0648\u0627\u0631\u062f \u062f\u06cc\u06af\u0631) \u0628\u0627\u0632\u06af\u0631\u062f\u0627\u0646\u062f. \u0639\u0645\u0644\u06a9\u0631\u062f LEFT \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0645\u062a\u0646 \u0631\u0627 \u0627\u0632 \u0627\u0628\u062a\u062f\u0627\u06cc \u0633\u0644\u0648\u0644 (\u0686\u067e \u0628\u0647 \u0631\u0627\u0633\u062a) \u060c MID \u0645\u062a\u0646 \u0631\u0627 \u0627\u0632 \u0647\u0631 \u0646\u0642\u0637\u0647 \u0634\u0631\u0648\u0639 \u0633\u0644\u0648\u0644 (\u0686\u067e \u0628\u0647 \u0631\u0627\u0633\u062a) \u0648 RIGHT \u0645\u062a\u0646 \u0631\u0627 \u0627\u0632 \u0627\u0646\u062a\u200c\u0647\u0627\u06cc \u0633\u0644\u0648\u0644 (\u0631\u0627\u0633\u062a \u0628\u0647 \u0686\u067e) \u0628\u0631\u0645\u06cc\u200c\u06af\u0631\u062f\u0627\u0646\u062f.<\/span><\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"1487\" height=\"991\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2020\/09\/RANDFormulas-5be9fe84c9e77c00510a7088.jpg\" alt=\"\u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u062a\u0631\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u0647\u0627\u06cc \u0627\u06a9\u0633\u0644\" class=\"wp-image-8937 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2020\/09\/RANDFormulas-5be9fe84c9e77c00510a7088.jpg 1487w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2020\/09\/RANDFormulas-5be9fe84c9e77c00510a7088-300x200.jpg.webp 300w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2020\/09\/RANDFormulas-5be9fe84c9e77c00510a7088-1024x682.jpg.webp 1024w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2020\/09\/RANDFormulas-5be9fe84c9e77c00510a7088-768x512.jpg.webp 768w\" data-sizes=\"(max-width: 1487px) 100vw, 1487px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1487px; --smush-placeholder-aspect-ratio: 1487\/991;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p><span style=\"font-size: 14px;\"><\/span><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span style=\"font-size: 14px;\">\u0639\u0645\u0644\u06a9\u0631\u062f RAND \u062f\u0631 \u0627\u06a9\u0633\u0644<\/span><\/h2>\n\n\n\n<p><span style=\"font-size: 14px;\">\u0639\u0645\u0644\u06a9\u0631\u062f RAND \u0628\u0633\u06cc\u0627\u0631 \u0633\u0627\u062f\u0647 \u0627\u0633\u062a \u0648 \u0628\u0647 \u0637\u0648\u0631 \u0633\u0646\u062a\u06cc \u0628\u0631\u0627\u06cc \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0622\u0645\u0627\u0631\u06cc\u060c \u0631\u0645\u0632\u0646\u06af\u0627\u0631\u06cc\u060c \u0628\u0627\u0632\u06cc\u060c \u0642\u0645\u0627\u0631 \u0648 \u0646\u0638\u0631\u06cc\u0647 \u0627\u062d\u062a\u0645\u0627\u0644\u0627\u062a\u060c \u062f\u0631 \u0645\u06cc\u0627\u0646 \u062f\u0647\u200c\u0647\u0627 \u0645\u0648\u0631\u062f \u062f\u06cc\u06af\u0631\u060c \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u062f\u0631 \u0627\u06a9\u0633\u0644\u060c \u062a\u0627\u0628\u0639 RAND \u06cc\u06a9 \u0639\u062f\u062f \u062a\u0635\u0627\u062f\u0641\u06cc \u0628\u06cc\u0646 \u06f0 \u062a\u0627 \u06f1 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc\u200c\u06a9\u0646\u062f. \u0628\u0627 \u0627\u06cc\u0646 \u062d\u0627\u0644\u060c \u0647\u0631 \u0632\u0645\u0627\u0646 \u06a9\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062c\u062f\u06cc\u062f\u06cc \u0648\u0627\u0631\u062f \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f \u0648 \u06a9\u0644\u06cc\u062f Enter \u0631\u0627 \u0645\u06cc\u200c\u0641\u0634\u0627\u0631\u06cc\u062f\u060c \u0644\u06cc\u0633\u062a \u0627\u0639\u062f\u0627\u062f \u062a\u0635\u0627\u062f\u0641\u06cc \u06a9\u0647 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0631\u062f\u0647\u200c\u0627\u06cc\u062f \u062a\u063a\u06cc\u06cc\u0631 \u0645\u06cc\u200c\u06a9\u0646\u062f. \u0627\u06af\u0631 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u0644\u06cc\u0633\u062a \u0627\u0639\u062f\u0627\u062f \u062a\u0635\u0627\u062f\u0641\u06cc \u062e\u0648\u062f \u0631\u0627 \u062d\u0641\u0638 \u06a9\u0646\u06cc\u062f\u060c \u0628\u0627\u06cc\u062f \u0633\u0644\u0648\u0644\u200c\u0647\u0627 \u0631\u0627 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u06a9\u0646\u06cc\u062f.&nbsp;<\/span><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u0641\u0631\u0645\u0648\u0644 \u062f\u0631\u0635\u062f \u06af\u06cc\u0631\u06cc \u0628\u06cc\u0646 \u062f\u0648 \u0639\u062f\u062f \u062f\u0631 \u0627\u06a9\u0633\u0644 \u2013 \u0628\u0647 \u0632\u0628\u0627\u0646 \u0633\u0627\u062f\u0647<\/h2>\n\n\n\n<p>\u0641\u0631\u0645\u0648\u0644 \u062f\u0631\u0635\u062f\u06af\u06cc\u0631\u06cc \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0628\u0631\u0627\u06cc \u0645\u062d\u0627\u0633\u0628\u0647 \u062f\u0631\u0635\u062f \u062a\u0641\u0627\u0648\u062a \u0628\u06cc\u0646 \u062f\u0648 \u0639\u062f\u062f \u06cc\u0627 \u0645\u0642\u062f\u0627\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0628\u0631\u0627\u06cc \u0627\u06cc\u0646 \u0645\u0646\u0638\u0648\u0631\u060c \u06a9\u0627\u0641\u06cc \u0627\u0633\u062a \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 (\u0639\u062f\u062f \u062c\u062f\u06cc\u062f &#8211; \u0639\u062f\u062f \u0642\u0628\u0644\u06cc) \/ \u0639\u062f\u062f \u0642\u0628\u0644\u06cc * \u06f1\u06f0\u06f0 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f. \u0627\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0628\u0647 \u0631\u0627\u062d\u062a\u06cc \u062f\u0631\u0635\u062f \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u0642\u06cc\u0645\u062a\u200c\u0647\u0627\u060c \u06a9\u0627\u0647\u0634\u200c\u0647\u0627 \u0648 \u06cc\u0627 \u0627\u0641\u0632\u0627\u06cc\u0634\u200c\u0647\u0627 \u0631\u0627 \u0645\u062d\u0627\u0633\u0628\u0647 \u06a9\u0646\u062f. \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644\u060c \u0628\u0631\u0627\u06cc \u0645\u062d\u0627\u0633\u0628\u0647 \u062f\u0631\u0635\u062f \u062a\u063a\u06cc\u06cc\u0631 \u0642\u06cc\u0645\u062a \u06cc\u06a9 \u0645\u062d\u0635\u0648\u0644\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0641\u0631\u0645\u0648\u0644 \u0631\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a =(B2-A2)\/A2*100 \u0648\u0627\u0631\u062f \u06a9\u0631\u062f.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u0641\u0631\u0645\u0648\u0644 MAX &amp; MIN<\/h2>\n\n\n\n<p>\u062a\u0648\u0627\u0628\u0639 MAX \u0648 MIN \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0628\u0631\u0627\u06cc \u06cc\u0627\u0641\u062a\u0646 \u0628\u0632\u0631\u06af\u200c\u062a\u0631\u06cc\u0646 \u0648 \u06a9\u0648\u0686\u06a9\u200c\u062a\u0631\u06cc\u0646 \u0645\u0642\u062f\u0627\u0631 \u062f\u0631 \u06cc\u06a9 \u0645\u062c\u0645\u0648\u0639\u0647 \u0627\u0632 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u0646\u062f. \u062a\u0627\u0628\u0639 MAX \u0645\u0642\u062f\u0627\u0631 \u0628\u06cc\u0634\u062a\u0631\u06cc\u0646 \u0639\u062f\u062f \u0631\u0627 \u062f\u0631 \u06cc\u06a9 \u0645\u062d\u062f\u0648\u062f\u0647 \u0627\u0632 \u0633\u0644\u0648\u0644\u200c\u0647\u0627 \u0628\u0631\u0645\u06cc\u200c\u06af\u0631\u062f\u0627\u0646\u062f\u060c \u062f\u0631 \u062d\u0627\u0644\u06cc \u06a9\u0647 \u062a\u0627\u0628\u0639 MIN \u06a9\u0645\u062a\u0631\u06cc\u0646 \u0639\u062f\u062f \u0631\u0627 \u0628\u0627\u0632 \u0645\u06cc\u200c\u06af\u0631\u062f\u0627\u0646\u062f. \u0627\u06cc\u0646 \u062a\u0648\u0627\u0628\u0639 \u0628\u0631\u0627\u06cc \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0648 \u0634\u0646\u0627\u0633\u0627\u06cc\u06cc \u0645\u0642\u0627\u062f\u06cc\u0631 \u0627\u0641\u0631\u0627\u0637\u06cc \u0645\u0627\u0646\u0646\u062f \u0628\u0627\u0644\u0627\u062a\u0631\u06cc\u0646 \u0648 \u067e\u0627\u06cc\u06cc\u0646\u200c\u062a\u0631\u06cc\u0646 \u062f\u0631\u0622\u0645\u062f \u06cc\u0627 \u0642\u06cc\u0645\u062a\u200c\u0647\u0627 \u0645\u0641\u06cc\u062f \u0647\u0633\u062a\u0646\u062f.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u0641\u0631\u0645\u0648\u0644 IF<\/h2>\n\n\n\n<p>\u062a\u0627\u0628\u0639 IF \u062f\u0631 \u0627\u06a9\u0633\u0644 \u06cc\u06a9 \u062a\u0627\u0628\u0639 \u0645\u0646\u0637\u0642\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0628\u0647 \u0634\u0645\u0627 \u0627\u06cc\u0646 \u0627\u0645\u06a9\u0627\u0646 \u0631\u0627 \u0645\u06cc\u200c\u062f\u0647\u062f \u062a\u0627 \u0634\u0631\u0627\u06cc\u0637 \u062e\u0627\u0635 \u0631\u0627 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0631\u062f\u0647 \u0648 \u0646\u062a\u0627\u06cc\u062c \u0645\u062e\u062a\u0644\u0641\u06cc \u0628\u0631 \u0627\u0633\u0627\u0633 \u0622\u0646 \u0634\u0631\u0627\u06cc\u0637 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f. \u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u0628\u0647 \u0635\u0648\u0631\u062a =IF(\u0634\u0631\u0637\u060c \u0646\u062a\u06cc\u062c\u0647 \u062f\u0631\u0633\u062a\u060c \u0646\u062a\u06cc\u062c\u0647 \u0646\u0627\u062f\u0631\u0633\u062a) \u0639\u0645\u0644 \u0645\u06cc\u200c\u06a9\u0646\u062f. \u0628\u0631\u0627\u06cc \u0645\u062b\u0627\u0644\u060c \u062f\u0631 \u0635\u0648\u0631\u062a \u0628\u0631\u0642\u0631\u0627\u0631\u06cc \u0634\u0631\u0637 \u0645\u0639\u06cc\u0646\u060c \u06cc\u06a9 \u0645\u0642\u062f\u0627\u0631 \u062e\u0627\u0635 \u0631\u0627 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0648 \u062f\u0631 \u0635\u0648\u0631\u062a \u0639\u062f\u0645 \u0628\u0631\u0642\u0631\u0627\u0631\u06cc \u0634\u0631\u0637\u060c \u0645\u0642\u062f\u0627\u0631 \u062f\u06cc\u06af\u0631\u06cc \u0631\u0627 \u0646\u0645\u0627\u06cc\u0634 \u0645\u06cc\u200c\u062f\u0647\u062f.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u0641\u0631\u0645\u0648\u0644 TRIM<\/h2>\n\n\n\n<p>\u062a\u0627\u0628\u0639 TRIM \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0628\u0631\u0627\u06cc \u062d\u0630\u0641 \u0641\u0627\u0635\u0644\u0647\u200c\u0647\u0627\u06cc \u0627\u0636\u0627\u0641\u06cc \u0627\u0632 \u0627\u0628\u062a\u062f\u0627\u06cc\u060c \u0627\u0646\u062a\u0647\u0627\u06cc \u0648 \u0628\u06cc\u0646 \u06a9\u0644\u0645\u0627\u062a \u06cc\u06a9 \u0645\u062a\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u0632\u0645\u0627\u0646\u06cc \u06a9\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0628\u0647 \u0637\u0648\u0631 \u063a\u06cc\u0631\u0645\u0633\u062a\u0642\u06cc\u0645 \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0648 \u0634\u0627\u0645\u0644 \u0641\u0627\u0635\u0644\u0647\u200c\u0647\u0627\u06cc \u0646\u0627\u062e\u0648\u0627\u0633\u062a\u0647 \u0628\u0627\u0634\u0646\u062f\u060c \u0628\u0633\u06cc\u0627\u0631 \u0645\u0641\u06cc\u062f \u0627\u0633\u062a. \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062a\u0627\u0628\u0639 =TRIM(text) \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0628\u0647 \u0631\u0627\u062d\u062a\u06cc \u0627\u0632 \u0641\u0627\u0635\u0644\u0647\u200c\u0647\u0627\u06cc \u0627\u0636\u0627\u0641\u06cc \u06a9\u0647 \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u062f\u0631 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0648\u062c\u0648\u062f \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u062f\u060c \u062e\u0644\u0627\u0635 \u0634\u062f.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u0641\u0631\u0645\u0648\u0644 CONCATENATE<\/h2>\n\n\n\n<p>\u062a\u0627\u0628\u0639 CONCATENATE \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0628\u0631\u0627\u06cc \u062a\u0631\u06a9\u06cc\u0628 (\u0627\u062f\u063a\u0627\u0645) \u062f\u0648 \u06cc\u0627 \u0686\u0646\u062f \u0631\u0634\u062a\u0647 \u0645\u062a\u0646\u06cc \u0628\u0647 \u06cc\u06a9\u062f\u06cc\u06af\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u0645\u062a\u0646\u06cc \u062c\u062f\u06cc\u062f \u0627\u0632 \u062a\u0631\u06a9\u06cc\u0628 \u0686\u0646\u062f\u06cc\u0646 \u0633\u0644\u0648\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u0648\u062f. \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644\u060c \u0627\u06af\u0631 \u0628\u062e\u0648\u0627\u0647\u06cc\u062f \u0646\u0627\u0645 \u0648 \u0646\u0627\u0645 \u062e\u0627\u0646\u0648\u0627\u062f\u06af\u06cc \u0631\u0627 \u0627\u0632 \u062f\u0648 \u0633\u0644\u0648\u0644 \u062c\u062f\u0627\u06af\u0627\u0646\u0647 \u062a\u0631\u06a9\u06cc\u0628 \u06a9\u0646\u06cc\u062f\u060c \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 =CONCATENATE(A1, &#8221; &#8220;, B1) \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u062e\u0648\u0627\u0647\u06cc\u062f \u06a9\u0631\u062f.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u0641\u0631\u0645\u0648\u0644 TODAY<\/h2>\n\n\n\n<p>\u062a\u0627\u0628\u0639 TODAY \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0628\u0631\u0627\u06cc \u0628\u0627\u0632\u06af\u0631\u062f\u0627\u0646\u062f\u0646 \u062a\u0627\u0631\u06cc\u062e \u062c\u0627\u0631\u06cc \u0633\u06cc\u0633\u062a\u0645 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u0647\u0631 \u0628\u0627\u0631 \u06a9\u0647 \u0635\u0641\u062d\u0647 \u0627\u06a9\u0633\u0644 \u0628\u0627\u0632 \u0645\u06cc\u200c\u0634\u0648\u062f\u060c \u0628\u0647 \u0637\u0648\u0631 \u062e\u0648\u062f\u06a9\u0627\u0631 \u062a\u0627\u0631\u06cc\u062e \u0627\u0645\u0631\u0648\u0632 \u0631\u0627 \u0628\u0647 \u0646\u0645\u0627\u06cc\u0634 \u0645\u06cc\u200c\u06af\u0630\u0627\u0631\u062f. \u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0622\u0646\u060c \u06a9\u0627\u0641\u06cc \u0627\u0633\u062a \u0641\u0631\u0645\u0648\u0644 =TODAY() \u0631\u0627 \u062f\u0631 \u0633\u0644\u0648\u0644 \u0645\u0648\u0631\u062f \u0646\u0638\u0631 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f. \u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u062f\u0631 \u0645\u062d\u0627\u0633\u0628\u0627\u062a \u0645\u0631\u062a\u0628\u0637 \u0628\u0627 \u062a\u0627\u0631\u06cc\u062e \u0648 \u0632\u0645\u0627\u0646 \u0628\u0633\u06cc\u0627\u0631 \u0645\u0641\u06cc\u062f \u0627\u0633\u062a.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u0641\u0631\u0645\u0648\u0644 PROPER<\/h2>\n\n\n\n<p>\u062a\u0627\u0628\u0639 PROPER \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0628\u0631\u0627\u06cc \u062a\u063a\u06cc\u06cc\u0631 \u0627\u0648\u0644\u06cc\u0646 \u062d\u0631\u0641 \u0647\u0631 \u06a9\u0644\u0645\u0647 \u062f\u0631 \u06cc\u06a9 \u0631\u0634\u062a\u0647 \u0628\u0647 \u062d\u0631\u0641 \u0628\u0632\u0631\u06af \u0648 \u0628\u0642\u06cc\u0647 \u062d\u0631\u0648\u0641 \u0631\u0627 \u0628\u0647 \u06a9\u0648\u0686\u06a9 \u062a\u0628\u062f\u06cc\u0644 \u0645\u06cc\u200c\u06a9\u0646\u062f. \u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u0645\u0639\u0645\u0648\u0644\u0627\u064b \u0628\u0631\u0627\u06cc \u0641\u0631\u0645\u062a \u062f\u0647\u06cc \u0628\u0647 \u0645\u062a\u0648\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f\u060c \u0628\u0647 \u062e\u0635\u0648\u0635 \u0632\u0645\u0627\u0646\u06cc \u06a9\u0647 \u0644\u0627\u0632\u0645 \u0627\u0633\u062a \u0646\u0627\u0645\u200c\u0647\u0627 \u06cc\u0627 \u0639\u0646\u0627\u0648\u06cc\u0646 \u0628\u0647 \u0635\u0648\u0631\u062a \u0627\u0633\u062a\u0627\u0646\u062f\u0627\u0631\u062f \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0634\u0648\u0646\u062f. \u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u06cc\u0646 \u062a\u0627\u0628\u0639\u060c \u0641\u0631\u0645\u0648\u0644 =PROPER(text) \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u0641\u0631\u0645\u0648\u0644 EVEN &amp; ODD<\/h2>\n\n\n\n<p>\u062a\u0648\u0627\u0628\u0639 EVEN \u0648 ODD \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0628\u0631\u0627\u06cc \u062a\u0628\u062f\u06cc\u0644 \u06cc\u06a9 \u0639\u062f\u062f \u0628\u0647 \u0639\u062f\u062f \u0632\u0648\u062c \u06cc\u0627 \u0641\u0631\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u0646\u062f. \u062a\u0627\u0628\u0639 EVEN \u0639\u062f\u062f \u0631\u0627 \u0628\u0647 \u0646\u0632\u062f\u06cc\u06a9\u200c\u062a\u0631\u06cc\u0646 \u0639\u062f\u062f \u0632\u0648\u062c \u0628\u0627\u0644\u0627\u062a\u0631 \u0627\u0632 \u0622\u0646 \u0639\u062f\u062f \u062a\u0628\u062f\u06cc\u0644 \u0645\u06cc\u200c\u06a9\u0646\u062f\u060c \u062f\u0631 \u062d\u0627\u0644\u06cc \u06a9\u0647 \u062a\u0627\u0628\u0639 ODD \u0639\u062f\u062f \u0631\u0627 \u0628\u0647 \u0646\u0632\u062f\u06cc\u06a9\u200c\u062a\u0631\u06cc\u0646 \u0639\u062f\u062f \u0641\u0631\u062f \u0628\u0627\u0644\u0627\u062a\u0631 \u0627\u0632 \u0622\u0646 \u062a\u0628\u062f\u06cc\u0644 \u0645\u06cc\u200c\u06a9\u0646\u062f. \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644\u060c \u0627\u06af\u0631 \u0645\u0642\u062f\u0627\u0631 \u06f5 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f\u060c \u062a\u0627\u0628\u0639 EVEN \u0622\u0646 \u0631\u0627 \u0628\u0647 \u06f6 \u062a\u0628\u062f\u06cc\u0644 \u0645\u06cc\u200c\u06a9\u0646\u062f \u0648 \u062a\u0627\u0628\u0639 ODD \u0622\u0646 \u0631\u0627 \u0628\u0647 \u06f7 \u062a\u063a\u06cc\u06cc\u0631 \u0645\u06cc\u200c\u062f\u0647\u062f.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">&nbsp;\u0645\u062a\u062e\u0635\u0635 \u0627\u06a9\u0633\u0644 \u0634\u0648\u06cc\u062f<\/h2>\n\n\n\n<p>\u0628\u0627 \u062f\u0648\u0631\u0647\u200c\u0647\u0627\u06cc \u062c\u0627\u0645\u0639 <a href=\"https:\/\/maktabkhooneh.org\/learn\/excel\/\">\u0622\u0645\u0648\u0632\u0634 \u0627\u06a9\u0633\u0644<\/a> \u0645\u06a9\u062a\u0628 \u062e\u0648\u0646\u0647\u060c \u0627\u0632 \u0633\u0637\u062d \u0645\u0642\u062f\u0645\u0627\u062a\u06cc \u062a\u0627 \u067e\u06cc\u0634\u0631\u0641\u062a\u0647\u060c \u0628\u0647 \u06cc\u06a9 \u0645\u062a\u062e\u0635\u0635 \u0648\u0627\u0642\u0639\u06cc \u062f\u0631 \u0627\u06a9\u0633\u0644 \u062a\u0628\u062f\u06cc\u0644 \u0634\u0648\u06cc\u062f. \u0622\u0645\u0648\u0632\u0634\u200c\u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc\u060c \u0645\u062b\u0627\u0644\u200c\u0647\u0627\u06cc \u0639\u0645\u0644\u06cc \u0648 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u062d\u0631\u0641\u0647\u200c\u0627\u06cc \u062f\u0631 \u0627\u0646\u062a\u0638\u0627\u0631 \u0634\u0645\u0627\u0633\u062a. \u0647\u0645\u06cc\u0646 \u062d\u0627\u0644\u0627 \u062b\u0628\u062a \u0646\u0627\u0645 \u06a9\u0646\u06cc\u062f \u0648 \u0645\u0647\u0627\u0631\u062a\u200c\u0647\u0627\u06cc \u062e\u0648\u062f \u0631\u0627 \u0627\u0631\u062a\u0642\u0627 \u062f\u0647\u06cc\u062f. \u0647\u0645\u0686\u06cc\u0646 \u062f\u0631 \u0645\u06a9\u062a\u0628 \u062e\u0648\u0646\u0647 \u0627\u0646\u0648\u0627\u0639 \u062f\u0648\u0631\u0647&nbsp;<a href=\"https:\/\/maktabkhooneh.org\/learn\/advanced-excel\/\">\u0622\u0645\u0648\u0632\u0634 \u0627\u06a9\u0633\u0644 \u067e\u06cc\u0634\u0631\u0641\u062a\u0647<\/a>&nbsp;\u0648&nbsp;<a href=\"https:\/\/maktabkhooneh.org\/course\/%D8%A2%D9%85%D9%88%D8%B2%D8%B4-%D9%81%D8%B1%D9%85%D9%88%D9%84-%D8%AA%D9%88%D8%A7%D8%A8%D8%B9-%D9%BE%DB%8C%D8%B4%D8%B1%D9%81%D8%AA%D9%87-%D8%A7%DA%A9%D8%B3%D9%84-mk2121\/\">\u0622\u0645\u0648\u0632\u0634 \u0641\u0631\u0645\u0648\u0644 \u0646\u0648\u06cc\u0633\u06cc \u062f\u0631 \u0627\u06a9\u0633\u0644<\/a>&nbsp;\u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u06a9\u0645\u0644 \u0628\u062d\u062b \u0641\u0648\u0642 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0627\u06a9\u0633\u0644 \u0627\u0628\u0632\u0627\u0631\u06cc \u0627\u0631\u0632\u0634\u0645\u0646\u062f \u0627\u0633\u062a\u060c \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u0628\u0631\u0627\u06cc \u0633\u0631\u0639\u062a \u0628\u062e\u0634\u06cc\u062f\u0646 \u0628\u0647 \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0635\u0641\u062d\u0647 \u06af\u0633\u062a\u0631\u062f\u0647 \u0648 \u062a\u0628\u062f\u06cc\u0644 \u0634\u062f\u0646 \u0628\u0647 \u06cc\u06a9 \u0627\u0633\u062a\u0627\u062f \u0627\u06a9\u0633\u0644\u060c \u0628\u0627\u06cc\u062f \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u062a\u0631\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u0647\u0627\u06cc \u0627\u06a9\u0633\u0644 \u0631\u0627 \u0628\u0634\u0646\u0627\u0633\u06cc\u062f. \u062a\u0627 \u0628\u0647 \u062d\u0627\u0644 \u0628\u0627 \u0628\u062e\u0634\u200c\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u0648 \u0648\u06cc\u0698\u06af\u06cc\u200c\u0647\u0627\u06cc \u0645\u0641\u06cc\u062f\u06cc \u0627\u0632 \u0628\u0631\u0646\u0627\u0645\u0647 \u0627\u06a9\u0633\u0644 \u0622\u0634\u0646\u0627 \u0634\u062f\u0647\u200c\u0627\u06cc\u062f \u0648 \u0627\u06a9\u0646\u0648\u0646 \u0648\u0642\u062a \u0622\u0646 \u0627\u0633\u062a \u06a9\u0647 \u0645\u0641\u06cc\u062f\u062a\u0631\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627 \u0631\u0627 \u062f\u0631 \u0646\u0631\u0645\u200c\u0627\u0641\u0632\u0627\u0631 \u0627\u06a9\u0634 \u0628\u0634\u0646\u0627\u0633\u06cc\u062f. [&hellip;]<\/p>\n","protected":false},"author":82,"featured_media":8992,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[38],"tags":[],"class_list":["post-8932","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-how-to-learn-microsoft-excel"],"_links":{"self":[{"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/posts\/8932","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/users\/82"}],"replies":[{"embeddable":true,"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/comments?post=8932"}],"version-history":[{"count":5,"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/posts\/8932\/revisions"}],"predecessor-version":[{"id":67258,"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/posts\/8932\/revisions\/67258"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/media\/8992"}],"wp:attachment":[{"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/media?parent=8932"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/categories?post=8932"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/tags?post=8932"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}