{"id":19261,"date":"2024-07-28T14:25:58","date_gmt":"2024-07-28T10:55:58","guid":{"rendered":"https:\/\/iranfso.com\/blog\/?p=19261"},"modified":"2024-11-09T14:33:53","modified_gmt":"2024-11-09T11:03:53","slug":"microsoft-excel-formulas-functions","status":"publish","type":"post","link":"https:\/\/iranfso.com\/blog\/microsoft-excel-formulas-functions\/","title":{"rendered":"\u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627\u06cc \u067e\u0631\u06a9\u0627\u0631\u0628\u0631\u062f \u0627\u06a9\u0633\u0644 (Excel): \u0631\u0627\u0647\u0646\u0645\u0627\u06cc \u06a9\u0627\u0645\u0644"},"content":{"rendered":"<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/excel\">\u0627\u06a9\u0633\u0644<\/a> \u06cc\u06a9\u06cc \u0627\u0632 \u0642\u062f\u0631\u062a\u0645\u0646\u062f\u062a\u0631\u06cc\u0646 \u0646\u0631\u0645\u200c\u0627\u0641\u0632\u0627\u0631\u0647\u0627\u06cc \u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0648 \u0627\u0646\u062c\u0627\u0645 \u0645\u062d\u0627\u0633\u0628\u0627\u062a \u067e\u06cc\u0686\u06cc\u062f\u0647 \u0627\u0633\u062a. \u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641\u06cc \u06a9\u0647 \u062f\u0631 \u0627\u06cc\u0646 \u0646\u0631\u0645\u200c\u0627\u0641\u0632\u0627\u0631 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u0646\u062f\u060c \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 \u0628\u0647\u200c\u0633\u0627\u062f\u06af\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u067e\u0631\u062f\u0627\u0632\u0634 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u06a9\u0646\u0646\u062f. \u062f\u0631 \u0627\u06cc\u0646 \u0645\u062a\u0646\u060c \u0628\u0647 \u0628\u0631\u0631\u0633\u06cc \u0686\u0646\u062f \u0641\u0631\u0645\u0648\u0644 \u067e\u0631\u06a9\u0627\u0631\u0628\u0631\u062f \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0634\u0627\u0645\u0644 SUM\u060c AVERAGE\u060c COUNT\u060c IF\u060c VLOOKUP\u060c HLOOKUP \u0648 MAX \u067e\u0631\u062f\u0627\u062e\u062a\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a \u06a9\u0647 \u0647\u0631 \u06a9\u062f\u0627\u0645 \u0628\u0647\u200c\u0637\u0648\u0631 \u0645\u062e\u062a\u0635\u0631 \u062a\u0648\u0636\u06cc\u062d \u062f\u0627\u062f\u0647 \u0634\u062f\u0647\u200c\u0627\u0646\u062f.<\/p>\n<hr \/>\n<h2><strong>\u0641\u0631\u0645\u0648\u0644 SUM<\/strong><\/h2>\n<p>\u0641\u0631\u0645\u0648\u0644 <code>SUM<\/code> \u06cc\u06a9\u06cc \u0627\u0632 \u067e\u0631\u06a9\u0627\u0631\u0628\u0631\u062f\u062a\u0631\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627 \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0627\u0633\u062a \u06a9\u0647 \u0628\u0631\u0627\u06cc \u062c\u0645\u0639 \u06a9\u0631\u062f\u0646 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0639\u062f\u062f\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0627\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0645\u0642\u0627\u062f\u06cc\u0631 \u0645\u0648\u062c\u0648\u062f \u062f\u0631 \u0645\u062d\u062f\u0648\u062f\u0647\u200c\u0627\u06cc \u0627\u0632 \u0633\u0644\u0648\u0644\u200c\u0647\u0627 \u0631\u0627 \u062c\u0645\u0639 \u06a9\u0646\u062f. \u062f\u0631 \u0627\u062f\u0627\u0645\u0647 \u0628\u0647 \u062a\u0648\u0636\u06cc\u062d\u0627\u062a \u0628\u06cc\u0634\u062a\u0631\u06cc \u062f\u0631 \u0645\u0648\u0631\u062f \u0627\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u0645\u06cc\u200c\u067e\u0631\u062f\u0627\u0632\u0645.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-19288 size-full\" src=\"https:\/\/iranfso.com\/blog\/wp-content\/uploads\/2024\/07\/Sum.gif\" alt=\"\u0641\u0631\u0645\u0648\u0644 SUM\" width=\"680\" height=\"383\" \/><\/p>\n<h3><strong>\u0633\u0627\u062e\u062a\u0627\u0631 \u0641\u0631\u0645\u0648\u0644<\/strong><\/h3>\n<p>\u0633\u0627\u062e\u062a\u0627\u0631 \u06a9\u0644\u06cc \u0641\u0631\u0645\u0648\u0644 <code>SUM<\/code> \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre hljs language-excel\">=SUM(number1, [number2], ...)<br \/>\n<\/code><\/div>\n<\/div>\n<ul>\n<li><code>number1<\/code>, <code>number2<\/code>, &#8230; : \u0627\u06cc\u0646 \u067e\u0627\u0631\u0627\u0645\u062a\u0631\u0647\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u0627\u0639\u062f\u0627\u062f \u062b\u0627\u0628\u062a\u060c \u0622\u062f\u0631\u0633 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u060c \u06cc\u0627 \u0645\u062d\u062f\u0648\u062f\u0647\u200c\u0627\u06cc \u0627\u0632 \u0633\u0644\u0648\u0644\u200c\u0647\u0627 \u0628\u0627\u0634\u0646\u062f.<\/li>\n<\/ul>\n<h3>\u0645\u062b\u0627\u0644\u200c\u0647\u0627<\/h3>\n<ol>\n<li><strong>\u062c\u0645\u0639 \u062f\u0648 \u0639\u062f\u062f \u062b\u0627\u0628\u062a<\/strong>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=SUM(10, 20)<br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0646\u062a\u06cc\u062c\u0647: <code>30<\/code><\/li>\n<li><strong>\u062c\u0645\u0639 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0645\u0648\u062c\u0648\u062f \u062f\u0631 \u0645\u062d\u062f\u0648\u062f\u0647\u200c\u0627\u06cc \u0627\u0632 \u0633\u0644\u0648\u0644\u200c\u0647\u0627<\/strong> \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u062f\u0631 \u0633\u062a\u0648\u0646 A \u0645\u0642\u0627\u062f\u06cc\u0631 \u0639\u062f\u062f\u06cc \u0632\u06cc\u0631 \u0631\u0627 \u062f\u0627\u0631\u06cc\u062f:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-makefile\"><span class=\"hljs-section\">A1: 5<\/span><br \/>\n<span class=\"hljs-section\">A2: 10<\/span><br \/>\n<span class=\"hljs-section\">A3: 15<\/span><br \/>\n<span class=\"hljs-section\">A4: 20<\/span><br \/>\n<span class=\"hljs-section\">A5: 25<\/span><br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0628\u0631\u0627\u06cc \u062c\u0645\u0639 \u06a9\u0631\u062f\u0646 \u0627\u06cc\u0646 \u0645\u0642\u0627\u062f\u06cc\u0631\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=SUM(A1:A5)<br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0646\u062a\u06cc\u062c\u0647: <code>75<\/code><\/li>\n<li><strong>\u062c\u0645\u0639 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0686\u0646\u062f\u06cc\u0646 \u0645\u062d\u062f\u0648\u062f\u0647<\/strong> \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u062f\u0631 \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u06cc A \u0648 B \u0645\u0642\u0627\u062f\u06cc\u0631 \u0639\u062f\u062f\u06cc \u0632\u06cc\u0631 \u0631\u0627 \u062f\u0627\u0631\u06cc\u062f:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-makefile\"><span class=\"hljs-section\">A1: 5    B1: 2<\/span><br \/>\n<span class=\"hljs-section\">A2: 10   B2: 3<\/span><br \/>\n<span class=\"hljs-section\">A3: 15   B3: 4<\/span><br \/>\n<span class=\"hljs-section\">A4: 20   B4: 5<\/span><br \/>\n<span class=\"hljs-section\">A5: 25   B5: 6<\/span><br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0628\u0631\u0627\u06cc \u062c\u0645\u0639 \u06a9\u0631\u062f\u0646 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0647\u0631 \u062f\u0648 \u0645\u062d\u062f\u0648\u062f\u0647\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=SUM(A1:A5, B1:B5)<br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0646\u062a\u06cc\u062c\u0647: <code>90<\/code><\/li>\n<li><strong>\u062c\u0645\u0639 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u063a\u06cc\u0631 \u0645\u062f\u0627\u0648\u0645<\/strong> \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u062f\u0631 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc A1\u060c A3 \u0648 A5 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0639\u062f\u062f\u06cc \u0632\u06cc\u0631 \u0631\u0627 \u062f\u0627\u0631\u06cc\u062f:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-makefile\"><span class=\"hljs-section\">A1: 5<\/span><br \/>\n<span class=\"hljs-section\">A3: 15<\/span><br \/>\n<span class=\"hljs-section\">A5: 25<\/span><br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0628\u0631\u0627\u06cc \u062c\u0645\u0639 \u06a9\u0631\u062f\u0646 \u0627\u06cc\u0646 \u0645\u0642\u0627\u062f\u06cc\u0631\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=SUM(A1, A3, A5)<br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0646\u062a\u06cc\u062c\u0647: <code>45<\/code><\/li>\n<\/ol>\n<h3>\u0646\u06a9\u0627\u062a \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc<\/h3>\n<ul>\n<li>\u0641\u0631\u0645\u0648\u0644 <code>SUM<\/code> \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u062a\u0627 255 \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u0631\u0627 \u0628\u067e\u0630\u06cc\u0631\u062f.<\/li>\n<li>\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 <code>SUM<\/code> \u0628\u0647 \u062c\u0627\u06cc \u062c\u0645\u0639 \u062f\u0633\u062a\u06cc \u0645\u0642\u0627\u062f\u06cc\u0631 \u0628\u0627\u0639\u062b \u06a9\u0627\u0647\u0634 \u062e\u0637\u0627\u0647\u0627\u06cc \u0627\u0646\u0633\u0627\u0646\u06cc \u0645\u06cc\u200c\u0634\u0648\u062f.<\/li>\n<li><code>SUM<\/code> \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0628\u0627 \u0633\u0627\u06cc\u0631 \u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627 \u062a\u0631\u06a9\u06cc\u0628 \u0634\u0648\u062f \u062a\u0627 \u0645\u062d\u0627\u0633\u0628\u0627\u062a \u067e\u06cc\u0686\u06cc\u062f\u0647\u200c\u062a\u0631\u06cc \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u062f. \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=SUM(A1:A5) \/ COUNT(A1:A5)<br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0627\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u0645\u062c\u0645\u0648\u0639 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0631\u0627 \u0628\u0647 \u062a\u0639\u062f\u0627\u062f \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u0639\u062f\u062f\u06cc \u062a\u0642\u0633\u06cc\u0645 \u0645\u06cc\u200c\u06a9\u0646\u062f \u06a9\u0647 \u0645\u0639\u0627\u062f\u0644 \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 (AVERAGE) \u0627\u0633\u062a.<\/li>\n<\/ul>\n<hr \/>\n<h2><strong>\u0641\u0631\u0645\u0648\u0644 AVERAGE<\/strong><\/h2>\n<p>\u0641\u0631\u0645\u0648\u0644 <code>AVERAGE<\/code> \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0628\u0631\u0627\u06cc \u0645\u062d\u0627\u0633\u0628\u0647 \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 (\u0645\u062a\u0648\u0633\u0637) \u0645\u0642\u0627\u062f\u06cc\u0631 \u0639\u062f\u062f\u06cc \u062f\u0631 \u06cc\u06a9 \u0645\u062d\u062f\u0648\u062f\u0647 \u06cc\u0627 \u0645\u062c\u0645\u0648\u0639\u0647\u200c\u0627\u06cc \u0627\u0632 \u0633\u0644\u0648\u0644\u200c\u0647\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0627\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u0645\u062c\u0645\u0648\u0639 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0631\u0627 \u0628\u0631 \u062a\u0639\u062f\u0627\u062f \u0645\u0642\u0627\u062f\u06cc\u0631 \u062a\u0642\u0633\u06cc\u0645 \u0645\u06cc\u200c\u06a9\u0646\u062f \u062a\u0627 \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u0631\u0627 \u0645\u062d\u0627\u0633\u0628\u0647 \u06a9\u0646\u062f.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-19289 size-full\" src=\"https:\/\/iranfso.com\/blog\/wp-content\/uploads\/2024\/07\/Average.gif\" alt=\"\u0641\u0631\u0645\u0648\u0644 AVERAGE\" width=\"723\" height=\"380\" \/><\/p>\n<h3>\u0633\u0627\u062e\u062a\u0627\u0631 \u0641\u0631\u0645\u0648\u0644<\/h3>\n<p>\u0633\u0627\u062e\u062a\u0627\u0631 \u06a9\u0644\u06cc \u0641\u0631\u0645\u0648\u0644 <code>AVERAGE<\/code> \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre hljs language-excel\">=AVERAGE(number1, [number2], ...)<br \/>\n<\/code><\/div>\n<\/div>\n<ul>\n<li><code>number1<\/code>, <code>number2<\/code>, &#8230; : \u0627\u06cc\u0646 \u067e\u0627\u0631\u0627\u0645\u062a\u0631\u0647\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u0627\u0639\u062f\u0627\u062f \u062b\u0627\u0628\u062a\u060c \u0622\u062f\u0631\u0633 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u060c \u06cc\u0627 \u0645\u062d\u062f\u0648\u062f\u0647\u200c\u0627\u06cc \u0627\u0632 \u0633\u0644\u0648\u0644\u200c\u0647\u0627 \u0628\u0627\u0634\u0646\u062f.<\/li>\n<\/ul>\n<h3>\u0645\u062b\u0627\u0644\u200c\u0647\u0627<\/h3>\n<ol>\n<li><strong>\u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u062f\u0648 \u0639\u062f\u062f \u062b\u0627\u0628\u062a<\/strong>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=AVERAGE(10, 20)<br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0646\u062a\u06cc\u062c\u0647: <code>15<\/code><\/li>\n<li><strong>\u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0645\u0648\u062c\u0648\u062f \u062f\u0631 \u0645\u062d\u062f\u0648\u062f\u0647\u200c\u0627\u06cc \u0627\u0632 \u0633\u0644\u0648\u0644\u200c\u0647\u0627<\/strong> \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u062f\u0631 \u0633\u062a\u0648\u0646 A \u0645\u0642\u0627\u062f\u06cc\u0631 \u0639\u062f\u062f\u06cc \u0632\u06cc\u0631 \u0631\u0627 \u062f\u0627\u0631\u06cc\u062f:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-makefile\"><span class=\"hljs-section\">A1: 5<\/span><br \/>\n<span class=\"hljs-section\">A2: 10<\/span><br \/>\n<span class=\"hljs-section\">A3: 15<\/span><br \/>\n<span class=\"hljs-section\">A4: 20<\/span><br \/>\n<span class=\"hljs-section\">A5: 25<\/span><br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0628\u0631\u0627\u06cc \u0645\u062d\u0627\u0633\u0628\u0647 \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u0627\u06cc\u0646 \u0645\u0642\u0627\u062f\u06cc\u0631\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=AVERAGE(A1:A5)<br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0646\u062a\u06cc\u062c\u0647: <code>15<\/code><\/li>\n<li><strong>\u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0686\u0646\u062f\u06cc\u0646 \u0645\u062d\u062f\u0648\u062f\u0647<\/strong> \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u062f\u0631 \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u06cc A \u0648 B \u0645\u0642\u0627\u062f\u06cc\u0631 \u0639\u062f\u062f\u06cc \u0632\u06cc\u0631 \u0631\u0627 \u062f\u0627\u0631\u06cc\u062f:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-makefile\"><span class=\"hljs-section\">A1: 5    B1: 2<\/span><br \/>\n<span class=\"hljs-section\">A2: 10   B2: 3<\/span><br \/>\n<span class=\"hljs-section\">A3: 15   B3: 4<\/span><br \/>\n<span class=\"hljs-section\">A4: 20   B4: 5<\/span><br \/>\n<span class=\"hljs-section\">A5: 25   B5: 6<\/span><br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0628\u0631\u0627\u06cc \u0645\u062d\u0627\u0633\u0628\u0647 \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0647\u0631 \u062f\u0648 \u0645\u062d\u062f\u0648\u062f\u0647\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=AVERAGE(A1:A5, B1:B5)<br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0646\u062a\u06cc\u062c\u0647: <code>10.5<\/code><\/li>\n<li><strong>\u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u063a\u06cc\u0631 \u0645\u062f\u0627\u0648\u0645<\/strong> \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u062f\u0631 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc A1\u060c A3 \u0648 A5 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0639\u062f\u062f\u06cc \u0632\u06cc\u0631 \u0631\u0627 \u062f\u0627\u0631\u06cc\u062f:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-makefile\"><span class=\"hljs-section\">A1: 5<\/span><br \/>\n<span class=\"hljs-section\">A3: 15<\/span><br \/>\n<span class=\"hljs-section\">A5: 25<\/span><br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0628\u0631\u0627\u06cc \u0645\u062d\u0627\u0633\u0628\u0647 \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u0627\u06cc\u0646 \u0645\u0642\u0627\u062f\u06cc\u0631\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=AVERAGE(A1, A3, A5)<br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0646\u062a\u06cc\u062c\u0647: <code>15<\/code><\/li>\n<\/ol>\n<h3>\u0646\u06a9\u0627\u062a \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc<\/h3>\n<ul>\n<li>\u0641\u0631\u0645\u0648\u0644 <code>AVERAGE<\/code> \u0645\u0642\u0627\u062f\u06cc\u0631 \u063a\u06cc\u0631 \u0639\u062f\u062f\u06cc (\u0645\u062a\u0646 \u06cc\u0627 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u062e\u0627\u0644\u06cc) \u0631\u0627 \u0646\u0627\u062f\u06cc\u062f\u0647 \u0645\u06cc\u200c\u06af\u06cc\u0631\u062f.<\/li>\n<li><code>AVERAGE<\/code> \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0628\u0627 \u0633\u0627\u06cc\u0631 \u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627 \u062a\u0631\u06a9\u06cc\u0628 \u0634\u0648\u062f \u062a\u0627 \u0645\u062d\u0627\u0633\u0628\u0627\u062a \u067e\u06cc\u0686\u06cc\u062f\u0647\u200c\u062a\u0631\u06cc \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u062f. \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=AVERAGE(SUM(A1:A5), SUM(B1:B5))<br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0627\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u0645\u062c\u0645\u0648\u0639 \u0645\u0642\u0627\u062f\u06cc\u0631 \u062f\u0648 \u0645\u062d\u062f\u0648\u062f\u0647 \u0631\u0627 \u0645\u062d\u0627\u0633\u0628\u0647 \u0645\u06cc\u200c\u06a9\u0646\u062f.<\/li>\n<li>\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 <code>AVERAGE<\/code> \u0628\u0647 \u062c\u0627\u06cc \u0645\u062d\u0627\u0633\u0628\u0647 \u062f\u0633\u062a\u06cc \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u0628\u0627\u0639\u062b \u06a9\u0627\u0647\u0634 \u062e\u0637\u0627\u0647\u0627\u06cc \u0627\u0646\u0633\u0627\u0646\u06cc \u0645\u06cc\u200c\u0634\u0648\u062f.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<p>&nbsp;<\/p>\n<a href=\"https:\/\/iranfso.com\/blog\/microsoft-teams\/\" class=\"shortc-button big green \">\u0634\u0645\u0627 \u0647\u0645\u0686\u0646\u06cc\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0631\u0627\u06cc \u0622\u0634\u0646\u0627\u06cc\u06cc \u0628\u0627 Microsoft Teams\u060c \u0645\u0642\u0627\u0644\u0647 &#8220;Microsoft Teams: \u067e\u0644\u062a\u0641\u0631\u0645\u06cc \u062c\u0627\u0645\u0639 \u0628\u0631\u0627\u06cc \u06a9\u0627\u0631 \u062a\u06cc\u0645\u06cc \u062f\u0631 \u062f\u0646\u06cc\u0627\u06cc \u062f\u06cc\u062c\u06cc\u062a\u0627\u0644&#8221; \u0645\u0637\u0627\u0644\u0639\u0647 \u0646\u0645\u0627\u06cc\u06cc\u062f.<\/a>\n<p>&nbsp;<\/p>\n<hr \/>\n<h2><strong>\u0641\u0631\u0645\u0648\u0644 COUNT<\/strong><\/h2>\n<p>\u0641\u0631\u0645\u0648\u0644 <code>COUNT<\/code> \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0628\u0631\u0627\u06cc \u0634\u0645\u0627\u0631\u0634 \u062a\u0639\u062f\u0627\u062f \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u062d\u0627\u0648\u06cc \u0639\u062f\u062f \u062f\u0631 \u06cc\u06a9 \u0645\u062d\u062f\u0648\u062f\u0647 \u06cc\u0627 \u0645\u062c\u0645\u0648\u0639\u0647\u200c\u0627\u06cc \u0627\u0632 \u0633\u0644\u0648\u0644\u200c\u0647\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0627\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u062a\u0646\u0647\u0627 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u0639\u062f\u062f\u06cc \u0631\u0627 \u0634\u0645\u0627\u0631\u0634 \u0645\u06cc\u200c\u06a9\u0646\u062f \u0648 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u062e\u0627\u0644\u06cc \u06cc\u0627 \u062d\u0627\u0648\u06cc \u0645\u062a\u0646 \u0631\u0627 \u0646\u0627\u062f\u06cc\u062f\u0647 \u0645\u06cc\u200c\u06af\u06cc\u0631\u062f.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-19290 size-full\" src=\"https:\/\/iranfso.com\/blog\/wp-content\/uploads\/2024\/07\/Count.gif\" alt=\"\u0641\u0631\u0645\u0648\u0644 COUNT\" width=\"700\" height=\"200\" \/><\/p>\n<h3>\u0633\u0627\u062e\u062a\u0627\u0631 \u0641\u0631\u0645\u0648\u0644<\/h3>\n<p>\u0633\u0627\u062e\u062a\u0627\u0631 \u06a9\u0644\u06cc \u0641\u0631\u0645\u0648\u0644 <code>COUNT<\/code> \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre hljs language-excel\">=COUNT(value1, [value2], ...)<br \/>\n<\/code><\/div>\n<\/div>\n<ul>\n<li><code>value1<\/code>, <code>value2<\/code>, &#8230; : \u0627\u06cc\u0646 \u067e\u0627\u0631\u0627\u0645\u062a\u0631\u0647\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u0622\u062f\u0631\u0633 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u060c \u0645\u062d\u062f\u0648\u062f\u0647\u200c\u0627\u06cc \u0627\u0632 \u0633\u0644\u0648\u0644\u200c\u0647\u0627 \u06cc\u0627 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0639\u062f\u062f\u06cc \u062b\u0627\u0628\u062a \u0628\u0627\u0634\u0646\u062f.<\/li>\n<\/ul>\n<h3>\u0645\u062b\u0627\u0644\u200c\u0647\u0627<\/h3>\n<ol>\n<li><strong>\u0634\u0645\u0627\u0631\u0634 \u062a\u0639\u062f\u0627\u062f \u0627\u0639\u062f\u0627\u062f \u062f\u0631 \u0645\u062d\u062f\u0648\u062f\u0647\u200c\u0627\u06cc \u0627\u0632 \u0633\u0644\u0648\u0644\u200c\u0647\u0627<\/strong> \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u062f\u0631 \u0633\u062a\u0648\u0646 A \u0645\u0642\u0627\u062f\u06cc\u0631 \u0632\u06cc\u0631 \u0631\u0627 \u062f\u0627\u0631\u06cc\u062f:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-makefile\"><span class=\"hljs-section\">A1: 5<\/span><br \/>\n<span class=\"hljs-section\">A2: 10<\/span><br \/>\n<span class=\"hljs-section\">A3: \u0645\u062a\u0646<\/span><br \/>\n<span class=\"hljs-section\">A4: 20<\/span><br \/>\n<span class=\"hljs-section\">A5: 25<\/span><br \/>\n<span class=\"hljs-section\">A6: \u062e\u0627\u0644\u06cc<\/span><br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0628\u0631\u0627\u06cc \u0634\u0645\u0627\u0631\u0634 \u062a\u0639\u062f\u0627\u062f \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u062d\u0627\u0648\u06cc \u0639\u062f\u062f \u062f\u0631 \u0627\u06cc\u0646 \u0645\u062d\u062f\u0648\u062f\u0647\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=COUNT(A1:A6)<br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0646\u062a\u06cc\u062c\u0647: <code>4<\/code><\/li>\n<li><strong>\u0634\u0645\u0627\u0631\u0634 \u062a\u0639\u062f\u0627\u062f \u0627\u0639\u062f\u0627\u062f \u062f\u0631 \u0686\u0646\u062f\u06cc\u0646 \u0645\u062d\u062f\u0648\u062f\u0647<\/strong> \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u062f\u0631 \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u06cc A \u0648 B \u0645\u0642\u0627\u062f\u06cc\u0631 \u0632\u06cc\u0631 \u0631\u0627 \u062f\u0627\u0631\u06cc\u062f:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-yaml\"><span class=\"hljs-attr\">A1: 5    B1:<\/span> <span class=\"hljs-number\">2<\/span><br \/>\n<span class=\"hljs-attr\">A2: 10   B2:<\/span> <span class=\"hljs-number\">3<\/span><br \/>\n<span class=\"hljs-attr\">A3:<\/span> <span class=\"hljs-string\">\u0645\u062a\u0646<\/span>  <span class=\"hljs-attr\">B3:<\/span> <span class=\"hljs-string\">\u0645\u062a\u0646<\/span><br \/>\n<span class=\"hljs-attr\">A4: 20   B4:<\/span> <span class=\"hljs-number\">5<\/span><br \/>\n<span class=\"hljs-attr\">A5: 25   B5:<\/span> <span class=\"hljs-number\">6<\/span><br \/>\n<span class=\"hljs-attr\">A6:<\/span> <span class=\"hljs-string\">\u062e\u0627\u0644\u06cc<\/span> <span class=\"hljs-attr\">B6:<\/span> <span class=\"hljs-string\">\u062e\u0627\u0644\u06cc<\/span><br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0628\u0631\u0627\u06cc \u0634\u0645\u0627\u0631\u0634 \u062a\u0639\u062f\u0627\u062f \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u062d\u0627\u0648\u06cc \u0639\u062f\u062f \u062f\u0631 \u0647\u0631 \u062f\u0648 \u0645\u062d\u062f\u0648\u062f\u0647\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=COUNT(A1:A6, B1:B6)<br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0646\u062a\u06cc\u062c\u0647: <code>8<\/code><\/li>\n<li><strong>\u0634\u0645\u0627\u0631\u0634 \u062a\u0639\u062f\u0627\u062f \u0627\u0639\u062f\u0627\u062f \u062f\u0631 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u063a\u06cc\u0631 \u0645\u062f\u0627\u0648\u0645<\/strong> \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u062f\u0631 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc A1\u060c A3\u060c A5 \u0648 B2 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0632\u06cc\u0631 \u0631\u0627 \u062f\u0627\u0631\u06cc\u062f:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-makefile\"><span class=\"hljs-section\">A1: 5<\/span><br \/>\n<span class=\"hljs-section\">A3: \u0645\u062a\u0646<\/span><br \/>\n<span class=\"hljs-section\">A5: 25<\/span><br \/>\n<span class=\"hljs-section\">B2: 3<\/span><br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0628\u0631\u0627\u06cc \u0634\u0645\u0627\u0631\u0634 \u062a\u0639\u062f\u0627\u062f \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u062d\u0627\u0648\u06cc \u0639\u062f\u062f \u062f\u0631 \u0627\u06cc\u0646 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=COUNT(A1, A3, A5, B2)<br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0646\u062a\u06cc\u062c\u0647: <code>3<\/code><\/li>\n<\/ol>\n<h3>\u0646\u06a9\u0627\u062a \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc<\/h3>\n<ul>\n<li>\u0641\u0631\u0645\u0648\u0644 <code>COUNT<\/code> \u0641\u0642\u0637 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u0639\u062f\u062f\u06cc \u0631\u0627 \u0634\u0645\u0627\u0631\u0634 \u0645\u06cc\u200c\u06a9\u0646\u062f \u0648 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u062d\u0627\u0648\u06cc \u0645\u062a\u0646 \u06cc\u0627 \u062e\u0627\u0644\u06cc \u0631\u0627 \u0646\u0627\u062f\u06cc\u062f\u0647 \u0645\u06cc\u200c\u06af\u06cc\u0631\u062f.<\/li>\n<li>\u0627\u06af\u0631 \u0628\u062e\u0648\u0627\u0647\u06cc\u062f \u062a\u0645\u0627\u0645 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u063a\u06cc\u0631 \u062e\u0627\u0644\u06cc (\u0639\u062f\u062f \u06cc\u0627 \u0645\u062a\u0646) \u0631\u0627 \u0634\u0645\u0627\u0631\u0634 \u06a9\u0646\u06cc\u062f\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 <code>COUNTA<\/code> \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f.<\/li>\n<li>\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 <code>COUNT<\/code> \u0628\u0647 \u0634\u0645\u0627 \u062f\u0631 \u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0648 \u062a\u0647\u06cc\u0647 \u06af\u0632\u0627\u0631\u0634\u200c\u0647\u0627\u06cc \u0622\u0645\u0627\u0631\u06cc \u06a9\u0645\u06a9 \u0645\u06cc\u200c\u06a9\u0646\u062f.<\/li>\n<\/ul>\n<h3>\u0645\u062b\u0627\u0644 \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc<\/h3>\n<p>\u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u062f\u0631 \u0633\u062a\u0648\u0646 A \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u0641\u0631\u0648\u0634 \u06cc\u06a9 \u0641\u0631\u0648\u0634\u06af\u0627\u0647 \u0631\u0627 \u062f\u0627\u0631\u06cc\u062f \u0648 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u062a\u0639\u062f\u0627\u062f \u0631\u0648\u0632\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0641\u0631\u0648\u0634 \u062b\u0628\u062a \u0634\u062f\u0647 \u0631\u0627 \u0645\u062d\u0627\u0633\u0628\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre hljs language-makefile\"><span class=\"hljs-section\">A1: 200<\/span><br \/>\n<span class=\"hljs-section\">A2: 150<\/span><br \/>\n<span class=\"hljs-section\">A3: \u062e\u0627\u0644\u06cc<\/span><br \/>\n<span class=\"hljs-section\">A4: 300<\/span><br \/>\n<span class=\"hljs-section\">A5: \u0645\u062a\u0646<\/span><br \/>\n<span class=\"hljs-section\">A6: 250<\/span><br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0628\u0631\u0627\u06cc \u0634\u0645\u0627\u0631\u0634 \u062a\u0639\u062f\u0627\u062f \u0631\u0648\u0632\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0641\u0631\u0648\u0634 \u062b\u0628\u062a \u0634\u062f\u0647 \u0627\u0633\u062a\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre hljs language-excel\">=COUNT(A1:A6)<br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0646\u062a\u06cc\u062c\u0647: <code>4<\/code><\/p>\n<h3>\u062a\u0631\u06a9\u06cc\u0628 \u0628\u0627 \u0633\u0627\u06cc\u0631 \u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627<\/h3>\n<p>\u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0641\u0631\u0645\u0648\u0644 <code>COUNT<\/code> \u0631\u0627 \u0628\u0627 \u0633\u0627\u06cc\u0631 \u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627 \u062a\u0631\u06a9\u06cc\u0628 \u06a9\u0646\u06cc\u062f \u062a\u0627 \u0646\u062a\u0627\u06cc\u062c \u067e\u06cc\u0634\u0631\u0641\u062a\u0647\u200c\u062a\u0631\u06cc \u0628\u062f\u0633\u062a \u0622\u0648\u0631\u06cc\u062f. \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre hljs language-excel\">=COUNT(A1:A10) \/ COUNTA(A1:A10)<br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0627\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u0646\u0633\u0628\u062a \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u0639\u062f\u062f\u06cc \u0628\u0647 \u06a9\u0644 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u063a\u06cc\u0631 \u062e\u0627\u0644\u06cc \u0631\u0627 \u0645\u062d\u0627\u0633\u0628\u0647 \u0645\u06cc\u200c\u06a9\u0646\u062f.<\/p>\n<hr \/>\n<div class=\"w-full text-token-text-primary\" dir=\"auto\" data-testid=\"conversation-turn-11\" data-scroll-anchor=\"true\">\n<div class=\"text-base py-[18px] px-3 md:px-4 m-auto md:px-5 lg:px-1 xl:px-5\">\n<div class=\"mx-auto flex flex-1 gap-4 text-base md:gap-5 lg:gap-6 md:max-w-3xl lg:max-w-[40rem] xl:max-w-[48rem]\">\n<div class=\"group\/conversation-turn relative flex w-full min-w-0 flex-col agent-turn\">\n<div class=\"flex-col gap-1 md:gap-3\">\n<div class=\"flex flex-grow flex-col max-w-full\">\n<div class=\"min-h-[20px] text-message flex w-full flex-col items-end gap-2 whitespace-pre-wrap break-words [.text-message+&amp;]:mt-5 overflow-x-auto\" dir=\"auto\" data-message-author-role=\"assistant\" data-message-id=\"32b864cf-f41a-4277-85ee-d630c4e9d1fa\">\n<div class=\"flex w-full flex-col gap-1 empty:hidden first:pt-[3px]\">\n<div class=\"markdown prose w-full break-words dark:prose-invert dark\">\n<h2><strong>\u0641\u0631\u0645\u0648\u0644 IF<\/strong><\/h2>\n<p>\u0641\u0631\u0645\u0648\u0644 <code>IF<\/code> \u062f\u0631 \u0627\u06a9\u0633\u0644 \u06cc\u06a9\u06cc \u0627\u0632 \u067e\u0631\u06a9\u0627\u0631\u0628\u0631\u062f\u062a\u0631\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627 \u0628\u0631\u0627\u06cc \u0627\u0639\u0645\u0627\u0644 \u0634\u0631\u0627\u06cc\u0637 \u0648 \u062a\u0635\u0645\u06cc\u0645\u200c\u06af\u06cc\u0631\u06cc\u200c\u0647\u0627\u06cc \u0645\u0646\u0637\u0642\u06cc \u0627\u0633\u062a. \u0627\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u0628\u0631 \u0627\u0633\u0627\u0633 \u06cc\u06a9 \u0634\u0631\u0637\u060c \u06cc\u06a9\u06cc \u0627\u0632 \u062f\u0648 \u0645\u0642\u062f\u0627\u0631 \u0631\u0627 \u0628\u0631\u0645\u06cc\u200c\u06af\u0631\u062f\u0627\u0646\u062f.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-19291 size-full\" src=\"https:\/\/iranfso.com\/blog\/wp-content\/uploads\/2024\/07\/If.gif\" alt=\"\u0641\u0631\u0645\u0648\u0644 IF\" width=\"424\" height=\"254\" \/><\/p>\n<h3>\u0633\u0627\u062e\u062a\u0627\u0631 \u0641\u0631\u0645\u0648\u0644<\/h3>\n<p>\u0633\u0627\u062e\u062a\u0627\u0631 \u06a9\u0644\u06cc \u0641\u0631\u0645\u0648\u0644 <code>IF<\/code> \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre hljs language-excel\">=IF(logical_test, value_if_true, value_if_false)<br \/>\n<\/code><\/div>\n<\/div>\n<ul>\n<li><code>logical_test<\/code>: \u0634\u0631\u0637\u06cc \u06a9\u0647 \u0628\u0627\u06cc\u062f \u0628\u0631\u0631\u0633\u06cc \u0634\u0648\u062f.<\/li>\n<li><code>value_if_true<\/code>: \u0645\u0642\u062f\u0627\u0631\u06cc \u06a9\u0647 \u062f\u0631 \u0635\u0648\u0631\u062a \u062f\u0631\u0633\u062a \u0628\u0648\u062f\u0646 \u0634\u0631\u0637 \u0628\u0631\u06af\u0631\u062f\u0627\u0646\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/li>\n<li><code>value_if_false<\/code>: \u0645\u0642\u062f\u0627\u0631\u06cc \u06a9\u0647 \u062f\u0631 \u0635\u0648\u0631\u062a \u0646\u0627\u062f\u0631\u0633\u062a \u0628\u0648\u062f\u0646 \u0634\u0631\u0637 \u0628\u0631\u06af\u0631\u062f\u0627\u0646\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/li>\n<\/ul>\n<h3>\u0645\u062b\u0627\u0644\u200c\u0647\u0627<\/h3>\n<ol>\n<li><strong>\u0628\u0631\u0631\u0633\u06cc \u06cc\u06a9 \u0634\u0631\u0637 \u0633\u0627\u062f\u0647<\/strong> \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u062f\u0631 \u0633\u0644\u0648\u0644 A1 \u06cc\u06a9 \u0639\u062f\u062f \u062f\u0627\u0631\u06cc\u062f \u0648 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0622\u06cc\u0627 \u0627\u06cc\u0646 \u0639\u062f\u062f \u0628\u0632\u0631\u06af\u062a\u0631 \u0627\u0632 10 \u0627\u0633\u062a \u06cc\u0627 \u0646\u0647.\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=IF(A1 &gt; 10, \"\u0628\u0632\u0631\u06af\u062a\u0631 \u0627\u0632 10\", \"\u06a9\u0648\u0686\u06a9\u062a\u0631 \u06cc\u0627 \u0645\u0633\u0627\u0648\u06cc 10\")<br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0627\u06af\u0631 \u0645\u0642\u062f\u0627\u0631 A1 \u0628\u0631\u0627\u0628\u0631 \u0628\u0627 15 \u0628\u0627\u0634\u062f\u060c \u0646\u062a\u06cc\u062c\u0647: <code>\u0628\u0632\u0631\u06af\u062a\u0631 \u0627\u0632 10<\/code><\/li>\n<li><strong>\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 IF \u0628\u0627 \u0645\u062a\u0646<\/strong> \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u062f\u0631 \u0633\u0644\u0648\u0644 A1 \u0646\u0627\u0645 \u06cc\u06a9 \u062f\u0627\u0646\u0634\u200c\u0622\u0645\u0648\u0632 \u0648 \u062f\u0631 \u0633\u0644\u0648\u0644 B1 \u0646\u0645\u0631\u0647 \u0627\u0648 \u0631\u0627 \u062f\u0627\u0631\u06cc\u062f \u0648 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0622\u06cc\u0627 \u0646\u0645\u0631\u0647 \u0627\u0648 \u0642\u0628\u0648\u0644\u06cc \u0627\u0633\u062a \u06cc\u0627 \u062e\u06cc\u0631 (\u0642\u0628\u0648\u0644\u06cc &gt;= 50).\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=IF(B1 &gt;= 50, \"\u0642\u0628\u0648\u0644\", \"\u0645\u0631\u062f\u0648\u062f\")<br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0627\u06af\u0631 \u0645\u0642\u062f\u0627\u0631 B1 \u0628\u0631\u0627\u0628\u0631 \u0628\u0627 45 \u0628\u0627\u0634\u062f\u060c \u0646\u062a\u06cc\u062c\u0647: <code>\u0645\u0631\u062f\u0648\u062f<\/code><\/li>\n<li><strong>\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0686\u0646\u062f\u06cc\u0646 IF \u062a\u0648 \u062f\u0631 \u062a\u0648<\/strong> \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u0628\u0631\u0627\u0633\u0627\u0633 \u0646\u0645\u0631\u0627\u062a \u062f\u0627\u0646\u0634\u200c\u0622\u0645\u0648\u0632\u0627\u0646\u060c \u062f\u0631\u062c\u0647 (A\u060c B\u060c C \u0648 \u063a\u06cc\u0631\u0647) \u0631\u0627 \u062a\u062e\u0635\u06cc\u0635 \u062f\u0647\u06cc\u062f.\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-less\">=<span class=\"hljs-selector-tag\">IF<\/span>(B1 &gt;= <span class=\"hljs-number\">90<\/span>, <span class=\"hljs-string\">\"A\"<\/span>, <span class=\"hljs-built_in\">IF<\/span>(B1 &gt;= <span class=\"hljs-number\">80<\/span>, <span class=\"hljs-string\">\"B\"<\/span>, <span class=\"hljs-built_in\">IF<\/span>(B1 &gt;= <span class=\"hljs-number\">70<\/span>, <span class=\"hljs-string\">\"C\"<\/span>, <span class=\"hljs-built_in\">IF<\/span>(B1 &gt;= <span class=\"hljs-number\">60<\/span>, <span class=\"hljs-string\">\"D\"<\/span>, <span class=\"hljs-string\">\"F\"<\/span>))))<br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0627\u06af\u0631 \u0645\u0642\u062f\u0627\u0631 B1 \u0628\u0631\u0627\u0628\u0631 \u0628\u0627 85 \u0628\u0627\u0634\u062f\u060c \u0646\u062a\u06cc\u062c\u0647: <code>B<\/code><\/li>\n<li><strong>\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 IF \u0628\u0627 \u0634\u0631\u0627\u06cc\u0637 \u062a\u0631\u06a9\u06cc\u0628\u06cc<\/strong> \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0622\u06cc\u0627 \u06cc\u06a9 \u0639\u062f\u062f \u0628\u06cc\u0646 10 \u0648 20 \u0627\u0633\u062a \u06cc\u0627 \u0646\u0647.\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=IF(AND(A1 &gt;= 10, A1 &lt;= 20), \"\u0628\u06cc\u0646 10 \u0648 20\", \"\u062e\u0627\u0631\u062c \u0627\u0632 \u0645\u062d\u062f\u0648\u062f\u0647\")<br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0627\u06af\u0631 \u0645\u0642\u062f\u0627\u0631 A1 \u0628\u0631\u0627\u0628\u0631 \u0628\u0627 15 \u0628\u0627\u0634\u062f\u060c \u0646\u062a\u06cc\u062c\u0647: <code>\u0628\u06cc\u0646 10 \u0648 20<\/code><\/li>\n<\/ol>\n<h3>\u0646\u06a9\u0627\u062a \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc<\/h3>\n<ul>\n<li>\u0641\u0631\u0645\u0648\u0644 <code>IF<\/code> \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0628\u0631\u0627\u06cc \u0627\u0631\u0632\u06cc\u0627\u0628\u06cc \u0634\u0631\u0627\u06cc\u0637 \u067e\u06cc\u0686\u06cc\u062f\u0647\u200c\u062a\u0631 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062a\u0648\u0627\u0628\u0639 \u0645\u0646\u0637\u0642\u06cc \u0645\u0627\u0646\u0646\u062f <code>AND<\/code> \u0648 <code>OR<\/code> \u062a\u0631\u06a9\u06cc\u0628 \u0634\u0648\u062f.<\/li>\n<li>\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 <code>IF<\/code> \u062a\u0648 \u062f\u0631 \u062a\u0648 (Nested IFs) \u0628\u0631\u0627\u06cc \u0634\u0631\u0627\u06cc\u0637 \u0686\u0646\u062f\u06af\u0627\u0646\u0647\u060c \u0627\u06af\u0631\u0686\u0647 \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u0627\u0633\u062a\u060c \u0627\u0645\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u067e\u06cc\u0686\u06cc\u062f\u0647 \u0648 \u062f\u0634\u0648\u0627\u0631 \u0628\u0631\u0627\u06cc \u0645\u062f\u06cc\u0631\u06cc\u062a \u0634\u0648\u062f. \u0628\u0647\u062a\u0631 \u0627\u0633\u062a \u062f\u0631 \u0635\u0648\u0631\u062a \u0627\u0645\u06a9\u0627\u0646 \u0627\u0632 \u062a\u0648\u0627\u0628\u0639 <code>IFS<\/code> (\u062f\u0631 \u0646\u0633\u062e\u0647\u200c\u0647\u0627\u06cc \u062c\u062f\u06cc\u062f\u062a\u0631 \u0627\u06a9\u0633\u0644) \u06cc\u0627 \u062c\u062f\u0627\u0648\u0644 \u0645\u0631\u062c\u0639 (lookup tables) \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f.<\/li>\n<li>\u0641\u0631\u0645\u0648\u0644 <code>IF<\/code> \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0628\u0627 \u062a\u0648\u0627\u0628\u0639 \u062f\u06cc\u06af\u0631 \u0645\u0627\u0646\u0646\u062f <code>SUM<\/code>, <code>AVERAGE<\/code>, <code>COUNTIF<\/code>, <code>VLOOKUP<\/code> \u0648 \u063a\u06cc\u0631\u0647 \u062a\u0631\u06a9\u06cc\u0628 \u0634\u0648\u062f.<\/li>\n<\/ul>\n<h3>\u0645\u062b\u0627\u0644 \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc<\/h3>\n<p>\u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u062f\u0631 \u0633\u062a\u0648\u0646 A \u0645\u0642\u0627\u062f\u06cc\u0631 \u0641\u0631\u0648\u0634 \u0631\u0648\u0632\u0627\u0646\u0647 \u0648 \u062f\u0631 \u0633\u062a\u0648\u0646 B \u0648\u0636\u0639\u06cc\u062a \u0641\u0631\u0648\u0634\u06af\u0627\u0647 (\u0628\u0627\u0632 \u06cc\u0627 \u0628\u0633\u062a\u0647) \u0631\u0627 \u062f\u0627\u0631\u06cc\u062f \u0648 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u0627\u06af\u0631 \u0641\u0631\u0648\u0634\u06af\u0627\u0647 \u0628\u0627\u0632 \u0628\u0627\u0634\u062f \u0648 \u0641\u0631\u0648\u0634 \u0628\u0627\u0644\u0627\u062a\u0631 \u0627\u0632 1000 \u062f\u0644\u0627\u0631 \u0628\u0627\u0634\u062f\u060c &#8220;\u0639\u0645\u0644\u06a9\u0631\u062f \u0639\u0627\u0644\u06cc&#8221; \u0648 \u062f\u0631 \u063a\u06cc\u0631 \u0627\u06cc\u0646 \u0635\u0648\u0631\u062a &#8220;\u0646\u06cc\u0627\u0632 \u0628\u0647 \u0628\u0647\u0628\u0648\u062f&#8221; \u0631\u0627 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0647\u06cc\u062f.<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre hljs language-makefile\"><span class=\"hljs-section\">A1: 1500    B1: \u0628\u0627\u0632<\/span><br \/>\n<span class=\"hljs-section\">A2: 800     B2: \u0628\u0633\u062a\u0647<\/span><br \/>\n<span class=\"hljs-section\">A3: 1200    B3: \u0628\u0627\u0632<\/span><br \/>\n<span class=\"hljs-section\">A4: 500     B4: \u0628\u0627\u0632<\/span><\/code><\/div>\n<\/div>\n<p>\u0628\u0631\u0627\u06cc \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre hljs language-excel\">=IF(AND(B1=\"\u0628\u0627\u0632\", A1&gt;1000), \"\u0639\u0645\u0644\u06a9\u0631\u062f \u0639\u0627\u0644\u06cc\", \"\u0646\u06cc\u0627\u0632 \u0628\u0647 \u0628\u0647\u0628\u0648\u062f\")<br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0646\u062a\u0627\u06cc\u062c:<\/p>\n<ul>\n<li>\u0633\u0644\u0648\u0644 C1: \u0639\u0645\u0644\u06a9\u0631\u062f \u0639\u0627\u0644\u06cc<\/li>\n<li>\u0633\u0644\u0648\u0644 C2: \u0646\u06cc\u0627\u0632 \u0628\u0647 \u0628\u0647\u0628\u0648\u062f<\/li>\n<li>\u0633\u0644\u0648\u0644 C3: \u0639\u0645\u0644\u06a9\u0631\u062f \u0639\u0627\u0644\u06cc<\/li>\n<li>\u0633\u0644\u0648\u0644 C4: \u0646\u06cc\u0627\u0632 \u0628\u0647 \u0628\u0647\u0628\u0648\u062f<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<a href=\"https:\/\/iranfso.com\/blog\/new-laptop-must-have-applications\/\" class=\"shortc-button big green \">\u0634\u0645\u0627 \u0647\u0645\u0686\u0646\u06cc\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0631\u0627\u06cc \u0622\u0634\u0646\u0627\u06cc\u06cc \u0628\u0627 \u0646\u0635\u0628 \u0628\u0631\u0646\u0627\u0645\u0647\u200c\u0647\u0627\u06cc \u0636\u0631\u0648\u0631\u06cc\u060c \u0645\u0642\u0627\u0644\u0647 &#8220;\u0622\u063a\u0627\u0632 \u0631\u0627\u0647 \u0628\u0627 \u0644\u067e \u062a\u0627\u067e \u0648 \u06a9\u0627\u0645\u067e\u06cc\u0648\u062a\u0631 \u062c\u062f\u06cc\u062f: \u0646\u0635\u0628 \u0628\u0631\u0646\u0627\u0645\u0647\u200c\u0647\u0627\u06cc \u0636\u0631\u0648\u0631\u06cc&#8221; \u0645\u0637\u0627\u0644\u0639\u0647 \u0646\u0645\u0627\u06cc\u06cc\u062f.<\/a>\n<p>&nbsp;<\/p>\n<div class=\"w-full text-token-text-primary\" dir=\"auto\" data-testid=\"conversation-turn-11\" data-scroll-anchor=\"true\">\n<div class=\"text-base py-[18px] px-3 md:px-4 m-auto md:px-5 lg:px-1 xl:px-5\">\n<div class=\"mx-auto flex flex-1 gap-4 text-base md:gap-5 lg:gap-6 md:max-w-3xl lg:max-w-[40rem] xl:max-w-[48rem]\">\n<div class=\"group\/conversation-turn relative flex w-full min-w-0 flex-col agent-turn\">\n<div class=\"flex-col gap-1 md:gap-3\">\n<div class=\"flex flex-grow flex-col max-w-full\">\n<div class=\"min-h-[20px] text-message flex w-full flex-col items-end gap-2 whitespace-pre-wrap break-words [.text-message+&amp;]:mt-5 overflow-x-auto\" dir=\"auto\" data-message-author-role=\"assistant\" data-message-id=\"32b864cf-f41a-4277-85ee-d630c4e9d1fa\">\n<div class=\"flex w-full flex-col gap-1 empty:hidden first:pt-[3px]\">\n<div class=\"markdown prose w-full break-words dark:prose-invert dark\">\n<hr \/>\n<h2><strong>\u0641\u0631\u0645\u0648\u0644 VLOOKUP<\/strong><\/h2>\n<p>\u0641\u0631\u0645\u0648\u0644 <code>VLOOKUP<\/code> \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0628\u0631\u0627\u06cc \u062c\u0633\u062a\u062c\u0648\u06cc \u06cc\u06a9 \u0645\u0642\u062f\u0627\u0631 \u062f\u0631 \u0633\u062a\u0648\u0646 \u0627\u0648\u0644 \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0648 \u0628\u0631\u06af\u0631\u062f\u0627\u0646\u062f\u0646 \u0645\u0642\u062f\u0627\u0631\u06cc \u0627\u0632 \u0633\u062a\u0648\u0646 \u062f\u06cc\u06af\u0631 \u0647\u0645\u0627\u0646 \u0631\u062f\u06cc\u0641 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0627\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u0628\u0631\u0627\u06cc \u062c\u0633\u062a\u062c\u0648\u06cc \u0639\u0645\u0648\u062f\u06cc \u062f\u0631 \u062c\u062f\u0648\u0644 \u06cc\u0627 \u0645\u062d\u062f\u0648\u062f\u0647\u200c\u0627\u06cc \u0627\u0632 \u0633\u0644\u0648\u0644\u200c\u0647\u0627 \u06a9\u0627\u0631\u0628\u0631\u062f \u062f\u0627\u0631\u062f.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-19292 size-full\" src=\"https:\/\/iranfso.com\/blog\/wp-content\/uploads\/2024\/07\/Vlookup.gif\" alt=\"\u0641\u0631\u0645\u0648\u0644 VLOOKUP\" width=\"700\" height=\"330\" \/><\/p>\n<h3>\u0633\u0627\u062e\u062a\u0627\u0631 \u0641\u0631\u0645\u0648\u0644<\/h3>\n<p>\u0633\u0627\u062e\u062a\u0627\u0631 \u06a9\u0644\u06cc \u0641\u0631\u0645\u0648\u0644 <code>VLOOKUP<\/code> \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])<br \/>\n<\/code><\/div>\n<\/div>\n<ul>\n<li><code>lookup_value<\/code>: \u0645\u0642\u062f\u0627\u0631\u06cc \u06a9\u0647 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u062c\u0633\u062a\u062c\u0648 \u06a9\u0646\u06cc\u062f.<\/li>\n<li><code>table_array<\/code>: \u0645\u062d\u062f\u0648\u062f\u0647 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u062f\u0631 \u0622\u0646 \u062c\u0633\u062a\u062c\u0648 \u06a9\u0646\u06cc\u062f.<\/li>\n<li><code>col_index_num<\/code>: \u0634\u0645\u0627\u0631\u0647 \u0633\u062a\u0648\u0646\u06cc \u06a9\u0647 \u0645\u0642\u062f\u0627\u0631 \u0645\u0648\u0631\u062f \u0646\u0638\u0631 \u0634\u0645\u0627 \u062f\u0631 \u0622\u0646 \u0642\u0631\u0627\u0631 \u062f\u0627\u0631\u062f (\u0634\u0631\u0648\u0639 \u0627\u0632 1 \u0628\u0631\u0627\u06cc \u0633\u062a\u0648\u0646 \u0627\u0648\u0644).<\/li>\n<li><code>[range_lookup]<\/code>: \u0645\u0642\u062f\u0627\u0631 \u0627\u062e\u062a\u06cc\u0627\u0631\u06cc \u06a9\u0647 \u0646\u0634\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f \u0622\u06cc\u0627 \u062c\u0633\u062a\u062c\u0648 \u0628\u0647 \u0635\u0648\u0631\u062a \u062f\u0642\u06cc\u0642 (FALSE) \u06cc\u0627 \u062a\u0642\u0631\u06cc\u0628\u06cc (TRUE) \u0628\u0627\u0634\u062f.<\/li>\n<\/ul>\n<h3>\u0645\u062b\u0627\u0644\u200c\u0647\u0627<\/h3>\n<ol>\n<li><strong>\u062c\u0633\u062a\u062c\u0648\u06cc \u062f\u0642\u06cc\u0642<\/strong> \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0627\u0632 \u0645\u062d\u0635\u0648\u0644\u0627\u062a \u0648 \u0642\u06cc\u0645\u062a\u200c\u0647\u0627\u06cc \u0622\u0646\u200c\u0647\u0627 \u062f\u0627\u0631\u06cc\u062f:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-yaml\"><span class=\"hljs-attr\">A1:<\/span> <span class=\"hljs-string\">\u0645\u062d\u0635\u0648\u0644<\/span>   <span class=\"hljs-attr\">B1:<\/span> <span class=\"hljs-string\">\u0642\u06cc\u0645\u062a<\/span><br \/>\n<span class=\"hljs-attr\">A2:<\/span> <span class=\"hljs-string\">\u0633\u06cc\u0628<\/span>      <span class=\"hljs-attr\">B2:<\/span> <span class=\"hljs-number\">2000<\/span><br \/>\n<span class=\"hljs-attr\">A3:<\/span> <span class=\"hljs-string\">\u067e\u0631\u062a\u0642\u0627\u0644<\/span>   <span class=\"hljs-attr\">B3:<\/span> <span class=\"hljs-number\">3000<\/span><br \/>\n<span class=\"hljs-attr\">A4:<\/span> <span class=\"hljs-string\">\u0645\u0648\u0632<\/span>      <span class=\"hljs-attr\">B4:<\/span> <span class=\"hljs-number\">2500<\/span><br \/>\n<span class=\"hljs-attr\">A5:<\/span> <span class=\"hljs-string\">\u0627\u0646\u06af\u0648\u0631<\/span>    <span class=\"hljs-attr\">B5:<\/span> <span class=\"hljs-number\">4000<\/span><\/code><\/div>\n<\/div>\n<p>\u0627\u06af\u0631 \u0628\u062e\u0648\u0627\u0647\u06cc\u062f \u0642\u06cc\u0645\u062a &#8220;\u067e\u0631\u062a\u0642\u0627\u0644&#8221; \u0631\u0627 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u06cc\u062f\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=VLOOKUP(\"\u067e\u0631\u062a\u0642\u0627\u0644\", A2:B5, 2, FALSE)<\/code><\/div>\n<div class=\"overflow-y-auto p-4\" style=\"text-align: right;\">\u0646\u062a\u06cc\u062c\u0647: <code>3000<\/code><\/div>\n<\/div>\n<\/li>\n<li><strong>\u062c\u0633\u062a\u062c\u0648\u06cc \u062a\u0642\u0631\u06cc\u0628\u06cc<\/strong> \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0627\u0632 \u0646\u0645\u0631\u0627\u062a \u0648 \u062f\u0631\u062c\u0647\u200c\u0647\u0627\u06cc \u0622\u0646\u200c\u0647\u0627 \u062f\u0627\u0631\u06cc\u062f:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-yaml\"><span class=\"hljs-attr\">A1:<\/span> <span class=\"hljs-string\">\u0646\u0645\u0631\u0647<\/span>   <span class=\"hljs-attr\">B1:<\/span> <span class=\"hljs-string\">\u062f\u0631\u062c\u0647<\/span><br \/>\n<span class=\"hljs-attr\">A2: 90     B2:<\/span> <span class=\"hljs-string\">A<\/span><br \/>\n<span class=\"hljs-attr\">A3: 80     B3:<\/span> <span class=\"hljs-string\">B<\/span><br \/>\n<span class=\"hljs-attr\">A4: 70     B4:<\/span> <span class=\"hljs-string\">C<\/span><br \/>\n<span class=\"hljs-attr\">A5: 60     B5:<\/span> <span class=\"hljs-string\">D<\/span><\/code><\/div>\n<\/div>\n<p>\u0627\u06af\u0631 \u0628\u062e\u0648\u0627\u0647\u06cc\u062f \u062f\u0631\u062c\u0647 \u0646\u0645\u0631\u0647 85 \u0631\u0627 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u06cc\u062f\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=VLOOKUP(85, A2:B5, 2, TRUE)<br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0646\u062a\u06cc\u062c\u0647: <code>B<\/code> (\u0686\u0648\u0646 85 \u0646\u0632\u062f\u06cc\u06a9\u062a\u0631\u06cc\u0646 \u0646\u0645\u0631\u0647 \u0628\u0627\u0644\u0627\u062a\u0631 \u0627\u0632 80 \u0627\u0633\u062a)<\/li>\n<li><strong>\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u0642\u062f\u0627\u0631 \u0633\u0644\u0648\u0644 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 <code>lookup_value<\/code><\/strong> \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u062f\u0631 \u0633\u0644\u0648\u0644 D1 \u0646\u0627\u0645 \u0645\u062d\u0635\u0648\u0644 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0631\u062f\u0647\u200c\u0627\u06cc\u062f \u0648 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u0642\u06cc\u0645\u062a \u0622\u0646 \u0631\u0627 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u06cc\u062f:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-yaml\"><span class=\"hljs-attr\">A1:<\/span> <span class=\"hljs-string\">\u0645\u062d\u0635\u0648\u0644<\/span>   <span class=\"hljs-attr\">B1:<\/span> <span class=\"hljs-string\">\u0642\u06cc\u0645\u062a<\/span><br \/>\n<span class=\"hljs-attr\">A2:<\/span> <span class=\"hljs-string\">\u0633\u06cc\u0628<\/span>      <span class=\"hljs-attr\">B2:<\/span> <span class=\"hljs-number\">2000<\/span><br \/>\n<span class=\"hljs-attr\">A3:<\/span> <span class=\"hljs-string\">\u067e\u0631\u062a\u0642\u0627\u0644<\/span>   <span class=\"hljs-attr\">B3:<\/span> <span class=\"hljs-number\">3000<\/span><br \/>\n<span class=\"hljs-attr\">A4:<\/span> <span class=\"hljs-string\">\u0645\u0648\u0632<\/span>      <span class=\"hljs-attr\">B4:<\/span> <span class=\"hljs-number\">2500<\/span><br \/>\n<span class=\"hljs-attr\">A5:<\/span> <span class=\"hljs-string\">\u0627\u0646\u06af\u0648\u0631<\/span>    <span class=\"hljs-attr\">B5:<\/span> <span class=\"hljs-number\">4000<\/span><br \/>\n<span class=\"hljs-attr\">D1:<\/span> <span class=\"hljs-string\">\u067e\u0631\u062a\u0642\u0627\u0644<\/span><\/code><\/div>\n<\/div>\n<p>\u0628\u0631\u0627\u06cc \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0646 \u0642\u06cc\u0645\u062a \u0645\u062d\u0635\u0648\u0644 \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u062f\u0631 \u0633\u0644\u0648\u0644 D1\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=VLOOKUP(D1, A2:B5, 2, FALSE)<\/code><\/div>\n<div class=\"overflow-y-auto p-4\" style=\"text-align: right;\">\u0646\u062a\u06cc\u062c\u0647: <code>3000<\/code><\/div>\n<\/div>\n<\/li>\n<\/ol>\n<h3>\u0646\u06a9\u0627\u062a \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc<\/h3>\n<ul>\n<li>\u0633\u062a\u0648\u0646 \u062c\u0633\u062a\u062c\u0648 (<code>lookup_value<\/code>) \u0628\u0627\u06cc\u062f \u0627\u0648\u0644\u06cc\u0646 \u0633\u062a\u0648\u0646 \u062f\u0631 \u0645\u062d\u062f\u0648\u062f\u0647 <code>table_array<\/code> \u0628\u0627\u0634\u062f.<\/li>\n<li>\u0627\u06af\u0631 \u0645\u0642\u062f\u0627\u0631 <code>lookup_value<\/code> \u062f\u0631 \u0633\u062a\u0648\u0646 \u062c\u0633\u062a\u062c\u0648 \u067e\u06cc\u062f\u0627 \u0646\u0634\u0648\u062f \u0648 \u062c\u0633\u062a\u062c\u0648 \u0628\u0647 \u0635\u0648\u0631\u062a \u062f\u0642\u06cc\u0642 \u0628\u0627\u0634\u062f (FALSE)\u060c \u0641\u0631\u0645\u0648\u0644 <code>#N\/A<\/code> \u0631\u0627 \u0628\u0631\u0645\u06cc\u200c\u06af\u0631\u062f\u0627\u0646\u062f.<\/li>\n<li>\u0628\u0631\u0627\u06cc \u062c\u0633\u062a\u062c\u0648\u0647\u0627\u06cc \u062a\u0642\u0631\u06cc\u0628\u06cc\u060c \u0645\u0642\u0627\u062f\u06cc\u0631 \u0633\u062a\u0648\u0646 \u062c\u0633\u062a\u062c\u0648 \u0628\u0627\u06cc\u062f \u0628\u0647 \u0635\u0648\u0631\u062a \u0635\u0639\u0648\u062f\u06cc \u0645\u0631\u062a\u0628 \u0634\u062f\u0647 \u0628\u0627\u0634\u0646\u062f.<\/li>\n<li><code>VLOOKUP<\/code> \u0647\u0645\u06cc\u0634\u0647 \u0627\u0648\u0644\u06cc\u0646 \u0645\u0642\u062f\u0627\u0631 \u067e\u06cc\u062f\u0627 \u0634\u062f\u0647 \u0631\u0627 \u0628\u0631\u0645\u06cc\u200c\u06af\u0631\u062f\u0627\u0646\u062f\u060c \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u062f\u0631 \u0635\u0648\u0631\u062a \u0648\u062c\u0648\u062f \u0645\u0642\u0627\u062f\u06cc\u0631 \u062a\u06a9\u0631\u0627\u0631\u06cc \u062f\u0631 \u0633\u062a\u0648\u0646 \u062c\u0633\u062a\u062c\u0648\u060c \u0627\u0648\u0644\u06cc\u0646 \u0645\u0642\u062f\u0627\u0631 \u0628\u0631\u06af\u0631\u062f\u0627\u0646\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/li>\n<\/ul>\n<h3>\u0645\u062b\u0627\u0644 \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc<\/h3>\n<p>\u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0627\u0632 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062f\u0627\u0646\u0634\u200c\u0622\u0645\u0648\u0632\u0627\u0646 \u0648 \u0646\u0645\u0631\u0627\u062a \u0622\u0646\u200c\u0647\u0627 \u062f\u0627\u0631\u06cc\u062f \u0648 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u0628\u0631\u0627\u0633\u0627\u0633 \u0634\u0645\u0627\u0631\u0647 \u062f\u0627\u0646\u0634\u200c\u0622\u0645\u0648\u0632 \u0646\u0645\u0631\u0647 \u0622\u0646\u200c\u0647\u0627 \u0631\u0627 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre hljs language-yaml\"><span class=\"hljs-attr\">A1:<\/span> <span class=\"hljs-string\">\u0634\u0645\u0627\u0631\u0647<\/span> <span class=\"hljs-string\">\u062f\u0627\u0646\u0634\u200c\u0622\u0645\u0648\u0632<\/span>   <span class=\"hljs-attr\">B1:<\/span> <span class=\"hljs-string\">\u0646\u0645\u0631\u0647<\/span><br \/>\n<span class=\"hljs-attr\">A2: 101               B2:<\/span> <span class=\"hljs-number\">85<\/span><br \/>\n<span class=\"hljs-attr\">A3: 102               B3:<\/span> <span class=\"hljs-number\">90<\/span><br \/>\n<span class=\"hljs-attr\">A4: 103               B4:<\/span> <span class=\"hljs-number\">78<\/span><br \/>\n<span class=\"hljs-attr\">A5: 104               B5:<\/span> <span class=\"hljs-number\">92<\/span><\/code><\/div>\n<\/div>\n<p>\u0627\u06af\u0631 \u0628\u062e\u0648\u0627\u0647\u06cc\u062f \u0646\u0645\u0631\u0647 \u062f\u0627\u0646\u0634\u200c\u0622\u0645\u0648\u0632 \u0628\u0627 \u0634\u0645\u0627\u0631\u0647 103 \u0631\u0627 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u06cc\u062f\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre hljs language-excel\">=VLOOKUP(103, A2:B5, 2, FALSE)<\/code><\/div>\n<div class=\"overflow-y-auto p-4\">\u0646\u062a\u06cc\u062c\u0647: <code>78<\/code><\/div>\n<\/div>\n<h3>\u062a\u0631\u06a9\u06cc\u0628 \u0628\u0627 \u0633\u0627\u06cc\u0631 \u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627<\/h3>\n<p>\u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f <code>VLOOKUP<\/code> \u0631\u0627 \u0628\u0627 \u0633\u0627\u06cc\u0631 \u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627 \u062a\u0631\u06a9\u06cc\u0628 \u06a9\u0646\u06cc\u062f \u062a\u0627 \u0646\u062a\u0627\u06cc\u062c \u067e\u06cc\u0686\u06cc\u062f\u0647\u200c\u062a\u0631\u06cc \u0628\u062f\u0633\u062a \u0622\u0648\u0631\u06cc\u062f. \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre hljs language-excel\">=IF(VLOOKUP(D1, A2:B5, 2, FALSE) &gt; 80, \"\u0642\u0628\u0648\u0644\", \"\u0645\u0631\u062f\u0648\u062f\")<br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0627\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u0628\u0631\u0631\u0633\u06cc \u0645\u06cc\u200c\u06a9\u0646\u062f \u06a9\u0647 \u0622\u06cc\u0627 \u0646\u0645\u0631\u0647 \u062f\u0627\u0646\u0634\u200c\u0622\u0645\u0648\u0632 \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u062f\u0631 \u0633\u0644\u0648\u0644 D1 \u0628\u06cc\u0634\u062a\u0631 \u0627\u0632 80 \u0627\u0633\u062a \u06cc\u0627 \u062e\u06cc\u0631\u060c \u0648 \u0628\u0631 \u0627\u0633\u0627\u0633 \u0622\u0646 &#8220;\u0642\u0628\u0648\u0644&#8221; \u06cc\u0627 &#8220;\u0645\u0631\u062f\u0648\u062f&#8221; \u0631\u0627 \u0628\u0631\u0645\u06cc\u200c\u06af\u0631\u062f\u0627\u0646\u062f.<\/p>\n<hr \/>\n<h2><strong>\u0641\u0631\u0645\u0648\u0644 HLOOKUP<\/strong><\/h2>\n<p>\u0641\u0631\u0645\u0648\u0644 <code>HLOOKUP<\/code> \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0628\u0631\u0627\u06cc \u062c\u0633\u062a\u062c\u0648\u06cc \u06cc\u06a9 \u0645\u0642\u062f\u0627\u0631 \u062f\u0631 \u0631\u062f\u06cc\u0641 \u0627\u0648\u0644 \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0648 \u0628\u0631\u06af\u0631\u062f\u0627\u0646\u062f\u0646 \u0645\u0642\u062f\u0627\u0631\u06cc \u0627\u0632 \u0633\u062a\u0648\u0646 \u062f\u06cc\u06af\u0631 \u0647\u0645\u0627\u0646 \u0633\u062a\u0648\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0627\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u0628\u0631\u0627\u06cc \u062c\u0633\u062a\u062c\u0648\u06cc \u0627\u0641\u0642\u06cc \u062f\u0631 \u062c\u062f\u0648\u0644 \u06cc\u0627 \u0645\u062d\u062f\u0648\u062f\u0647\u200c\u0627\u06cc \u0627\u0632 \u0633\u0644\u0648\u0644\u200c\u0647\u0627 \u06a9\u0627\u0631\u0628\u0631\u062f \u062f\u0627\u0631\u062f.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-19294 size-full\" src=\"https:\/\/iranfso.com\/blog\/wp-content\/uploads\/2024\/07\/Hlookup.gif\" alt=\"\u0641\u0631\u0645\u0648\u0644 HLOOKUP\" width=\"598\" height=\"226\" \/><\/p>\n<h3>\u0633\u0627\u062e\u062a\u0627\u0631 \u0641\u0631\u0645\u0648\u0644<\/h3>\n<p>\u0633\u0627\u062e\u062a\u0627\u0631 \u06a9\u0644\u06cc \u0641\u0631\u0645\u0648\u0644 <code>HLOOKUP<\/code> \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre hljs language-excel\">=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])<br \/>\n<\/code><\/div>\n<\/div>\n<ul>\n<li><code>lookup_value<\/code>: \u0645\u0642\u062f\u0627\u0631\u06cc \u06a9\u0647 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u062c\u0633\u062a\u062c\u0648 \u06a9\u0646\u06cc\u062f.<\/li>\n<li><code>table_array<\/code>: \u0645\u062d\u062f\u0648\u062f\u0647 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u062f\u0631 \u0622\u0646 \u062c\u0633\u062a\u062c\u0648 \u06a9\u0646\u06cc\u062f.<\/li>\n<li><code>row_index_num<\/code>: \u0634\u0645\u0627\u0631\u0647 \u0631\u062f\u06cc\u0641\u06cc \u06a9\u0647 \u0645\u0642\u062f\u0627\u0631 \u0645\u0648\u0631\u062f \u0646\u0638\u0631 \u0634\u0645\u0627 \u062f\u0631 \u0622\u0646 \u0642\u0631\u0627\u0631 \u062f\u0627\u0631\u062f (\u0634\u0631\u0648\u0639 \u0627\u0632 1 \u0628\u0631\u0627\u06cc \u0631\u062f\u06cc\u0641 \u0627\u0648\u0644).<\/li>\n<li><code>[range_lookup]<\/code>: \u0645\u0642\u062f\u0627\u0631 \u0627\u062e\u062a\u06cc\u0627\u0631\u06cc \u06a9\u0647 \u0646\u0634\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f \u0622\u06cc\u0627 \u062c\u0633\u062a\u062c\u0648 \u0628\u0647 \u0635\u0648\u0631\u062a \u062f\u0642\u06cc\u0642 (FALSE) \u06cc\u0627 \u062a\u0642\u0631\u06cc\u0628\u06cc (TRUE) \u0628\u0627\u0634\u062f.<\/li>\n<\/ul>\n<h3>\u0645\u062b\u0627\u0644\u200c\u0647\u0627<\/h3>\n<ol>\n<li><strong>\u062c\u0633\u062a\u062c\u0648\u06cc \u062f\u0642\u06cc\u0642<\/strong> \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0627\u0632 \u0645\u062d\u0635\u0648\u0644\u0627\u062a \u0648 \u0642\u06cc\u0645\u062a\u200c\u0647\u0627\u06cc \u0622\u0646\u200c\u0647\u0627 \u062f\u0627\u0631\u06cc\u062f:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-yaml\"><span class=\"hljs-attr\">A1:<\/span> <span class=\"hljs-string\">\u0645\u062d\u0635\u0648\u0644<\/span>   <span class=\"hljs-attr\">A2:<\/span> <span class=\"hljs-string\">\u0633\u06cc\u0628<\/span>    <span class=\"hljs-attr\">A3:<\/span> <span class=\"hljs-string\">\u067e\u0631\u062a\u0642\u0627\u0644<\/span>   <span class=\"hljs-attr\">A4:<\/span> <span class=\"hljs-string\">\u0645\u0648\u0632<\/span>    <span class=\"hljs-attr\">A5:<\/span> <span class=\"hljs-string\">\u0627\u0646\u06af\u0648\u0631<\/span><br \/>\n<span class=\"hljs-attr\">B1:<\/span> <span class=\"hljs-string\">\u0642\u06cc\u0645\u062a<\/span>    <span class=\"hljs-attr\">B2: 2000   B3: 3000     B4: 2500   B5:<\/span> <span class=\"hljs-number\">4000<\/span><\/code><\/div>\n<\/div>\n<p>\u0627\u06af\u0631 \u0628\u062e\u0648\u0627\u0647\u06cc\u062f \u0642\u06cc\u0645\u062a &#8220;\u067e\u0631\u062a\u0642\u0627\u0644&#8221; \u0631\u0627 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u06cc\u062f\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=HLOOKUP(\"\u067e\u0631\u062a\u0642\u0627\u0644\", A1:E2, 2, FALSE)<\/code><\/div>\n<div class=\"overflow-y-auto p-4\" style=\"text-align: right;\">\u0646\u062a\u06cc\u062c\u0647: <code>3000<\/code><\/div>\n<\/div>\n<\/li>\n<li><strong>\u062c\u0633\u062a\u062c\u0648\u06cc \u062a\u0642\u0631\u06cc\u0628\u06cc<\/strong> \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0627\u0632 \u0646\u0645\u0631\u0627\u062a \u0648 \u062f\u0631\u062c\u0647\u200c\u0647\u0627\u06cc \u0622\u0646\u200c\u0647\u0627 \u062f\u0627\u0631\u06cc\u062f:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-yaml\"><span class=\"hljs-attr\">A1:<\/span> <span class=\"hljs-string\">\u0646\u0645\u0631\u0647<\/span>  <span class=\"hljs-attr\">A2: 90  A3: 80  A4: 70  A5:<\/span> <span class=\"hljs-number\">60<\/span><br \/>\n<span class=\"hljs-attr\">B1:<\/span> <span class=\"hljs-string\">\u062f\u0631\u062c\u0647<\/span> <span class=\"hljs-attr\">B2: A   B3: B   B4: C   B5:<\/span> <span class=\"hljs-string\">D<\/span><\/code><\/div>\n<\/div>\n<p>\u0627\u06af\u0631 \u0628\u062e\u0648\u0627\u0647\u06cc\u062f \u062f\u0631\u062c\u0647 \u0646\u0645\u0631\u0647 85 \u0631\u0627 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u06cc\u062f\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=HLOOKUP(85, A1:E2, 2, TRUE)<br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0646\u062a\u06cc\u062c\u0647: <code>B<\/code> (\u0686\u0648\u0646 85 \u0646\u0632\u062f\u06cc\u06a9\u062a\u0631\u06cc\u0646 \u0646\u0645\u0631\u0647 \u0628\u0627\u0644\u0627\u062a\u0631 \u0627\u0632 80 \u0627\u0633\u062a)<\/li>\n<li><strong>\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u0642\u062f\u0627\u0631 \u0633\u0644\u0648\u0644 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 <code>lookup_value<\/code><\/strong> \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u062f\u0631 \u0633\u0644\u0648\u0644 D1 \u0646\u0627\u0645 \u0645\u062d\u0635\u0648\u0644 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0631\u062f\u0647\u200c\u0627\u06cc\u062f \u0648 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u0642\u06cc\u0645\u062a \u0622\u0646 \u0631\u0627 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u06cc\u062f:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-yaml\"><span class=\"hljs-attr\">A1:<\/span> <span class=\"hljs-string\">\u0645\u062d\u0635\u0648\u0644<\/span>   <span class=\"hljs-attr\">A2:<\/span> <span class=\"hljs-string\">\u0633\u06cc\u0628<\/span>    <span class=\"hljs-attr\">A3:<\/span> <span class=\"hljs-string\">\u067e\u0631\u062a\u0642\u0627\u0644<\/span>   <span class=\"hljs-attr\">A4:<\/span> <span class=\"hljs-string\">\u0645\u0648\u0632<\/span>    <span class=\"hljs-attr\">A5:<\/span> <span class=\"hljs-string\">\u0627\u0646\u06af\u0648\u0631<\/span><br \/>\n<span class=\"hljs-attr\">B1:<\/span> <span class=\"hljs-string\">\u0642\u06cc\u0645\u062a<\/span>    <span class=\"hljs-attr\">B2: 2000   B3: 3000     B4: 2500   B5:<\/span> <span class=\"hljs-number\">4000<\/span><br \/>\n<span class=\"hljs-attr\">D1:<\/span> <span class=\"hljs-string\">\u067e\u0631\u062a\u0642\u0627\u0644<\/span><\/code><\/div>\n<\/div>\n<p>\u0628\u0631\u0627\u06cc \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0646 \u0642\u06cc\u0645\u062a \u0645\u062d\u0635\u0648\u0644 \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u062f\u0631 \u0633\u0644\u0648\u0644 D1\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=HLOOKUP(D1, A1:E2, 2, FALSE)<\/code><\/div>\n<div class=\"overflow-y-auto p-4\" style=\"text-align: right;\">\u0646\u062a\u06cc\u062c\u0647: <code>3000<\/code><\/div>\n<\/div>\n<\/li>\n<\/ol>\n<h3>\u0646\u06a9\u0627\u062a \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc<\/h3>\n<ul>\n<li>\u0633\u062a\u0648\u0646 \u062c\u0633\u062a\u062c\u0648 (<code>lookup_value<\/code>) \u0628\u0627\u06cc\u062f \u0627\u0648\u0644\u06cc\u0646 \u0633\u062a\u0648\u0646 \u062f\u0631 \u0645\u062d\u062f\u0648\u062f\u0647 <code>table_array<\/code> \u0628\u0627\u0634\u062f.<\/li>\n<li>\u0627\u06af\u0631 \u0645\u0642\u062f\u0627\u0631 <code>lookup_value<\/code> \u062f\u0631 \u0633\u062a\u0648\u0646 \u062c\u0633\u062a\u062c\u0648 \u067e\u06cc\u062f\u0627 \u0646\u0634\u0648\u062f \u0648 \u062c\u0633\u062a\u062c\u0648 \u0628\u0647 \u0635\u0648\u0631\u062a \u062f\u0642\u06cc\u0642 \u0628\u0627\u0634\u062f (FALSE)\u060c \u0641\u0631\u0645\u0648\u0644 <code>#N\/A<\/code> \u0631\u0627 \u0628\u0631\u0645\u06cc\u200c\u06af\u0631\u062f\u0627\u0646\u062f.<\/li>\n<li>\u0628\u0631\u0627\u06cc \u062c\u0633\u062a\u062c\u0648\u0647\u0627\u06cc \u062a\u0642\u0631\u06cc\u0628\u06cc\u060c \u0645\u0642\u0627\u062f\u06cc\u0631 \u0633\u062a\u0648\u0646 \u062c\u0633\u062a\u062c\u0648 \u0628\u0627\u06cc\u062f \u0628\u0647 \u0635\u0648\u0631\u062a \u0635\u0639\u0648\u062f\u06cc \u0645\u0631\u062a\u0628 \u0634\u062f\u0647 \u0628\u0627\u0634\u0646\u062f.<\/li>\n<li><code>HLOOKUP<\/code> \u0647\u0645\u06cc\u0634\u0647 \u0627\u0648\u0644\u06cc\u0646 \u0645\u0642\u062f\u0627\u0631 \u067e\u06cc\u062f\u0627 \u0634\u062f\u0647 \u0631\u0627 \u0628\u0631\u0645\u06cc\u200c\u06af\u0631\u062f\u0627\u0646\u062f\u060c \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u062f\u0631 \u0635\u0648\u0631\u062a \u0648\u062c\u0648\u062f \u0645\u0642\u0627\u062f\u06cc\u0631 \u062a\u06a9\u0631\u0627\u0631\u06cc \u062f\u0631 \u0633\u062a\u0648\u0646 \u062c\u0633\u062a\u062c\u0648\u060c \u0627\u0648\u0644\u06cc\u0646 \u0645\u0642\u062f\u0627\u0631 \u0628\u0631\u06af\u0631\u062f\u0627\u0646\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/li>\n<\/ul>\n<h3>\u0645\u062b\u0627\u0644 \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc<\/h3>\n<p>\u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0627\u0632 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062f\u0627\u0646\u0634\u200c\u0622\u0645\u0648\u0632\u0627\u0646 \u0648 \u0646\u0645\u0631\u0627\u062a \u0622\u0646\u200c\u0647\u0627 \u062f\u0627\u0631\u06cc\u062f \u0648 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u0628\u0631\u0627\u0633\u0627\u0633 \u0634\u0645\u0627\u0631\u0647 \u062f\u0627\u0646\u0634\u200c\u0622\u0645\u0648\u0632 \u0646\u0645\u0631\u0647 \u0622\u0646\u200c\u0647\u0627 \u0631\u0627 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre hljs language-yaml\"><span class=\"hljs-attr\">A1:<\/span> <span class=\"hljs-string\">\u0634\u0645\u0627\u0631\u0647<\/span> <span class=\"hljs-string\">\u062f\u0627\u0646\u0634\u200c\u0622\u0645\u0648\u0632<\/span>  <span class=\"hljs-attr\">A2: 101  A3: 102  A4: 103  A5:<\/span> <span class=\"hljs-number\">104<\/span><br \/>\n<span class=\"hljs-attr\">B1:<\/span> <span class=\"hljs-string\">\u0646\u0645\u0631\u0647<\/span>              <span class=\"hljs-attr\">B2: 85   B3: 90   B4: 78   B5:<\/span> <span class=\"hljs-number\">92<\/span><\/code><\/div>\n<\/div>\n<p>\u0627\u06af\u0631 \u0628\u062e\u0648\u0627\u0647\u06cc\u062f \u0646\u0645\u0631\u0647 \u062f\u0627\u0646\u0634\u200c\u0622\u0645\u0648\u0632 \u0628\u0627 \u0634\u0645\u0627\u0631\u0647 103 \u0631\u0627 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u06cc\u062f\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre hljs language-excel\">=HLOOKUP(103, A1:E2, 2, FALSE)<\/code><\/div>\n<div class=\"overflow-y-auto p-4\">\u0646\u062a\u06cc\u062c\u0647: <code>78<\/code><\/div>\n<\/div>\n<h3>\u062a\u0631\u06a9\u06cc\u0628 \u0628\u0627 \u0633\u0627\u06cc\u0631 \u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627<\/h3>\n<p>\u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f <code>HLOOKUP<\/code> \u0631\u0627 \u0628\u0627 \u0633\u0627\u06cc\u0631 \u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627 \u062a\u0631\u06a9\u06cc\u0628 \u06a9\u0646\u06cc\u062f \u062a\u0627 \u0646\u062a\u0627\u06cc\u062c \u067e\u06cc\u0686\u06cc\u062f\u0647\u200c\u062a\u0631\u06cc \u0628\u062f\u0633\u062a \u0622\u0648\u0631\u06cc\u062f. \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre hljs language-excel\">=IF(HLOOKUP(D1, A1:E2, 2, FALSE) &gt; 80, \"\u0642\u0628\u0648\u0644\", \"\u0645\u0631\u062f\u0648\u062f\")<br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0627\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u0628\u0631\u0631\u0633\u06cc \u0645\u06cc\u200c\u06a9\u0646\u062f \u06a9\u0647 \u0622\u06cc\u0627 \u0646\u0645\u0631\u0647 \u062f\u0627\u0646\u0634\u200c\u0622\u0645\u0648\u0632 \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u062f\u0631 \u0633\u0644\u0648\u0644 D1 \u0628\u06cc\u0634\u062a\u0631 \u0627\u0632 80 \u0627\u0633\u062a \u06cc\u0627 \u062e\u06cc\u0631\u060c \u0648 \u0628\u0631 \u0627\u0633\u0627\u0633 \u0622\u0646 &#8220;\u0642\u0628\u0648\u0644&#8221; \u06cc\u0627 &#8220;\u0645\u0631\u062f\u0648\u062f&#8221; \u0631\u0627 \u0628\u0631\u0645\u06cc\u200c\u06af\u0631\u062f\u0627\u0646\u062f.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<a href=\"https:\/\/iranfso.com\/blog\/what-is-google-drive\/\" class=\"shortc-button big green \">\u0634\u0645\u0627 \u0647\u0645\u0686\u0646\u06cc\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0631\u0627\u06cc \u0622\u0634\u0646\u0627\u06cc\u06cc \u0628\u0627 \u06af\u0648\u06af\u0644 \u062f\u0631\u0627\u06cc\u0648\u060c \u0645\u0642\u0627\u0644\u0647 &#8220;\u06af\u0648\u06af\u0644 \u062f\u0631\u0627\u06cc\u0648 (Google Drive) \u0686\u06cc\u0633\u062a \u0648 \u0631\u0648\u0634 \u0641\u0639\u0627\u0644\u0633\u0627\u0632\u06cc \u0622\u0646&#8221; \u0645\u0637\u0627\u0644\u0639\u0647 \u0646\u0645\u0627\u06cc\u06cc\u062f.<\/a>\n<p>&nbsp;<\/p>\n<div class=\"w-full text-token-text-primary\" dir=\"auto\" data-testid=\"conversation-turn-11\" data-scroll-anchor=\"true\">\n<div class=\"text-base py-[18px] px-3 md:px-4 m-auto md:px-5 lg:px-1 xl:px-5\">\n<div class=\"mx-auto flex flex-1 gap-4 text-base md:gap-5 lg:gap-6 md:max-w-3xl lg:max-w-[40rem] xl:max-w-[48rem]\">\n<div class=\"group\/conversation-turn relative flex w-full min-w-0 flex-col agent-turn\">\n<div class=\"flex-col gap-1 md:gap-3\">\n<div class=\"flex flex-grow flex-col max-w-full\">\n<div class=\"min-h-[20px] text-message flex w-full flex-col items-end gap-2 whitespace-pre-wrap break-words [.text-message+&amp;]:mt-5 overflow-x-auto\" dir=\"auto\" data-message-author-role=\"assistant\" data-message-id=\"32b864cf-f41a-4277-85ee-d630c4e9d1fa\">\n<div class=\"flex w-full flex-col gap-1 empty:hidden first:pt-[3px]\">\n<div class=\"markdown prose w-full break-words dark:prose-invert dark\">\n<hr \/>\n<h2><strong>\u0641\u0631\u0645\u0648\u0644 MAX<\/strong><\/h2>\n<p>\u0641\u0631\u0645\u0648\u0644 <code>MAX<\/code> \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0628\u0631\u0627\u06cc \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0646 \u0628\u0632\u0631\u06af\u062a\u0631\u06cc\u0646 \u0639\u062f\u062f \u062f\u0631 \u06cc\u06a9 \u0645\u062d\u062f\u0648\u062f\u0647 \u06cc\u0627 \u0645\u062c\u0645\u0648\u0639\u0647\u200c\u0627\u06cc \u0627\u0632 \u0627\u0639\u062f\u0627\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0627\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0645\u0641\u06cc\u062f \u0628\u0627\u0634\u062f \u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u0628\u062e\u0648\u0627\u0647\u06cc\u062f \u062d\u062f\u0627\u06a9\u062b\u0631 \u0645\u0642\u062f\u0627\u0631 \u06cc\u06a9 \u0645\u062c\u0645\u0648\u0639\u0647 \u0627\u0632 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u06cc\u062f.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-19295 size-full\" src=\"https:\/\/iranfso.com\/blog\/wp-content\/uploads\/2024\/07\/MAX.gif\" alt=\"\u0641\u0631\u0645\u0648\u0644 MAX\" width=\"443\" height=\"512\" \/><\/p>\n<h3>\u0633\u0627\u062e\u062a\u0627\u0631 \u0641\u0631\u0645\u0648\u0644<\/h3>\n<p>\u0633\u0627\u062e\u062a\u0627\u0631 \u06a9\u0644\u06cc \u0641\u0631\u0645\u0648\u0644 <code>MAX<\/code> \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre hljs language-excel\">=MAX(number1, [number2], ...)<br \/>\n<\/code><\/div>\n<\/div>\n<ul>\n<li><code>number1<\/code>, <code>number2<\/code>, &#8230; : \u0627\u06cc\u0646 \u067e\u0627\u0631\u0627\u0645\u062a\u0631\u0647\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u0627\u0639\u062f\u0627\u062f \u062b\u0627\u0628\u062a\u060c \u0622\u062f\u0631\u0633 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u060c \u06cc\u0627 \u0645\u062d\u062f\u0648\u062f\u0647\u200c\u0627\u06cc \u0627\u0632 \u0633\u0644\u0648\u0644\u200c\u0647\u0627 \u0628\u0627\u0634\u0646\u062f.<\/li>\n<\/ul>\n<h3>\u0645\u062b\u0627\u0644\u200c\u0647\u0627<\/h3>\n<ol>\n<li><strong>\u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0646 \u0628\u0632\u0631\u06af\u062a\u0631\u06cc\u0646 \u0639\u062f\u062f \u062f\u0631 \u06cc\u06a9 \u0645\u062d\u062f\u0648\u062f\u0647 \u0633\u0644\u0648\u0644\u200c\u0647\u0627<\/strong> \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u062f\u0631 \u0633\u062a\u0648\u0646 A \u0645\u0642\u0627\u062f\u06cc\u0631 \u0632\u06cc\u0631 \u0631\u0627 \u062f\u0627\u0631\u06cc\u062f:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-makefile\"><span class=\"hljs-section\">A1: 5<\/span><br \/>\n<span class=\"hljs-section\">A2: 10<\/span><br \/>\n<span class=\"hljs-section\">A3: 15<\/span><br \/>\n<span class=\"hljs-section\">A4: 20<\/span><br \/>\n<span class=\"hljs-section\">A5: 25<\/span><\/code><\/div>\n<\/div>\n<p>\u0628\u0631\u0627\u06cc \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0646 \u0628\u0632\u0631\u06af\u062a\u0631\u06cc\u0646 \u0639\u062f\u062f \u062f\u0631 \u0627\u06cc\u0646 \u0645\u062d\u062f\u0648\u062f\u0647\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=MAX(A1:A5)<\/code><\/div>\n<div class=\"overflow-y-auto p-4\" style=\"text-align: right;\">\u0646\u062a\u06cc\u062c\u0647: <code>25<\/code><\/div>\n<\/div>\n<\/li>\n<li><strong>\u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0646 \u0628\u0632\u0631\u06af\u062a\u0631\u06cc\u0646 \u0639\u062f\u062f \u062f\u0631 \u0686\u0646\u062f\u06cc\u0646 \u0645\u062d\u062f\u0648\u062f\u0647<\/strong> \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u062f\u0631 \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u06cc A \u0648 B \u0645\u0642\u0627\u062f\u06cc\u0631 \u0632\u06cc\u0631 \u0631\u0627 \u062f\u0627\u0631\u06cc\u062f:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-makefile\"><span class=\"hljs-section\">A1: 5    B1: 2<\/span><br \/>\n<span class=\"hljs-section\">A2: 10   B2: 3<\/span><br \/>\n<span class=\"hljs-section\">A3: 15   B3: 4<\/span><br \/>\n<span class=\"hljs-section\">A4: 20   B4: 5<\/span><br \/>\n<span class=\"hljs-section\">A5: 25   B5: 6<\/span><\/code><\/div>\n<\/div>\n<p>\u0628\u0631\u0627\u06cc \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0646 \u0628\u0632\u0631\u06af\u062a\u0631\u06cc\u0646 \u0639\u062f\u062f \u062f\u0631 \u0647\u0631 \u062f\u0648 \u0645\u062d\u062f\u0648\u062f\u0647\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=MAX(A1:A5, B1:B5)<\/code><\/div>\n<div class=\"overflow-y-auto p-4\" style=\"text-align: right;\">\u0646\u062a\u06cc\u062c\u0647: <code>25<\/code><\/div>\n<\/div>\n<\/li>\n<li><strong>\u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0646 \u0628\u0632\u0631\u06af\u062a\u0631\u06cc\u0646 \u0639\u062f\u062f \u062f\u0631 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u063a\u06cc\u0631 \u0645\u062f\u0627\u0648\u0645<\/strong> \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u062f\u0631 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc A1\u060c A3 \u0648 A5 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0632\u06cc\u0631 \u0631\u0627 \u062f\u0627\u0631\u06cc\u062f:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-makefile\"><span class=\"hljs-section\">A1: 5<\/span><br \/>\n<span class=\"hljs-section\">A3: 15<\/span><br \/>\n<span class=\"hljs-section\">A5: 25<\/span><\/code><\/div>\n<\/div>\n<p>\u0628\u0631\u0627\u06cc \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0646 \u0628\u0632\u0631\u06af\u062a\u0631\u06cc\u0646 \u0639\u062f\u062f \u062f\u0631 \u0627\u06cc\u0646 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=MAX(A1, A3, A5)<\/code><\/div>\n<div class=\"overflow-y-auto p-4\" style=\"text-align: right;\">\u0646\u062a\u06cc\u062c\u0647: <code>25<\/code><\/div>\n<\/div>\n<\/li>\n<li><strong>\u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0646 \u0628\u0632\u0631\u06af\u062a\u0631\u06cc\u0646 \u0639\u062f\u062f \u0627\u0632 \u062a\u0631\u06a9\u06cc\u0628 \u0627\u0639\u062f\u0627\u062f \u0648 \u0633\u0644\u0648\u0644\u200c\u0647\u0627<\/strong> \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u0628\u0632\u0631\u06af\u062a\u0631\u06cc\u0646 \u0639\u062f\u062f \u0628\u06cc\u0646 \u0686\u0646\u062f \u0639\u062f\u062f \u062b\u0627\u0628\u062a \u0648 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0645\u0648\u062c\u0648\u062f \u062f\u0631 \u0686\u0646\u062f \u0633\u0644\u0648\u0644 \u0631\u0627 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u06cc\u062f:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-makefile\"><span class=\"hljs-section\">A1: 5<\/span><br \/>\n<span class=\"hljs-section\">A2: 10<\/span><\/code><\/div>\n<\/div>\n<p>\u0628\u0631\u0627\u06cc \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0646 \u0628\u0632\u0631\u06af\u062a\u0631\u06cc\u0646 \u0639\u062f\u062f \u0628\u06cc\u0646 \u0627\u0639\u062f\u0627\u062f \u062b\u0627\u0628\u062a 20\u060c 30 \u0648 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0645\u0648\u062c\u0648\u062f \u062f\u0631 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc A1 \u0648 A2\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=MAX(20, 30, A1, A2)<\/code><\/div>\n<div class=\"overflow-y-auto p-4\" style=\"text-align: right;\">\u0646\u062a\u06cc\u062c\u0647: <code>30<\/code><\/div>\n<\/div>\n<\/li>\n<\/ol>\n<h3>\u0646\u06a9\u0627\u062a \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc<\/h3>\n<ul>\n<li>\u0641\u0631\u0645\u0648\u0644 <code>MAX<\/code> \u0641\u0642\u0637 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0639\u062f\u062f\u06cc \u0631\u0627 \u062f\u0631 \u0646\u0638\u0631 \u0645\u06cc\u200c\u06af\u06cc\u0631\u062f \u0648 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u062e\u0627\u0644\u06cc \u06cc\u0627 \u062d\u0627\u0648\u06cc \u0645\u062a\u0646 \u0631\u0627 \u0646\u0627\u062f\u06cc\u062f\u0647 \u0645\u06cc\u200c\u06af\u06cc\u0631\u062f.<\/li>\n<li>\u0627\u06af\u0631 \u062a\u0645\u0627\u0645 \u0622\u0631\u06af\u0648\u0645\u0627\u0646\u200c\u0647\u0627\u06cc \u0641\u0631\u0645\u0648\u0644 <code>MAX<\/code> \u063a\u06cc\u0631 \u0639\u062f\u062f\u06cc \u0628\u0627\u0634\u0646\u062f\u060c \u0641\u0631\u0645\u0648\u0644 \u0646\u062a\u06cc\u062c\u0647 <code>0<\/code> \u0631\u0627 \u0628\u0631\u0645\u06cc\u200c\u06af\u0631\u062f\u0627\u0646\u062f.<\/li>\n<li>\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 <code>MAX<\/code> \u062f\u0631 \u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0628\u0647 \u0634\u0645\u0627 \u06a9\u0645\u06a9 \u0645\u06cc\u200c\u06a9\u0646\u062f \u062a\u0627 \u0628\u0632\u0631\u06af\u062a\u0631\u06cc\u0646 \u0645\u0642\u062f\u0627\u0631 \u062f\u0631 \u0645\u062c\u0645\u0648\u0639\u0647\u200c\u0627\u06cc \u0627\u0632 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u0628\u0647 \u0631\u0627\u062d\u062a\u06cc \u0634\u0646\u0627\u0633\u0627\u06cc\u06cc \u06a9\u0646\u06cc\u062f.<\/li>\n<\/ul>\n<h3>\u0645\u062b\u0627\u0644 \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc<\/h3>\n<p>\u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u062f\u0631 \u0633\u062a\u0648\u0646 A \u0646\u0645\u0631\u0627\u062a \u062f\u0627\u0646\u0634\u200c\u0622\u0645\u0648\u0632\u0627\u0646 \u0631\u0627 \u062f\u0627\u0631\u06cc\u062f \u0648 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u0628\u0627\u0644\u0627\u062a\u0631\u06cc\u0646 \u0646\u0645\u0631\u0647 \u0631\u0627 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre hljs language-makefile\"><span class=\"hljs-section\">A1: 85<\/span><br \/>\n<span class=\"hljs-section\">A2: 90<\/span><br \/>\n<span class=\"hljs-section\">A3: 78<\/span><br \/>\n<span class=\"hljs-section\">A4: 92<\/span><br \/>\n<span class=\"hljs-section\">A5: 88<\/span><\/code><\/div>\n<\/div>\n<p>\u0628\u0631\u0627\u06cc \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0646 \u0628\u0627\u0644\u0627\u062a\u0631\u06cc\u0646 \u0646\u0645\u0631\u0647\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre hljs language-excel\">=MAX(A1:A5)<\/code><\/div>\n<div class=\"overflow-y-auto p-4\">\u0646\u062a\u06cc\u062c\u0647: <code>92<\/code><\/div>\n<\/div>\n<h3>\u062a\u0631\u06a9\u06cc\u0628 \u0628\u0627 \u0633\u0627\u06cc\u0631 \u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627<\/h3>\n<p>\u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0641\u0631\u0645\u0648\u0644 <code>MAX<\/code> \u0631\u0627 \u0628\u0627 \u0633\u0627\u06cc\u0631 \u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627 \u062a\u0631\u06a9\u06cc\u0628 \u06a9\u0646\u06cc\u062f \u062a\u0627 \u0646\u062a\u0627\u06cc\u062c \u067e\u06cc\u0686\u06cc\u062f\u0647\u200c\u062a\u0631\u06cc \u0628\u062f\u0633\u062a \u0622\u0648\u0631\u06cc\u062f. \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre hljs language-excel\">=MAX(A1:A10) - MIN(A1:A10)<br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0627\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u062a\u0641\u0627\u0648\u062a \u0628\u06cc\u0646 \u0628\u0632\u0631\u06af\u062a\u0631\u06cc\u0646 \u0648 \u06a9\u0648\u0686\u06a9\u062a\u0631\u06cc\u0646 \u0645\u0642\u062f\u0627\u0631 \u062f\u0631 \u0645\u062d\u062f\u0648\u062f\u0647 A1 \u0631\u0627 \u0645\u062d\u0627\u0633\u0628\u0647 \u0645\u06cc\u200c\u06a9\u0646\u062f.<\/p>\n<hr \/>\n<h2><strong>\u0641\u0631\u0645\u0648\u0644 MIN<\/strong><\/h2>\n<p>\u0641\u0631\u0645\u0648\u0644 <code>MIN<\/code> \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0628\u0631\u0627\u06cc \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0646 \u06a9\u0648\u0686\u06a9\u062a\u0631\u06cc\u0646 \u0639\u062f\u062f \u062f\u0631 \u06cc\u06a9 \u0645\u062d\u062f\u0648\u062f\u0647 \u06cc\u0627 \u0645\u062c\u0645\u0648\u0639\u0647\u200c\u0627\u06cc \u0627\u0632 \u0627\u0639\u062f\u0627\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0627\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0645\u0641\u06cc\u062f \u0628\u0627\u0634\u062f \u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u0628\u062e\u0648\u0627\u0647\u06cc\u062f \u062d\u062f\u0627\u0642\u0644 \u0645\u0642\u062f\u0627\u0631 \u06cc\u06a9 \u0645\u062c\u0645\u0648\u0639\u0647 \u0627\u0632 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u06cc\u062f.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-19296 size-full\" src=\"https:\/\/iranfso.com\/blog\/wp-content\/uploads\/2024\/07\/Min.gif\" alt=\"\u0641\u0631\u0645\u0648\u0644 MIN\" width=\"452\" height=\"303\" \/><\/p>\n<h3>\u0633\u0627\u062e\u062a\u0627\u0631 \u0641\u0631\u0645\u0648\u0644<\/h3>\n<p>\u0633\u0627\u062e\u062a\u0627\u0631 \u06a9\u0644\u06cc \u0641\u0631\u0645\u0648\u0644 <code>MIN<\/code> \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre hljs language-excel\">=MIN(number1, [number2], ...)<br \/>\n<\/code><\/div>\n<\/div>\n<ul>\n<li><code>number1<\/code>, <code>number2<\/code>, &#8230; : \u0627\u06cc\u0646 \u067e\u0627\u0631\u0627\u0645\u062a\u0631\u0647\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u0627\u0639\u062f\u0627\u062f \u062b\u0627\u0628\u062a\u060c \u0622\u062f\u0631\u0633 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u060c \u06cc\u0627 \u0645\u062d\u062f\u0648\u062f\u0647\u200c\u0627\u06cc \u0627\u0632 \u0633\u0644\u0648\u0644\u200c\u0647\u0627 \u0628\u0627\u0634\u0646\u062f.<\/li>\n<\/ul>\n<h3>\u0645\u062b\u0627\u0644\u200c\u0647\u0627<\/h3>\n<ol>\n<li><strong>\u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0646 \u06a9\u0648\u0686\u06a9\u062a\u0631\u06cc\u0646 \u0639\u062f\u062f \u062f\u0631 \u06cc\u06a9 \u0645\u062d\u062f\u0648\u062f\u0647 \u0633\u0644\u0648\u0644\u200c\u0647\u0627<\/strong> \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u062f\u0631 \u0633\u062a\u0648\u0646 A \u0645\u0642\u0627\u062f\u06cc\u0631 \u0632\u06cc\u0631 \u0631\u0627 \u062f\u0627\u0631\u06cc\u062f:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-makefile\"><span class=\"hljs-section\">A1: 5<\/span><br \/>\n<span class=\"hljs-section\">A2: 10<\/span><br \/>\n<span class=\"hljs-section\">A3: 15<\/span><br \/>\n<span class=\"hljs-section\">A4: 20<\/span><br \/>\n<span class=\"hljs-section\">A5: 25<\/span><\/code><\/div>\n<\/div>\n<p>\u0628\u0631\u0627\u06cc \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0646 \u06a9\u0648\u0686\u06a9\u062a\u0631\u06cc\u0646 \u0639\u062f\u062f \u062f\u0631 \u0627\u06cc\u0646 \u0645\u062d\u062f\u0648\u062f\u0647\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=MIN(A1:A5)<\/code><\/div>\n<div class=\"overflow-y-auto p-4\" style=\"text-align: right;\">\u0646\u062a\u06cc\u062c\u0647: <code>5<\/code><\/div>\n<\/div>\n<\/li>\n<li><strong>\u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0646 \u06a9\u0648\u0686\u06a9\u062a\u0631\u06cc\u0646 \u0639\u062f\u062f \u062f\u0631 \u0686\u0646\u062f\u06cc\u0646 \u0645\u062d\u062f\u0648\u062f\u0647<\/strong> \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u062f\u0631 \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u06cc A \u0648 B \u0645\u0642\u0627\u062f\u06cc\u0631 \u0632\u06cc\u0631 \u0631\u0627 \u062f\u0627\u0631\u06cc\u062f:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-makefile\"><span class=\"hljs-section\">A1: 5    B1: 2<\/span><br \/>\n<span class=\"hljs-section\">A2: 10   B2: 3<\/span><br \/>\n<span class=\"hljs-section\">A3: 15   B3: 4<\/span><br \/>\n<span class=\"hljs-section\">A4: 20   B4: 5<\/span><br \/>\n<span class=\"hljs-section\">A5: 25   B5: 6<\/span><\/code><\/div>\n<\/div>\n<p>\u0628\u0631\u0627\u06cc \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0646 \u06a9\u0648\u0686\u06a9\u062a\u0631\u06cc\u0646 \u0639\u062f\u062f \u062f\u0631 \u0647\u0631 \u062f\u0648 \u0645\u062d\u062f\u0648\u062f\u0647\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=MIN(A1:A5, B1:B5)<\/code><\/div>\n<div class=\"overflow-y-auto p-4\" style=\"text-align: right;\">\u0646\u062a\u06cc\u062c\u0647: <code>2<\/code><\/div>\n<\/div>\n<\/li>\n<li><strong>\u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0646 \u06a9\u0648\u0686\u06a9\u062a\u0631\u06cc\u0646 \u0639\u062f\u062f \u062f\u0631 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u063a\u06cc\u0631 \u0645\u062f\u0627\u0648\u0645<\/strong> \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u062f\u0631 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc A1\u060c A3 \u0648 A5 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0632\u06cc\u0631 \u0631\u0627 \u062f\u0627\u0631\u06cc\u062f:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-makefile\"><span class=\"hljs-section\">A1: 5<\/span><br \/>\n<span class=\"hljs-section\">A3: 15<\/span><br \/>\n<span class=\"hljs-section\">A5: 25<\/span><\/code><\/div>\n<\/div>\n<p>\u0628\u0631\u0627\u06cc \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0646 \u06a9\u0648\u0686\u06a9\u062a\u0631\u06cc\u0646 \u0639\u062f\u062f \u062f\u0631 \u0627\u06cc\u0646 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=MIN(A1, A3, A5)<\/code><\/div>\n<div class=\"overflow-y-auto p-4\" style=\"text-align: right;\">\u0646\u062a\u06cc\u062c\u0647: <code>5<\/code><\/div>\n<\/div>\n<\/li>\n<li><strong>\u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0646 \u06a9\u0648\u0686\u06a9\u062a\u0631\u06cc\u0646 \u0639\u062f\u062f \u0627\u0632 \u062a\u0631\u06a9\u06cc\u0628 \u0627\u0639\u062f\u0627\u062f \u0648 \u0633\u0644\u0648\u0644\u200c\u0647\u0627<\/strong> \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u06a9\u0648\u0686\u06a9\u062a\u0631\u06cc\u0646 \u0639\u062f\u062f \u0628\u06cc\u0646 \u0686\u0646\u062f \u0639\u062f\u062f \u062b\u0627\u0628\u062a \u0648 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0645\u0648\u062c\u0648\u062f \u062f\u0631 \u0686\u0646\u062f \u0633\u0644\u0648\u0644 \u0631\u0627 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u06cc\u062f:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-makefile\"><span class=\"hljs-section\">A1: 5<\/span><br \/>\n<span class=\"hljs-section\">A2: 10<\/span><\/code><\/div>\n<\/div>\n<p>\u0628\u0631\u0627\u06cc \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0646 \u06a9\u0648\u0686\u06a9\u062a\u0631\u06cc\u0646 \u0639\u062f\u062f \u0628\u06cc\u0646 \u0627\u0639\u062f\u0627\u062f \u062b\u0627\u0628\u062a 20\u060c 30 \u0648 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0645\u0648\u062c\u0648\u062f \u062f\u0631 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc A1 \u0648 A2\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=MIN(20, 30, A1, A2)<\/code><\/div>\n<div class=\"overflow-y-auto p-4\" style=\"text-align: right;\">\u0646\u062a\u06cc\u062c\u0647: <code>5<\/code><\/div>\n<\/div>\n<\/li>\n<\/ol>\n<h3>\u0646\u06a9\u0627\u062a \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc<\/h3>\n<ul>\n<li>\u0641\u0631\u0645\u0648\u0644 <code>MIN<\/code> \u0641\u0642\u0637 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0639\u062f\u062f\u06cc \u0631\u0627 \u062f\u0631 \u0646\u0638\u0631 \u0645\u06cc\u200c\u06af\u06cc\u0631\u062f \u0648 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u062e\u0627\u0644\u06cc \u06cc\u0627 \u062d\u0627\u0648\u06cc \u0645\u062a\u0646 \u0631\u0627 \u0646\u0627\u062f\u06cc\u062f\u0647 \u0645\u06cc\u200c\u06af\u06cc\u0631\u062f.<\/li>\n<li>\u0627\u06af\u0631 \u062a\u0645\u0627\u0645 \u0622\u0631\u06af\u0648\u0645\u0627\u0646\u200c\u0647\u0627\u06cc \u0641\u0631\u0645\u0648\u0644 <code>MIN<\/code> \u063a\u06cc\u0631 \u0639\u062f\u062f\u06cc \u0628\u0627\u0634\u0646\u062f\u060c \u0641\u0631\u0645\u0648\u0644 \u0646\u062a\u06cc\u062c\u0647 <code>0<\/code> \u0631\u0627 \u0628\u0631\u0645\u06cc\u200c\u06af\u0631\u062f\u0627\u0646\u062f.<\/li>\n<li>\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 <code>MIN<\/code> \u062f\u0631 \u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0628\u0647 \u0634\u0645\u0627 \u06a9\u0645\u06a9 \u0645\u06cc\u200c\u06a9\u0646\u062f \u062a\u0627 \u06a9\u0648\u0686\u06a9\u062a\u0631\u06cc\u0646 \u0645\u0642\u062f\u0627\u0631 \u062f\u0631 \u0645\u062c\u0645\u0648\u0639\u0647\u200c\u0627\u06cc \u0627\u0632 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u0628\u0647 \u0631\u0627\u062d\u062a\u06cc \u0634\u0646\u0627\u0633\u0627\u06cc\u06cc \u06a9\u0646\u06cc\u062f.<\/li>\n<\/ul>\n<h3>\u0645\u062b\u0627\u0644 \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc<\/h3>\n<p>\u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u062f\u0631 \u0633\u062a\u0648\u0646 A \u0646\u0645\u0631\u0627\u062a \u062f\u0627\u0646\u0634\u200c\u0622\u0645\u0648\u0632\u0627\u0646 \u0631\u0627 \u062f\u0627\u0631\u06cc\u062f \u0648 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u067e\u0627\u06cc\u06cc\u0646\u200c\u062a\u0631\u06cc\u0646 \u0646\u0645\u0631\u0647 \u0631\u0627 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre hljs language-makefile\"><span class=\"hljs-section\">A1: 85<\/span><br \/>\n<span class=\"hljs-section\">A2: 90<\/span><br \/>\n<span class=\"hljs-section\">A3: 78<\/span><br \/>\n<span class=\"hljs-section\">A4: 92<\/span><br \/>\n<span class=\"hljs-section\">A5: 88<\/span><\/code><\/div>\n<\/div>\n<p>\u0628\u0631\u0627\u06cc \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0646 \u067e\u0627\u06cc\u06cc\u0646\u200c\u062a\u0631\u06cc\u0646 \u0646\u0645\u0631\u0647\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre hljs language-excel\">=MIN(A1:A5)<\/code><\/div>\n<div class=\"overflow-y-auto p-4\" style=\"text-align: right;\">\u0646\u062a\u06cc\u062c\u0647: <code>78<\/code><\/div>\n<\/div>\n<h3>\u062a\u0631\u06a9\u06cc\u0628 \u0628\u0627 \u0633\u0627\u06cc\u0631 \u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627<\/h3>\n<p>\u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0641\u0631\u0645\u0648\u0644 <code>MIN<\/code> \u0631\u0627 \u0628\u0627 \u0633\u0627\u06cc\u0631 \u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627 \u062a\u0631\u06a9\u06cc\u0628 \u06a9\u0646\u06cc\u062f \u062a\u0627 \u0646\u062a\u0627\u06cc\u062c \u067e\u06cc\u0686\u06cc\u062f\u0647\u200c\u062a\u0631\u06cc \u0628\u062f\u0633\u062a \u0622\u0648\u0631\u06cc\u062f. \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre hljs language-excel\">=MAX(A1:A10) - MIN(A1:A10)<br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0627\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u062a\u0641\u0627\u0648\u062a \u0628\u06cc\u0646 \u0628\u0632\u0631\u06af\u062a\u0631\u06cc\u0646 \u0648 \u06a9\u0648\u0686\u06a9\u062a\u0631\u06cc\u0646 \u0645\u0642\u062f\u0627\u0631 \u062f\u0631 \u0645\u062d\u062f\u0648\u062f\u0647 A1 \u0631\u0627 \u0645\u062d\u0627\u0633\u0628\u0647 \u0645\u06cc\u200c\u06a9\u0646\u062f.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p>&nbsp;<\/p>\n<a href=\"https:\/\/iranfso.com\/blog\/gmail-account\/\" class=\"shortc-button big green \">\u0634\u0645\u0627 \u0647\u0645\u0686\u0646\u06cc\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0631\u0627\u06cc \u0622\u0634\u0646\u0627\u06cc\u06cc \u0628\u0627 \u0627\u06cc\u062c\u0627\u062f \u0627\u06cc\u0645\u06cc\u0644 \u062f\u0631 Gmail\u060c \u0645\u0642\u0627\u0644\u0647 &#8220;\u0627\u06cc\u062c\u0627\u062f \u0627\u06cc\u0645\u06cc\u0644 \u062f\u0631 Gmail: \u0633\u0627\u062f\u0647 \u0648 \u0622\u0633\u0627\u0646&#8221; \u0645\u0637\u0627\u0644\u0639\u0647 \u0646\u0645\u0627\u06cc\u06cc\u062f.<\/a>\n<p>&nbsp;<\/p>\n<div class=\"w-full text-token-text-primary\" dir=\"auto\" data-testid=\"conversation-turn-11\" data-scroll-anchor=\"true\">\n<div class=\"text-base py-[18px] px-3 md:px-4 m-auto md:px-5 lg:px-1 xl:px-5\">\n<div class=\"mx-auto flex flex-1 gap-4 text-base md:gap-5 lg:gap-6 md:max-w-3xl lg:max-w-[40rem] xl:max-w-[48rem]\">\n<div class=\"group\/conversation-turn relative flex w-full min-w-0 flex-col agent-turn\">\n<div class=\"flex-col gap-1 md:gap-3\">\n<div class=\"flex flex-grow flex-col max-w-full\">\n<div class=\"min-h-[20px] text-message flex w-full flex-col items-end gap-2 whitespace-pre-wrap break-words [.text-message+&amp;]:mt-5 overflow-x-auto\" dir=\"auto\" data-message-author-role=\"assistant\" data-message-id=\"32b864cf-f41a-4277-85ee-d630c4e9d1fa\">\n<div class=\"flex w-full flex-col gap-1 empty:hidden first:pt-[3px]\">\n<div class=\"markdown prose w-full break-words dark:prose-invert dark\">\n<hr \/>\n<h2><strong>\u0641\u0631\u0645\u0648\u0644 CONCATENATE<\/strong><\/h2>\n<p>\u0641\u0631\u0645\u0648\u0644 <code>CONCATENATE<\/code> \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0628\u0631\u0627\u06cc \u062a\u0631\u06a9\u06cc\u0628 \u0686\u0646\u062f\u06cc\u0646 \u0645\u062a\u0646 \u06cc\u0627 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0633\u0644\u0648\u0644\u200c\u0647\u0627 \u0628\u0647 \u06cc\u06a9 \u0631\u0634\u062a\u0647 \u0648\u0627\u062d\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0627\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u0628\u0647 \u0634\u0645\u0627 \u0627\u062c\u0627\u0632\u0647 \u0645\u06cc\u200c\u062f\u0647\u062f \u062a\u0627 \u0645\u062a\u0648\u0646 \u0631\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u067e\u06cc\u0648\u0633\u062a\u0647 \u0648 \u0628\u062f\u0648\u0646 \u0641\u0627\u0635\u0644\u0647 \u062a\u0631\u06a9\u06cc\u0628 \u06a9\u0646\u06cc\u062f.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-19297 size-full\" src=\"https:\/\/iranfso.com\/blog\/wp-content\/uploads\/2024\/07\/Concatenate.gif\" alt=\"\u0641\u0631\u0645\u0648\u0644 CONCATENATE\" width=\"474\" height=\"244\" \/><\/p>\n<h3>\u0633\u0627\u062e\u062a\u0627\u0631 \u0641\u0631\u0645\u0648\u0644<\/h3>\n<p>\u0633\u0627\u062e\u062a\u0627\u0631 \u06a9\u0644\u06cc \u0641\u0631\u0645\u0648\u0644 <code>CONCATENATE<\/code> \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre hljs language-excel\">=CONCATENATE(text1, [text2], ...)<br \/>\n<\/code><\/div>\n<\/div>\n<ul>\n<li><code>text1<\/code>, <code>text2<\/code>, &#8230; : \u0645\u0642\u0627\u062f\u06cc\u0631 \u0645\u062a\u0646\u06cc \u06cc\u0627 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u062a\u0631\u06a9\u06cc\u0628 \u06a9\u0646\u06cc\u062f.<\/li>\n<\/ul>\n<p>\u062f\u0631 \u0646\u0633\u062e\u0647\u200c\u0647\u0627\u06cc \u062c\u062f\u06cc\u062f\u062a\u0631 \u0627\u06a9\u0633\u0644 (2016 \u0628\u0647 \u0628\u0639\u062f)\u060c \u062a\u0648\u0627\u0628\u0639 <code>CONCAT<\/code> \u0648 <code>TEXTJOIN<\/code> \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u062c\u0627\u06cc\u06af\u0632\u06cc\u0646\u200c\u0647\u0627\u06cc \u067e\u06cc\u0634\u0631\u0641\u062a\u0647\u200c\u062a\u0631 \u0628\u0631\u0627\u06cc <code>CONCATENATE<\/code> \u0645\u0639\u0631\u0641\u06cc \u0634\u062f\u0647\u200c\u0627\u0646\u062f.<\/p>\n<h3>\u0645\u062b\u0627\u0644\u200c\u0647\u0627<\/h3>\n<ol>\n<li><strong>\u062a\u0631\u06a9\u06cc\u0628 \u062f\u0648 \u0645\u062a\u0646 \u062b\u0627\u0628\u062a<\/strong> \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u062f\u0648 \u0645\u062a\u0646 &#8220;\u0633\u0644\u0627\u0645&#8221; \u0648 &#8220;\u062c\u0647\u0627\u0646&#8221; \u0631\u0627 \u062a\u0631\u06a9\u06cc\u0628 \u06a9\u0646\u06cc\u062f:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=CONCATENATE(\"\u0633\u0644\u0627\u0645\", \"\u062c\u0647\u0627\u0646\")<\/code><\/div>\n<div class=\"overflow-y-auto p-4\" style=\"text-align: right;\">\u0646\u062a\u06cc\u062c\u0647: <code>\u0633\u0644\u0627\u0645\u062c\u0647\u0627\u0646<\/code><\/div>\n<\/div>\n<\/li>\n<li><strong>\u062a\u0631\u06a9\u06cc\u0628 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0633\u0644\u0648\u0644\u200c\u0647\u0627<\/strong> \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u062f\u0631 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc A1 \u0648 B1 \u0645\u062a\u0648\u0646 \u0632\u06cc\u0631 \u0631\u0627 \u062f\u0627\u0631\u06cc\u062f:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-makefile\"><span class=\"hljs-section\">A1: \u0633\u0644\u0627\u0645<\/span><br \/>\n<span class=\"hljs-section\">B1: \u062c\u0647\u0627\u0646<\/span><\/code><\/div>\n<\/div>\n<p>\u0628\u0631\u0627\u06cc \u062a\u0631\u06a9\u06cc\u0628 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0627\u06cc\u0646 \u062f\u0648 \u0633\u0644\u0648\u0644\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=CONCATENATE(A1, B1)<\/code><\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: right;\">\u0646\u062a\u06cc\u062c\u0647: <code>\u0633\u0644\u0627\u0645\u062c\u0647\u0627\u0646<\/code><\/div>\n<\/div>\n<\/li>\n<li><strong>\u062a\u0631\u06a9\u06cc\u0628 \u0645\u062a\u0646 \u0628\u0627 \u0641\u0627\u0635\u0644\u0647<\/strong> \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u062f\u0648 \u0645\u062a\u0646 &#8220;\u0633\u0644\u0627\u0645&#8221; \u0648 &#8220;\u062c\u0647\u0627\u0646&#8221; \u0631\u0627 \u0628\u0627 \u06cc\u06a9 \u0641\u0627\u0635\u0644\u0647 \u0628\u06cc\u0646 \u0622\u0646\u200c\u0647\u0627 \u062a\u0631\u06a9\u06cc\u0628 \u06a9\u0646\u06cc\u062f:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=CONCATENATE(\"\u0633\u0644\u0627\u0645\", \" \", \"\u062c\u0647\u0627\u0646\")<\/code><\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: right;\">\u0646\u062a\u06cc\u062c\u0647: <code>\u0633\u0644\u0627\u0645 \u062c\u0647\u0627\u0646<\/code><\/div>\n<\/div>\n<\/li>\n<li><strong>\u062a\u0631\u06a9\u06cc\u0628 \u0686\u0646\u062f\u06cc\u0646 \u0645\u0642\u062f\u0627\u0631 \u0633\u0644\u0648\u0644<\/strong> \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u062f\u0631 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc A1\u060c B1 \u0648 C1 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0632\u06cc\u0631 \u0631\u0627 \u062f\u0627\u0631\u06cc\u062f:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-makefile\"><span class=\"hljs-section\">A1: \u0633\u0644\u0627\u0645<\/span><br \/>\n<span class=\"hljs-section\">B1: \u0628\u0647<\/span><br \/>\n<span class=\"hljs-section\">C1: \u062c\u0647\u0627\u0646<\/span><\/code><\/div>\n<\/div>\n<p>\u0628\u0631\u0627\u06cc \u062a\u0631\u06a9\u06cc\u0628 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0627\u06cc\u0646 \u0633\u0647 \u0633\u0644\u0648\u0644\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=CONCATENATE(A1, \" \", B1, \" \", C1)<\/code><\/div>\n<div class=\"overflow-y-auto p-4\" style=\"text-align: right;\">\u0646\u062a\u06cc\u062c\u0647: <code>\u0633\u0644\u0627\u0645 \u0628\u0647 \u062c\u0647\u0627\u0646<\/code><\/div>\n<\/div>\n<\/li>\n<\/ol>\n<h3>\u0646\u06a9\u0627\u062a \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc<\/h3>\n<ul>\n<li><code>CONCATENATE<\/code> \u062d\u062f\u0627\u06a9\u062b\u0631 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f 255 \u0631\u0634\u062a\u0647 \u06cc\u0627 \u0645\u0642\u062f\u0627\u0631 \u0631\u0627 \u062a\u0631\u06a9\u06cc\u0628 \u06a9\u0646\u062f.<\/li>\n<li>\u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0639\u0645\u0644\u06af\u0631 <code>&amp;<\/code> \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u062c\u0627\u06cc\u06af\u0632\u06cc\u0646 \u0628\u0631\u0627\u06cc <code>CONCATENATE<\/code> \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=A1 &amp; \" \" &amp; B1<br \/>\n<\/code><\/div>\n<\/div>\n<\/li>\n<li>\u062f\u0631 \u0646\u0633\u062e\u0647\u200c\u0647\u0627\u06cc \u062c\u062f\u06cc\u062f\u062a\u0631 \u0627\u06a9\u0633\u0644\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u062a\u0648\u0627\u0628\u0639 <code>CONCAT<\/code> \u0648 <code>TEXTJOIN<\/code> \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0627\u0645\u06a9\u0627\u0646\u0627\u062a \u0628\u06cc\u0634\u062a\u0631\u06cc \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc\u200c\u062f\u0647\u0646\u062f.<\/li>\n<\/ul>\n<h3>\u062a\u0627\u0628\u0639 <code>CONCAT<\/code><\/h3>\n<p>\u062a\u0627\u0628\u0639 <code>CONCAT<\/code> \u0645\u0634\u0627\u0628\u0647 <code>CONCATENATE<\/code> \u0639\u0645\u0644 \u0645\u06cc\u200c\u06a9\u0646\u062f\u060c \u0627\u0645\u0627 \u0627\u0646\u0639\u0637\u0627\u0641\u200c\u067e\u0630\u06cc\u0631\u06cc \u0628\u06cc\u0634\u062a\u0631\u06cc \u062f\u0627\u0631\u062f \u0648 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0645\u062d\u062f\u0648\u062f\u0647\u200c\u0647\u0627\u06cc \u0633\u0644\u0648\u0644\u06cc \u0631\u0627 \u0628\u0647 \u0637\u0648\u0631 \u0645\u0633\u062a\u0642\u06cc\u0645 \u062a\u0631\u06a9\u06cc\u0628 \u06a9\u0646\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre hljs language-excel\">=CONCAT(A1:C1)<\/code><\/div>\n<div class=\"overflow-y-auto p-4\" style=\"text-align: right;\">\u0646\u062a\u06cc\u062c\u0647: <code>\u0633\u0644\u0627\u0645\u0628\u0647\u062c\u0647\u0627\u0646<\/code><\/div>\n<\/div>\n<h3>\u062a\u0627\u0628\u0639 <code>TEXTJOIN<\/code><\/h3>\n<p>\u062a\u0627\u0628\u0639 <code>TEXTJOIN<\/code> \u0628\u0647 \u0634\u0645\u0627 \u0627\u062c\u0627\u0632\u0647 \u0645\u06cc\u200c\u062f\u0647\u062f \u06a9\u0647 \u06cc\u06a9 \u062c\u062f\u0627\u06a9\u0646\u0646\u062f\u0647 (delimiter) \u0628\u06cc\u0646 \u0645\u062a\u0648\u0646 \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u062f \u0648 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u062e\u0627\u0644\u06cc \u0631\u0627 \u0646\u0627\u062f\u06cc\u062f\u0647 \u0628\u06af\u06cc\u0631\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre hljs language-excel\">=TEXTJOIN(\" \", TRUE, A1:C1)<\/code><\/div>\n<div class=\"overflow-y-auto p-4\" style=\"text-align: right;\">\u0646\u062a\u06cc\u062c\u0647: <code>\u0633\u0644\u0627\u0645 \u0628\u0647 \u062c\u0647\u0627\u0646<\/code><\/div>\n<\/div>\n<h3>\u0645\u062b\u0627\u0644 \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc<\/h3>\n<p>\u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u0634\u0645\u0627 \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0627\u0632 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u062f\u0627\u0646\u0634\u200c\u0622\u0645\u0648\u0632\u0627\u0646 \u062f\u0627\u0631\u06cc\u062f \u0648 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u0646\u0627\u0645 \u0648 \u0646\u0627\u0645 \u062e\u0627\u0646\u0648\u0627\u062f\u06af\u06cc \u0622\u0646\u200c\u0647\u0627 \u0631\u0627 \u062a\u0631\u06a9\u06cc\u0628 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre hljs language-yaml\"><span class=\"hljs-attr\">A1:<\/span> <span class=\"hljs-string\">\u0646\u0627\u0645<\/span>       <span class=\"hljs-attr\">B1:<\/span> <span class=\"hljs-string\">\u0646\u0627\u0645<\/span> <span class=\"hljs-string\">\u062e\u0627\u0646\u0648\u0627\u062f\u06af\u06cc<\/span><br \/>\n<span class=\"hljs-attr\">A2:<\/span> <span class=\"hljs-string\">\u0639\u0644\u06cc<\/span>       <span class=\"hljs-attr\">B2:<\/span> <span class=\"hljs-string\">\u0631\u0636\u0627\u06cc\u06cc<\/span><br \/>\n<span class=\"hljs-attr\">A3:<\/span> <span class=\"hljs-string\">\u0645\u062d\u0645\u062f<\/span>      <span class=\"hljs-attr\">B3:<\/span> <span class=\"hljs-string\">\u062d\u0633\u06cc\u0646\u06cc<\/span><br \/>\n<span class=\"hljs-attr\">A4:<\/span> <span class=\"hljs-string\">\u0646\u0631\u06af\u0633<\/span>      <span class=\"hljs-attr\">B4:<\/span> <span class=\"hljs-string\">\u0634\u0627\u062f<\/span><\/code><\/div>\n<\/div>\n<p>\u0628\u0631\u0627\u06cc \u062a\u0631\u06a9\u06cc\u0628 \u0646\u0627\u0645 \u0648 \u0646\u0627\u0645 \u062e\u0627\u0646\u0648\u0627\u062f\u06af\u06cc \u062f\u0631 \u06cc\u06a9 \u0633\u0644\u0648\u0644\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre hljs language-excel\">=CONCATENATE(A2, \" \", B2)<\/code><\/div>\n<div class=\"overflow-y-auto p-4\">\u0646\u062a\u06cc\u062c\u0647 \u0628\u0631\u0627\u06cc \u0633\u0644\u0648\u0644 C2: <code>\u0639\u0644\u06cc \u0631\u0636\u0627\u06cc\u06cc<\/code><\/div>\n<\/div>\n<hr \/>\n<h2><strong>\u0641\u0631\u0645\u0648\u0644 TRIM<\/strong><\/h2>\n<p>\u0641\u0631\u0645\u0648\u0644 <code>TRIM<\/code> \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 \u06cc\u06a9 \u0631\u0634\u062a\u0647 \u0645\u062a\u0646\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0627\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u0641\u0627\u0635\u0644\u0647\u200c\u0647\u0627\u06cc \u0627\u0636\u0627\u0641\u06cc \u0631\u0627 \u0627\u0632 \u0627\u0628\u062a\u062f\u0627\u06cc\u060c \u0627\u0646\u062a\u0647\u0627 \u0648 \u0628\u06cc\u0646 \u06a9\u0644\u0645\u0627\u062a \u062d\u0630\u0641 \u0645\u06cc\u200c\u06a9\u0646\u062f\u060c \u0628\u0647 \u0637\u0648\u0631\u06cc \u06a9\u0647 \u0641\u0642\u0637 \u06cc\u06a9 \u0641\u0627\u0635\u0644\u0647 \u0628\u06cc\u0646 \u06a9\u0644\u0645\u0627\u062a \u0628\u0627\u0642\u06cc \u0645\u06cc\u200c\u0645\u0627\u0646\u062f. <code>TRIM<\/code> \u0628\u0647 \u0648\u06cc\u0698\u0647 \u0632\u0645\u0627\u0646\u06cc \u0645\u0641\u06cc\u062f \u0627\u0633\u062a \u06a9\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0627\u0632 \u0645\u0646\u0627\u0628\u0639 \u062f\u06cc\u06af\u0631 \u0648\u0627\u0631\u062f \u0634\u062f\u0647\u200c\u0627\u0646\u062f \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.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-19298 size-full\" src=\"https:\/\/iranfso.com\/blog\/wp-content\/uploads\/2024\/07\/Trim.gif\" alt=\"\u0641\u0631\u0645\u0648\u0644 TRIM\" width=\"343\" height=\"205\" \/><\/p>\n<h3>\u0633\u0627\u062e\u062a\u0627\u0631 \u0641\u0631\u0645\u0648\u0644<\/h3>\n<p>\u0633\u0627\u062e\u062a\u0627\u0631 \u06a9\u0644\u06cc \u0641\u0631\u0645\u0648\u0644 <code>TRIM<\/code> \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre hljs language-excel\">=TRIM(text)<br \/>\n<\/code><\/div>\n<\/div>\n<ul>\n<li><code>text<\/code>: \u0631\u0634\u062a\u0647 \u0645\u062a\u0646\u06cc \u06a9\u0647 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u0641\u0627\u0635\u0644\u0647\u200c\u0647\u0627\u06cc \u0627\u0636\u0627\u0641\u06cc \u0622\u0646 \u0631\u0627 \u062d\u0630\u0641 \u06a9\u0646\u06cc\u062f.<\/li>\n<\/ul>\n<h3>\u0645\u062b\u0627\u0644\u200c\u0647\u0627<\/h3>\n<ol>\n<li><strong>\u062d\u0630\u0641 \u0641\u0627\u0635\u0644\u0647\u200c\u0647\u0627\u06cc \u0627\u0636\u0627\u0641\u06cc \u0627\u0632 \u06cc\u06a9 \u0631\u0634\u062a\u0647 \u062b\u0627\u0628\u062a<\/strong> \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u06cc\u06a9 \u0631\u0634\u062a\u0647 \u0645\u062a\u0646\u06cc \u0628\u0627 \u0641\u0627\u0635\u0644\u0647\u200c\u0647\u0627\u06cc \u0627\u0636\u0627\u0641\u06cc \u062f\u0627\u0631\u06cc\u062f:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=TRIM(\"  \u0633\u0644\u0627\u0645    \u062c\u0647\u0627\u0646  \")<\/code><\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: right;\">\u0646\u062a\u06cc\u062c\u0647: <code>\u0633\u0644\u0627\u0645 \u062c\u0647\u0627\u0646<\/code><\/div>\n<\/div>\n<\/li>\n<li><strong>\u062d\u0630\u0641 \u0641\u0627\u0635\u0644\u0647\u200c\u0647\u0627\u06cc \u0627\u0636\u0627\u0641\u06cc \u0627\u0632 \u0645\u0642\u062f\u0627\u0631 \u06cc\u06a9 \u0633\u0644\u0648\u0644<\/strong> \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u062f\u0631 \u0633\u0644\u0648\u0644 A1 \u06cc\u06a9 \u0645\u062a\u0646 \u0628\u0627 \u0641\u0627\u0635\u0644\u0647\u200c\u0647\u0627\u06cc \u0627\u0636\u0627\u0641\u06cc \u062f\u0627\u0631\u06cc\u062f:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-vbnet\"><span class=\"hljs-symbol\">A1:<\/span> <span class=\"hljs-string\">\"  \u0633\u0644\u0627\u0645    \u062c\u0647\u0627\u0646  \"<\/span><br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0628\u0631\u0627\u06cc \u062d\u0630\u0641 \u0641\u0627\u0635\u0644\u0647\u200c\u0647\u0627\u06cc \u0627\u0636\u0627\u0641\u06cc \u0627\u0632 \u0645\u0642\u062f\u0627\u0631 \u0627\u06cc\u0646 \u0633\u0644\u0648\u0644\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=TRIM(A1)<\/code><\/div>\n<div class=\"overflow-y-auto p-4\" style=\"text-align: right;\">\u0646\u062a\u06cc\u062c\u0647: <code>\u0633\u0644\u0627\u0645 \u062c\u0647\u0627\u0646<\/code><\/div>\n<\/div>\n<\/li>\n<li><strong>\u062d\u0630\u0641 \u0641\u0627\u0635\u0644\u0647\u200c\u0647\u0627\u06cc \u0627\u0636\u0627\u0641\u06cc \u0627\u0632 \u06cc\u06a9 \u0631\u0634\u062a\u0647 \u062a\u0631\u06a9\u06cc\u0628\u06cc<\/strong> \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u062f\u0631 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc A1 \u0648 B1 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0632\u06cc\u0631 \u0631\u0627 \u062f\u0627\u0631\u06cc\u062f:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-vbnet\"><span class=\"hljs-symbol\">A1:<\/span> <span class=\"hljs-string\">\"  \u0633\u0644\u0627\u0645\"<\/span><br \/>\n<span class=\"hljs-symbol\">B1:<\/span> <span class=\"hljs-string\">\"\u062c\u0647\u0627\u0646  \"<\/span><\/code><\/div>\n<div class=\"overflow-y-auto p-4\" style=\"text-align: right;\">\u0648 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u0627\u06cc\u0646 \u062f\u0648 \u0645\u0642\u062f\u0627\u0631 \u0631\u0627 \u062a\u0631\u06a9\u06cc\u0628 \u06a9\u0631\u062f\u0647 \u0648 \u0641\u0627\u0635\u0644\u0647\u200c\u0647\u0627\u06cc \u0627\u0636\u0627\u0641\u06cc \u0631\u0627 \u062d\u0630\u0641 \u06a9\u0646\u06cc\u062f:<\/div>\n<\/div>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=TRIM(A1 &amp; \" \" &amp; B1)<\/code><\/div>\n<div class=\"overflow-y-auto p-4\" style=\"text-align: right;\">\u0646\u062a\u06cc\u062c\u0647: <code>\u0633\u0644\u0627\u0645 \u062c\u0647\u0627\u0646<\/code><\/div>\n<\/div>\n<\/li>\n<\/ol>\n<h3>\u0646\u06a9\u0627\u062a \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc<\/h3>\n<ul>\n<li>\u0641\u0631\u0645\u0648\u0644 <code>TRIM<\/code> \u0641\u0642\u0637 \u0641\u0627\u0635\u0644\u0647\u200c\u0647\u0627\u06cc \u0627\u0633\u062a\u0627\u0646\u062f\u0627\u0631\u062f (space) \u0631\u0627 \u062d\u0630\u0641 \u0645\u06cc\u200c\u06a9\u0646\u062f \u0648 \u0641\u0627\u0635\u0644\u0647\u200c\u0647\u0627\u06cc \u063a\u06cc\u0631 \u0642\u0627\u0628\u0644 \u0686\u0627\u067e \u062f\u06cc\u06af\u0631 \u0631\u0627 \u0646\u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u062d\u0630\u0641 \u06a9\u0646\u062f. \u0628\u0631\u0627\u06cc \u062d\u0630\u0641 \u0641\u0627\u0635\u0644\u0647\u200c\u0647\u0627\u06cc \u063a\u06cc\u0631 \u0642\u0627\u0628\u0644 \u0686\u0627\u067e\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u062a\u0627\u0628\u0639 <code>CLEAN<\/code> \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f.<\/li>\n<li>\u0627\u06af\u0631 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0634\u0645\u0627 \u0634\u0627\u0645\u0644 \u0641\u0627\u0635\u0644\u0647\u200c\u0647\u0627\u06cc \u063a\u06cc\u0631 \u0642\u0627\u0628\u0644 \u0686\u0627\u067e \u0628\u0627\u0634\u0646\u062f\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0628\u062a\u062f\u0627 \u0627\u0632 <code>CLEAN<\/code> \u0648 \u0633\u067e\u0633 \u0627\u0632 <code>TRIM<\/code> \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\" style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=TRIM(CLEAN(A1))<br \/>\n<\/code><\/div>\n<\/div>\n<\/li>\n<\/ul>\n<h3>\u0645\u062b\u0627\u0644 \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc<\/h3>\n<p>\u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u0634\u0645\u0627 \u06cc\u06a9 \u0644\u06cc\u0633\u062a \u0627\u0632 \u0646\u0627\u0645\u200c\u0647\u0627 \u062f\u0627\u0631\u06cc\u062f \u06a9\u0647 \u0634\u0627\u0645\u0644 \u0641\u0627\u0635\u0644\u0647\u200c\u0647\u0627\u06cc \u0627\u0636\u0627\u0641\u06cc \u0627\u0633\u062a \u0648 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u0622\u0646\u200c\u0647\u0627 \u0631\u0627 \u062a\u0645\u06cc\u0632 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"dark bg-gray-950 rounded-md border-[0.5px] border-token-border-medium\">\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre hljs language-vbnet\"><span class=\"hljs-symbol\">A1:<\/span> <span class=\"hljs-string\">\" \u0639\u0644\u06cc   \"<\/span><br \/>\n<span class=\"hljs-symbol\">A2:<\/span> <span class=\"hljs-string\">\"  \u0645\u062d\u0645\u062f  \"<\/span><br \/>\n<span class=\"hljs-symbol\">A3:<\/span> <span class=\"hljs-string\">\"  \u0646\u0631\u06af\u0633  \"<\/span><br \/>\n<\/code><\/div>\n<\/div>\n<p>\u0628\u0631\u0627\u06cc \u062d\u0630\u0641 \u0641\u0627\u0635\u0644\u0647\u200c\u0647\u0627\u06cc \u0627\u0636\u0627\u0641\u06cc \u0627\u0632 \u0627\u06cc\u0646 \u0646\u0627\u0645\u200c\u0647\u0627\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 <code>TRIM<\/code> \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<p style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=TRIM(A1)<br \/>\n<\/code><\/p>\n<p>\u0646\u062a\u06cc\u062c\u0647 \u0628\u0631\u0627\u06cc \u0633\u0644\u0648\u0644 B1: <code>\u0639\u0644\u06cc<\/code><\/p>\n<h3>\u062a\u0631\u06a9\u06cc\u0628 \u0628\u0627 \u0633\u0627\u06cc\u0631 \u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627<\/h3>\n<p>\u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0641\u0631\u0645\u0648\u0644 <code>TRIM<\/code> \u0631\u0627 \u0628\u0627 \u0633\u0627\u06cc\u0631 \u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627 \u062a\u0631\u06a9\u06cc\u0628 \u06a9\u0646\u06cc\u062f \u062a\u0627 \u0646\u062a\u0627\u06cc\u062c \u067e\u06cc\u0686\u06cc\u062f\u0647\u200c\u062a\u0631\u06cc \u0628\u062f\u0633\u062a \u0622\u0648\u0631\u06cc\u062f. \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644:<\/p>\n<p style=\"text-align: left;\"><code class=\"!whitespace-pre hljs language-excel\">=TRIM(UPPER(A1))<br \/>\n<\/code><\/p>\n<p>\u0627\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u0641\u0627\u0635\u0644\u0647\u200c\u0647\u0627\u06cc \u0627\u0636\u0627\u0641\u06cc \u0631\u0627 \u062d\u0630\u0641 \u06a9\u0631\u062f\u0647 \u0648 \u0645\u062a\u0646 \u0631\u0627 \u0628\u0647 \u062d\u0631\u0648\u0641 \u0628\u0632\u0631\u06af \u062a\u0628\u062f\u06cc\u0644 \u0645\u06cc\u200c\u06a9\u0646\u062f.<\/p>\n<hr \/>\n<h1><strong>\u06a9\u0644\u0627\u0645 \u0622\u062e\u0631<\/strong><\/h1>\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u0645\u0637\u0644\u0628 \u0628\u0627 \u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627\u06cc \u0627\u0633\u0627\u0633\u06cc \u0648 \u067e\u0631\u06a9\u0627\u0631\u0628\u0631\u062f \u0627\u06a9\u0633\u0644 \u0622\u0634\u0646\u0627 \u0634\u062f\u06cc\u0645 \u06a9\u0647 \u0647\u0631 \u06a9\u062f\u0627\u0645 \u0646\u0642\u0634 \u0645\u0647\u0645\u06cc \u062f\u0631 \u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062f\u0627\u0631\u0646\u062f. \u0641\u0631\u0645\u0648\u0644 SUM \u0628\u0631\u0627\u06cc \u062c\u0645\u0639\u200c\u06a9\u0631\u062f\u0646 \u0645\u0642\u0627\u062f\u06cc\u0631\u060c AVERAGE \u0628\u0631\u0627\u06cc \u0645\u062d\u0627\u0633\u0628\u0647 \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646\u060c COUNT \u0628\u0631\u0627\u06cc \u0634\u0645\u0627\u0631\u0634 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u0639\u062f\u062f\u06cc\u060c IF \u0628\u0631\u0627\u06cc \u0627\u0639\u0645\u0627\u0644 \u0634\u0631\u0627\u06cc\u0637 \u0645\u0646\u0637\u0642\u06cc\u060c VLOOKUP \u0648 HLOOKUP \u0628\u0631\u0627\u06cc \u062c\u0633\u062a\u062c\u0648\u06cc \u0645\u0642\u0627\u062f\u06cc\u0631 \u0648 MAX \u0628\u0631\u0627\u06cc \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0646 \u0628\u0632\u0631\u06af\u062a\u0631\u06cc\u0646 \u0639\u062f\u062f \u062f\u0631 \u0645\u062c\u0645\u0648\u0639\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u0646\u062f. \u0627\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627 \u0627\u0628\u0632\u0627\u0631\u0647\u0627\u06cc \u0642\u062f\u0631\u062a\u0645\u0646\u062f\u06cc \u0631\u0627 \u0628\u0631\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0627\u06a9\u0633\u0644 \u0641\u0631\u0627\u0647\u0645 \u0645\u06cc\u200c\u06a9\u0646\u0646\u062f \u062a\u0627 \u0628\u0627 \u062f\u0642\u062a \u0648 \u06a9\u0627\u0631\u0627\u06cc\u06cc \u0628\u06cc\u0634\u062a\u0631\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u062a\u062d\u0644\u06cc\u0644 \u06a9\u0646\u0646\u062f \u0648 \u0628\u0647 \u0646\u062a\u0627\u06cc\u062c \u0645\u0637\u0644\u0648\u0628 \u0628\u0631\u0633\u0646\u062f.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u0627\u06a9\u0633\u0644 \u06cc\u06a9\u06cc \u0627\u0632 \u0642\u062f\u0631\u062a\u0645\u0646\u062f\u062a\u0631\u06cc\u0646 \u0646\u0631\u0645\u200c\u0627\u0641\u0632\u0627\u0631\u0647\u0627\u06cc \u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0648 \u0627\u0646\u062c\u0627\u0645 \u0645\u062d\u0627\u0633\u0628\u0627\u062a \u067e\u06cc\u0686\u06cc\u062f\u0647 \u0627\u0633\u062a. \u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641\u06cc \u06a9\u0647 \u062f\u0631 \u0627\u06cc\u0646 \u0646\u0631\u0645\u200c\u0627\u0641\u0632\u0627\u0631 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u0646\u062f\u060c \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 \u0628\u0647\u200c\u0633\u0627\u062f\u06af\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u067e\u0631\u062f\u0627\u0632\u0634 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u06a9\u0646\u0646\u062f. \u062f\u0631 \u0627\u06cc\u0646 \u0645\u062a\u0646\u060c \u0628\u0647 \u0628\u0631\u0631\u0633\u06cc \u0686\u0646\u062f \u0641\u0631\u0645\u0648\u0644 \u067e\u0631\u06a9\u0627\u0631\u0628\u0631\u062f \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0634\u0627\u0645\u0644 SUM\u060c AVERAGE\u060c COUNT\u060c IF\u060c VLOOKUP\u060c HLOOKUP \u0648 MAX \u067e\u0631\u062f\u0627\u062e\u062a\u0647 \u0634\u062f\u0647 &hellip;<\/p>\n","protected":false},"author":21,"featured_media":19300,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[129,11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.4 (Yoast SEO v21.4) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627\u06cc \u067e\u0631\u06a9\u0627\u0631\u0628\u0631\u062f \u0627\u06a9\u0633\u0644 (Excel): \u0631\u0627\u0647\u0646\u0645\u0627\u06cc \u06a9\u0627\u0645\u0644 | \u06a9\u0627\u0645\u067e\u06cc\u0648\u062a\u0631 \u0627\u0641\u0642<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/iranfso.com\/blog\/microsoft-excel-formulas-functions\/\" \/>\n<meta property=\"og:locale\" content=\"fa_IR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627\u06cc \u067e\u0631\u06a9\u0627\u0631\u0628\u0631\u062f \u0627\u06a9\u0633\u0644 (Excel): \u0631\u0627\u0647\u0646\u0645\u0627\u06cc \u06a9\u0627\u0645\u0644\" \/>\n<meta property=\"og:description\" content=\"\u0627\u06a9\u0633\u0644 \u06cc\u06a9\u06cc \u0627\u0632 \u0642\u062f\u0631\u062a\u0645\u0646\u062f\u062a\u0631\u06cc\u0646 \u0646\u0631\u0645\u200c\u0627\u0641\u0632\u0627\u0631\u0647\u0627\u06cc \u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0648 \u0627\u0646\u062c\u0627\u0645 \u0645\u062d\u0627\u0633\u0628\u0627\u062a \u067e\u06cc\u0686\u06cc\u062f\u0647 \u0627\u0633\u062a. \u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641\u06cc \u06a9\u0647 \u062f\u0631 \u0627\u06cc\u0646 \u0646\u0631\u0645\u200c\u0627\u0641\u0632\u0627\u0631 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u0646\u062f\u060c \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 \u0628\u0647\u200c\u0633\u0627\u062f\u06af\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u067e\u0631\u062f\u0627\u0632\u0634 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u06a9\u0646\u0646\u062f. \u062f\u0631 \u0627\u06cc\u0646 \u0645\u062a\u0646\u060c \u0628\u0647 \u0628\u0631\u0631\u0633\u06cc \u0686\u0646\u062f \u0641\u0631\u0645\u0648\u0644 \u067e\u0631\u06a9\u0627\u0631\u0628\u0631\u062f \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0634\u0627\u0645\u0644 SUM\u060c AVERAGE\u060c COUNT\u060c IF\u060c VLOOKUP\u060c HLOOKUP \u0648 MAX \u067e\u0631\u062f\u0627\u062e\u062a\u0647 \u0634\u062f\u0647 &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/iranfso.com\/blog\/microsoft-excel-formulas-functions\/\" \/>\n<meta property=\"og:site_name\" content=\"\u06a9\u0627\u0645\u067e\u06cc\u0648\u062a\u0631 \u0627\u0641\u0642\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/iranfsopage\" \/>\n<meta property=\"article:published_time\" content=\"2024-07-28T10:55:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-09T11:03:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/iranfso.com\/blog\/wp-content\/uploads\/2024\/07\/cover-5.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"780\" \/>\n\t<meta property=\"og:image:height\" content=\"470\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"\u06a9\u0627\u0645\u067e\u06cc\u0648\u062a\u0631 \u0627\u0641\u0642\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0646\u0648\u0634\u062a\u0647 \u0634\u062f\u0647 \u062a\u0648\u0633\u0637\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u06a9\u0627\u0645\u067e\u06cc\u0648\u062a\u0631 \u0627\u0641\u0642\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u0632\u0645\u0627\u0646 \u062a\u062e\u0645\u06cc\u0646\u06cc \u0645\u0637\u0627\u0644\u0639\u0647\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 \u062f\u0642\u06cc\u0642\u0647\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/iranfso.com\/blog\/microsoft-excel-formulas-functions\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/iranfso.com\/blog\/microsoft-excel-formulas-functions\/\"},\"author\":{\"name\":\"\u06a9\u0627\u0645\u067e\u06cc\u0648\u062a\u0631 \u0627\u0641\u0642\",\"@id\":\"https:\/\/iranfso.com\/blog\/#\/schema\/person\/1515f9e7d35b2fd9071f6637115d39b8\"},\"headline\":\"\u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627\u06cc \u067e\u0631\u06a9\u0627\u0631\u0628\u0631\u062f \u0627\u06a9\u0633\u0644 (Excel): \u0631\u0627\u0647\u0646\u0645\u0627\u06cc \u06a9\u0627\u0645\u0644\",\"datePublished\":\"2024-07-28T10:55:58+00:00\",\"dateModified\":\"2024-11-09T11:03:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/iranfso.com\/blog\/microsoft-excel-formulas-functions\/\"},\"wordCount\":212,\"commentCount\":6,\"publisher\":{\"@id\":\"https:\/\/iranfso.com\/blog\/#organization\"},\"articleSection\":[\"\u062a\u0631\u0641\u0646\u062f \u0647\u0627\u06cc \u0646\u0631\u0645 \u0627\u0641\u0632\u0627\u0631\",\"\u0645\u0642\u0627\u0644\u0647\"],\"inLanguage\":\"fa-IR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/iranfso.com\/blog\/microsoft-excel-formulas-functions\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/iranfso.com\/blog\/microsoft-excel-formulas-functions\/\",\"url\":\"https:\/\/iranfso.com\/blog\/microsoft-excel-formulas-functions\/\",\"name\":\"\u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627\u06cc \u067e\u0631\u06a9\u0627\u0631\u0628\u0631\u062f \u0627\u06a9\u0633\u0644 (Excel): \u0631\u0627\u0647\u0646\u0645\u0627\u06cc \u06a9\u0627\u0645\u0644 | \u06a9\u0627\u0645\u067e\u06cc\u0648\u062a\u0631 \u0627\u0641\u0642\",\"isPartOf\":{\"@id\":\"https:\/\/iranfso.com\/blog\/#website\"},\"datePublished\":\"2024-07-28T10:55:58+00:00\",\"dateModified\":\"2024-11-09T11:03:53+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/iranfso.com\/blog\/microsoft-excel-formulas-functions\/#breadcrumb\"},\"inLanguage\":\"fa-IR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/iranfso.com\/blog\/microsoft-excel-formulas-functions\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/iranfso.com\/blog\/microsoft-excel-formulas-functions\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u062e\u0627\u0646\u0647\",\"item\":\"https:\/\/iranfso.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627\u06cc \u067e\u0631\u06a9\u0627\u0631\u0628\u0631\u062f \u0627\u06a9\u0633\u0644 (Excel): \u0631\u0627\u0647\u0646\u0645\u0627\u06cc \u06a9\u0627\u0645\u0644\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/iranfso.com\/blog\/#website\",\"url\":\"https:\/\/iranfso.com\/blog\/\",\"name\":\"\u06a9\u0627\u0645\u067e\u06cc\u0648\u062a\u0631 \u0627\u0641\u0642\",\"description\":\"\u0628\u0644\u0627\u06af \u06a9\u0627\u0645\u067e\u06cc\u0648\u062a\u0631 \u0627\u0641\u0642\",\"publisher\":{\"@id\":\"https:\/\/iranfso.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/iranfso.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fa-IR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/iranfso.com\/blog\/#organization\",\"name\":\"\u06a9\u0627\u0645\u067e\u06cc\u0648\u062a\u0631 \u0627\u0641\u0642\",\"url\":\"https:\/\/iranfso.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fa-IR\",\"@id\":\"https:\/\/iranfso.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/iranfso.com\/blog\/wp-content\/uploads\/2021\/11\/FSO_Logo-final-160x100-1.webp\",\"contentUrl\":\"https:\/\/iranfso.com\/blog\/wp-content\/uploads\/2021\/11\/FSO_Logo-final-160x100-1.webp\",\"width\":160,\"height\":100,\"caption\":\"\u06a9\u0627\u0645\u067e\u06cc\u0648\u062a\u0631 \u0627\u0641\u0642\"},\"image\":{\"@id\":\"https:\/\/iranfso.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/iranfsopage\",\"https:\/\/www.linkedin.com\/in\/iranfso\/\",\"https:\/\/www.youtube.com\/channel\/UCIRdVfBMIz60n_rVVHC_Skw\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/iranfso.com\/blog\/#\/schema\/person\/1515f9e7d35b2fd9071f6637115d39b8\",\"name\":\"\u06a9\u0627\u0645\u067e\u06cc\u0648\u062a\u0631 \u0627\u0641\u0642\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fa-IR\",\"@id\":\"https:\/\/iranfso.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b43982628e96d29fac25d63231116395?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b43982628e96d29fac25d63231116395?s=96&d=mm&r=g\",\"caption\":\"\u06a9\u0627\u0645\u067e\u06cc\u0648\u062a\u0631 \u0627\u0641\u0642\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627\u06cc \u067e\u0631\u06a9\u0627\u0631\u0628\u0631\u062f \u0627\u06a9\u0633\u0644 (Excel): \u0631\u0627\u0647\u0646\u0645\u0627\u06cc \u06a9\u0627\u0645\u0644 | \u06a9\u0627\u0645\u067e\u06cc\u0648\u062a\u0631 \u0627\u0641\u0642","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/iranfso.com\/blog\/microsoft-excel-formulas-functions\/","og_locale":"fa_IR","og_type":"article","og_title":"\u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627\u06cc \u067e\u0631\u06a9\u0627\u0631\u0628\u0631\u062f \u0627\u06a9\u0633\u0644 (Excel): \u0631\u0627\u0647\u0646\u0645\u0627\u06cc \u06a9\u0627\u0645\u0644","og_description":"\u0627\u06a9\u0633\u0644 \u06cc\u06a9\u06cc \u0627\u0632 \u0642\u062f\u0631\u062a\u0645\u0646\u062f\u062a\u0631\u06cc\u0646 \u0646\u0631\u0645\u200c\u0627\u0641\u0632\u0627\u0631\u0647\u0627\u06cc \u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0648 \u0627\u0646\u062c\u0627\u0645 \u0645\u062d\u0627\u0633\u0628\u0627\u062a \u067e\u06cc\u0686\u06cc\u062f\u0647 \u0627\u0633\u062a. \u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641\u06cc \u06a9\u0647 \u062f\u0631 \u0627\u06cc\u0646 \u0646\u0631\u0645\u200c\u0627\u0641\u0632\u0627\u0631 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u0646\u062f\u060c \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 \u0628\u0647\u200c\u0633\u0627\u062f\u06af\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u067e\u0631\u062f\u0627\u0632\u0634 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u06a9\u0646\u0646\u062f. \u062f\u0631 \u0627\u06cc\u0646 \u0645\u062a\u0646\u060c \u0628\u0647 \u0628\u0631\u0631\u0633\u06cc \u0686\u0646\u062f \u0641\u0631\u0645\u0648\u0644 \u067e\u0631\u06a9\u0627\u0631\u0628\u0631\u062f \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0634\u0627\u0645\u0644 SUM\u060c AVERAGE\u060c COUNT\u060c IF\u060c VLOOKUP\u060c HLOOKUP \u0648 MAX \u067e\u0631\u062f\u0627\u062e\u062a\u0647 \u0634\u062f\u0647 &hellip;","og_url":"https:\/\/iranfso.com\/blog\/microsoft-excel-formulas-functions\/","og_site_name":"\u06a9\u0627\u0645\u067e\u06cc\u0648\u062a\u0631 \u0627\u0641\u0642","article_publisher":"https:\/\/www.facebook.com\/iranfsopage","article_published_time":"2024-07-28T10:55:58+00:00","article_modified_time":"2024-11-09T11:03:53+00:00","og_image":[{"width":780,"height":470,"url":"https:\/\/iranfso.com\/blog\/wp-content\/uploads\/2024\/07\/cover-5.jpg","type":"image\/jpeg"}],"author":"\u06a9\u0627\u0645\u067e\u06cc\u0648\u062a\u0631 \u0627\u0641\u0642","twitter_card":"summary_large_image","twitter_misc":{"\u0646\u0648\u0634\u062a\u0647 \u0634\u062f\u0647 \u062a\u0648\u0633\u0637":"\u06a9\u0627\u0645\u067e\u06cc\u0648\u062a\u0631 \u0627\u0641\u0642","\u0632\u0645\u0627\u0646 \u062a\u062e\u0645\u06cc\u0646\u06cc \u0645\u0637\u0627\u0644\u0639\u0647":"4 \u062f\u0642\u06cc\u0642\u0647"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/iranfso.com\/blog\/microsoft-excel-formulas-functions\/#article","isPartOf":{"@id":"https:\/\/iranfso.com\/blog\/microsoft-excel-formulas-functions\/"},"author":{"name":"\u06a9\u0627\u0645\u067e\u06cc\u0648\u062a\u0631 \u0627\u0641\u0642","@id":"https:\/\/iranfso.com\/blog\/#\/schema\/person\/1515f9e7d35b2fd9071f6637115d39b8"},"headline":"\u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627\u06cc \u067e\u0631\u06a9\u0627\u0631\u0628\u0631\u062f \u0627\u06a9\u0633\u0644 (Excel): \u0631\u0627\u0647\u0646\u0645\u0627\u06cc \u06a9\u0627\u0645\u0644","datePublished":"2024-07-28T10:55:58+00:00","dateModified":"2024-11-09T11:03:53+00:00","mainEntityOfPage":{"@id":"https:\/\/iranfso.com\/blog\/microsoft-excel-formulas-functions\/"},"wordCount":212,"commentCount":6,"publisher":{"@id":"https:\/\/iranfso.com\/blog\/#organization"},"articleSection":["\u062a\u0631\u0641\u0646\u062f \u0647\u0627\u06cc \u0646\u0631\u0645 \u0627\u0641\u0632\u0627\u0631","\u0645\u0642\u0627\u0644\u0647"],"inLanguage":"fa-IR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/iranfso.com\/blog\/microsoft-excel-formulas-functions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/iranfso.com\/blog\/microsoft-excel-formulas-functions\/","url":"https:\/\/iranfso.com\/blog\/microsoft-excel-formulas-functions\/","name":"\u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627\u06cc \u067e\u0631\u06a9\u0627\u0631\u0628\u0631\u062f \u0627\u06a9\u0633\u0644 (Excel): \u0631\u0627\u0647\u0646\u0645\u0627\u06cc \u06a9\u0627\u0645\u0644 | \u06a9\u0627\u0645\u067e\u06cc\u0648\u062a\u0631 \u0627\u0641\u0642","isPartOf":{"@id":"https:\/\/iranfso.com\/blog\/#website"},"datePublished":"2024-07-28T10:55:58+00:00","dateModified":"2024-11-09T11:03:53+00:00","breadcrumb":{"@id":"https:\/\/iranfso.com\/blog\/microsoft-excel-formulas-functions\/#breadcrumb"},"inLanguage":"fa-IR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/iranfso.com\/blog\/microsoft-excel-formulas-functions\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/iranfso.com\/blog\/microsoft-excel-formulas-functions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u062e\u0627\u0646\u0647","item":"https:\/\/iranfso.com\/blog\/"},{"@type":"ListItem","position":2,"name":"\u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627\u06cc \u067e\u0631\u06a9\u0627\u0631\u0628\u0631\u062f \u0627\u06a9\u0633\u0644 (Excel): \u0631\u0627\u0647\u0646\u0645\u0627\u06cc \u06a9\u0627\u0645\u0644"}]},{"@type":"WebSite","@id":"https:\/\/iranfso.com\/blog\/#website","url":"https:\/\/iranfso.com\/blog\/","name":"\u06a9\u0627\u0645\u067e\u06cc\u0648\u062a\u0631 \u0627\u0641\u0642","description":"\u0628\u0644\u0627\u06af \u06a9\u0627\u0645\u067e\u06cc\u0648\u062a\u0631 \u0627\u0641\u0642","publisher":{"@id":"https:\/\/iranfso.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/iranfso.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fa-IR"},{"@type":"Organization","@id":"https:\/\/iranfso.com\/blog\/#organization","name":"\u06a9\u0627\u0645\u067e\u06cc\u0648\u062a\u0631 \u0627\u0641\u0642","url":"https:\/\/iranfso.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"fa-IR","@id":"https:\/\/iranfso.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/iranfso.com\/blog\/wp-content\/uploads\/2021\/11\/FSO_Logo-final-160x100-1.webp","contentUrl":"https:\/\/iranfso.com\/blog\/wp-content\/uploads\/2021\/11\/FSO_Logo-final-160x100-1.webp","width":160,"height":100,"caption":"\u06a9\u0627\u0645\u067e\u06cc\u0648\u062a\u0631 \u0627\u0641\u0642"},"image":{"@id":"https:\/\/iranfso.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/iranfsopage","https:\/\/www.linkedin.com\/in\/iranfso\/","https:\/\/www.youtube.com\/channel\/UCIRdVfBMIz60n_rVVHC_Skw"]},{"@type":"Person","@id":"https:\/\/iranfso.com\/blog\/#\/schema\/person\/1515f9e7d35b2fd9071f6637115d39b8","name":"\u06a9\u0627\u0645\u067e\u06cc\u0648\u062a\u0631 \u0627\u0641\u0642","image":{"@type":"ImageObject","inLanguage":"fa-IR","@id":"https:\/\/iranfso.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b43982628e96d29fac25d63231116395?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b43982628e96d29fac25d63231116395?s=96&d=mm&r=g","caption":"\u06a9\u0627\u0645\u067e\u06cc\u0648\u062a\u0631 \u0627\u0641\u0642"}}]}},"_links":{"self":[{"href":"https:\/\/iranfso.com\/blog\/wp-json\/wp\/v2\/posts\/19261"}],"collection":[{"href":"https:\/\/iranfso.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/iranfso.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/iranfso.com\/blog\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/iranfso.com\/blog\/wp-json\/wp\/v2\/comments?post=19261"}],"version-history":[{"count":12,"href":"https:\/\/iranfso.com\/blog\/wp-json\/wp\/v2\/posts\/19261\/revisions"}],"predecessor-version":[{"id":19344,"href":"https:\/\/iranfso.com\/blog\/wp-json\/wp\/v2\/posts\/19261\/revisions\/19344"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/iranfso.com\/blog\/wp-json\/wp\/v2\/media\/19300"}],"wp:attachment":[{"href":"https:\/\/iranfso.com\/blog\/wp-json\/wp\/v2\/media?parent=19261"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/iranfso.com\/blog\/wp-json\/wp\/v2\/categories?post=19261"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/iranfso.com\/blog\/wp-json\/wp\/v2\/tags?post=19261"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}