{"id":9374,"date":"2024-06-10T12:40:16","date_gmt":"2024-06-10T09:10:16","guid":{"rendered":"https:\/\/officebaz.ir\/ex\/?p=9374"},"modified":"2024-06-11T06:34:55","modified_gmt":"2024-06-11T03:04:55","slug":"switch","status":"publish","type":"post","link":"https:\/\/officebaz.ir\/ex\/switch\/","title":{"rendered":"\u062a\u0627\u0628\u0639 SWITCH \u0627\u06a9\u0633\u0644 \u062c\u0627\u06cc\u06af\u0632\u06cc\u0646 \u062a\u0627\u0628\u0639 IF"},"content":{"rendered":"<p>\u062a\u0627\u0628\u0639 SWITCH \u0627\u06a9\u0633\u0644 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u062c\u0627\u06cc\u06af\u0632\u06cc\u0646 \u0645\u0646\u0627\u0633\u0628\u06cc \u0628\u0631\u0627\u06cc \u062a\u0627\u0628\u0639 IF\u00a0 \u0648 \u06cc\u0627 \u062d\u062a\u06cc \u062a\u0627\u0628\u0639 IFS\u00a0 \u0628\u0627\u0634\u062f \u0632\u0645\u0627\u0646\u06cc \u06a9\u0647 \u0628\u062e\u0648\u0627\u0647\u06cc\u062f \u0634\u0631\u0648\u0637 \u0631\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u062a\u0648 \u062f\u0631 \u062a\u0648 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f \u060c \u0627\u0644\u0628\u062a\u0647 \u0628\u0631\u062e\u06cc \u06a9\u0627\u0628\u0631\u0627\u0646 \u0627\u06a9\u0633\u0644 \u0647\u0645 \u0639\u0645\u0644\u06a9\u0631\u062f \u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u0631\u0627 \u0628\u0627 \u062a\u0627\u0628\u0639 CHOOSE\u00a0 \u0627\u0634\u062a\u0628\u0627\u0647 \u0645\u06cc\u06af\u06cc\u0631\u0646\u062f \u06a9\u0647 \u062f\u0631 \u0627\u062f\u0627\u0645\u0647 \u0628\u0627 \u062a\u0648\u0636\u06cc\u062d\u0627\u062a\u06cc \u06a9\u0647 \u062f\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f \u0645\u062a\u0648\u062c\u0647 \u062a\u0641\u0627\u0648\u062a\u0647\u0627\u06cc \u0627\u06cc\u0646 \u062a\u0648\u0627\u0628\u0639 \u062e\u0648\u0627\u0647\u06cc\u062f \u0634\u062f .<\/p>\n\n\n<h2 class=\"wp-block-heading\">\u0645\u062b\u0627\u0644 \u0633\u0627\u062f\u0647 \u0627\u0632 \u062a\u0627\u0628\u0639 SWITCH<\/h2>\n\n\n<p>\u0641\u0631\u0636 \u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u062f\u0631 \u0645\u062d\u062f\u0648\u062f\u0647 B3:B9 \u0627\u0639\u062f\u0627\u062f 1 \u062a\u0627 7 \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0648 \u062f\u0631 \u0633\u062a\u0648\u0646 \u0645\u0642\u0627\u0628\u0644 \u06cc\u0639\u0646\u06cc C3:C9 \u0631\u0648\u0632\u0647\u0627\u06cc \u0647\u0641\u062a\u0647 \u0627\u0632 \u0634\u0646\u0628\u0647 \u062a\u0627 \u062c\u0645\u0639\u0647 \u0646\u0648\u0634\u062a\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a \u0648 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645 \u0627\u06af\u0631 \u0645\u0642\u062f\u0627\u0631 \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u062f\u0631 \u0633\u0644\u0648\u0644 E3 \u0628\u0631\u0627\u0628\u0631 \u0647\u0631 \u06a9\u062f\u0627\u0645 \u06a9\u0647 \u0628\u0648\u062f \u0631\u0648\u0632 \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u0622\u0646 \u0631\u0627 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0647\u062f .<\/p>\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:false,&quot;languageLabel&quot;:&quot;file&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;vbscript&quot;,&quot;mime&quot;:&quot;text\/vbscript&quot;,&quot;theme&quot;:&quot;abcdef&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;script.vbs&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VBScript&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vb&quot;}\">=SWITCH(E3,B3,C3,B4,C4,B5,C5,B6,C6,B7,C7,B8,C8,B9,C9,&quot;Not OK&quot;)<\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"611\" src=\"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/06\/SWITCH2-1024x611.png\" alt=\"\u0645\u062b\u0627\u0644 \u0633\u0627\u062f\u0647 \u062a\u0627\u0628\u0639 SWITCH\" class=\"wp-image-9381\" srcset=\"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/06\/SWITCH2-1024x611.png 1024w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/06\/SWITCH2-300x179.png 300w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/06\/SWITCH2-768x458.png 768w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/06\/SWITCH2-600x358.png 600w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/06\/SWITCH2.png 1121w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">\u0645\u062b\u0627\u0644 \u062f\u0648\u0645 &#8211; \u067e\u0627\u062f\u0627\u0634 \u0628\u0631 \u0627\u0633\u0627\u0633 \u0627\u0645\u062a\u06cc\u0627\u0632<\/h2>\n\n\n<p>\u0641\u0631\u0636 \u06a9\u06cc\u0646\u0645 \u06a9\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0645\u0634\u0627\u0628\u0647 \u062a\u0635\u0648\u06cc\u0631 \u0632\u06cc\u0631 \u062f\u0627\u0631\u06cc\u0645 \u0648 \u062f\u0631 \u0622\u0646 \u0646\u0627\u0645 \u067e\u0631\u0633\u0646\u0644 \u062b\u0628\u062a \u0634\u062f\u0647 \u0648 \u0628\u0631\u0627\u06cc \u0647\u0631\u06a9\u0633 \u0627\u0645\u062a\u06cc\u0627\u0632\u06cc \u062f\u0631 \u0646\u0638\u0631 \u06af\u0631\u0641\u062a\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a \u0648 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645 \u0628\u0631 \u0627\u0633\u0627\u0633 \u0634\u0631\u0648\u0637 \u0645\u062e\u062a\u0644\u0641 \u0645\u0634\u062e\u0635 \u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u0648\u0636\u0639\u06cc\u062a \u0622\u0646 \u06a9\u0627\u0631\u0645\u0646\u062f \u0628\u0647 \u0686\u0647 \u0634\u06a9\u0644 \u0627\u0633\u062a \u060c \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644 \u0627\u06af\u0631 \u0627\u0645\u062a\u06cc\u0627\u0632 \u0627\u0648 \u0627\u0632 0 \u062a\u0627 10 \u0628\u0648\u062f &#8221; Very Bad &#8221; \u0648 \u0627\u06af\u0631 \u0627\u0632 10 \u062a\u0627 30 \u0628\u0648\u062f &#8220;Not Bad&#8221; \u0648 \u0627\u06af\u0631 \u0627\u0632 30 \u062a\u0627 60 \u0628\u0648\u062f &#8220;Good&#8221; \u0648 \u0628\u0632\u0631\u06af\u062a\u0631 \u0627\u0632 60 \u0647\u0645 &#8220;Perfect&#8221; \u062f\u0631\u062c \u0634\u0648\u062f \u0648 \u0627\u06af\u0631 \u062f\u0631 \u0628\u0627\u0632\u0647 \u0639\u062f\u062f\u06cc \u0647\u0645 \u0646\u0628\u0648\u062f \u0645\u0642\u062f\u0627\u0631 &#8221; \u0645\u0639\u062a\u0628\u0631 \u0646\u0645\u06cc \u0628\u0627\u0634\u062f \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0634\u0648\u062f .<\/p>\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:false,&quot;languageLabel&quot;:&quot;file&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;vbscript&quot;,&quot;mime&quot;:&quot;text\/vbscript&quot;,&quot;theme&quot;:&quot;abcdef&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;script.vbs&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VBScript&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vb&quot;}\">=SWITCH(TRUE,E23&gt;=60,&quot;Perfect&quot;,E23&gt;=30,&quot;Good&quot;,E23&gt;=10,&quot;Not Bad&quot;,E23&gt;=0,&quot;Very Bad&quot;,&quot;\u0645\u0639\u062a\u0628\u0631 \u0646\u0645\u06cc \u0628\u0627\u0634\u062f&quot;)<\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"569\" src=\"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/06\/SWITCH3-1024x569.png\" alt=\"\u0627\u0645\u062a\u06cc\u0627\u0632 \u06a9\u0627\u0631\u0645\u0646\u062f\u0627\u0646 \u0628\u0627 \u062a\u0627\u0628\u0639 SWITCH\" class=\"wp-image-9382\" srcset=\"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/06\/SWITCH3-1024x569.png 1024w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/06\/SWITCH3-300x167.png 300w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/06\/SWITCH3-768x427.png 768w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/06\/SWITCH3-600x334.png 600w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/06\/SWITCH3.png 1119w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n<p>\u0627\u0644\u0628\u062a\u0647 \u0627\u06cc\u0646 \u0645\u0648\u0631\u062f \u0631\u0627 \u0647\u0645 \u0645\u06cc \u0634\u0648\u062f \u0628\u0627 \u062a\u0627\u0628\u0639 CHOOSE \u0646\u0648\u0634\u062a \u0648 \u0647\u0645 \u0628\u0627 \u062a\u0627\u0628\u0639 IF \u06a9\u0647 \u0627\u0644\u0628\u062a\u0647 \u0627\u0646\u062a\u062e\u0627\u0628 \u0628\u0627 \u0634\u0645\u0627\u0633\u062a \u0648 \u062a\u0641\u0627\u0648\u062a\u06cc \u062f\u0631 \u0646\u062a\u06cc\u062c\u0647 \u0648\u062c\u0648\u062f \u0646\u062f\u0627\u0631\u062f.<\/p>\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:false,&quot;languageLabel&quot;:&quot;file&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;vbscript&quot;,&quot;mime&quot;:&quot;text\/vbscript&quot;,&quot;theme&quot;:&quot;abcdef&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;script.vbs&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VBScript&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vb&quot;}\">=CHOOSE(MATCH(E23, {0, 10, 30, 60}), &quot;Very Bad&quot;, &quot;Not Bad&quot;, &quot;Good&quot;, &quot;Perfect&quot;)<\/pre><\/div>\n\n\n<p>\u062d\u0644 \u0645\u0633\u0626\u0644\u0647 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062a\u0627\u0628\u0639 IF \u062a\u0648 \u062f\u0631 \u062a\u0648\u00a0<\/p>\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:false,&quot;languageLabel&quot;:&quot;file&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;vbscript&quot;,&quot;mime&quot;:&quot;text\/vbscript&quot;,&quot;theme&quot;:&quot;abcdef&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;script.vbs&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VBScript&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vb&quot;}\">=IF(D3&lt;10,&quot;Very Bad&quot;,IF(D3&lt;30,&quot;Not Bad&quot;,IF(D3&lt;60,&quot;Good&quot;,&quot;Perfect&quot;)))<\/pre><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u0645\u062b\u0627\u0644 \u0633\u0648\u0645 &#8211; \u062a\u0631\u06a9\u06cc\u0628 SWITCH \u0628\u0627 VLOOKUP<\/h2>\n\n\n<p>\u0628\u0631\u0627\u06cc \u062f\u0631\u06a9 \u0628\u0647\u062a\u0631 <a href=\"https:\/\/exceljet.net\/functions\/switch-function\" target=\"_blank\" rel=\"noopener\">\u062a\u0627\u0628\u0639 SWITCH<\/a> \u062f\u0631 \u0627\u06cc\u0646 \u0645\u062b\u0627\u0644 \u0645\u06cc \u062e\u0648\u0627\u0647\u0645 \u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u0631\u0627 \u0628\u0627 \u062a\u0627\u0628\u0639 VLOOKUP \u062a\u0631\u06a9\u06cc\u0628 \u06a9\u0646\u0645 \u062a\u0627 \u0628\u0647 \u0646\u062a\u06cc\u062c\u0647 \u0628\u0631\u0633\u06cc\u0645 . \u0648 \u0635\u0648\u0631\u062a \u0645\u0633\u0626\u0644\u0647 \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u0645\u0627 \u062f\u0648 \u0645\u062d\u062f\u0648\u062f\u0647 \u062c\u062f\u0627\u06af\u0627\u0646\u0647 \u0628\u0627 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u06cc\u06a9\u0633\u0627\u0646 \u062f\u0627\u0631\u06cc\u0645 \u0648 \u0648\u0642\u062a\u06cc \u06a9\u0627\u0631\u0628\u0631 \u06af\u0631\u0648\u0647 \u0648 \u06a9\u062f \u067e\u0631\u0633\u0646\u0644\u06cc \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0631\u062f \u0628\u0627\u06cc\u062f \u0645\u06cc\u0632\u0627\u0646 \u0641\u0631\u0648\u0634 \u0627\u0648 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0634\u0648\u062f .<\/p>\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:false,&quot;languageLabel&quot;:&quot;file&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;vbscript&quot;,&quot;mime&quot;:&quot;text\/vbscript&quot;,&quot;theme&quot;:&quot;abcdef&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;script.vbs&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VBScript&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vb&quot;}\">=VLOOKUP(K3,SWITCH(J3,B1,B2:D8,F1,F2:H8),3,0)<\/pre><\/div>\n\n\n<p>\u062f\u0631 \u0633\u0644\u0648\u0644 j3 \u0644\u06cc\u0633\u062a \u06a9\u0634\u0648\u06cc\u06cc \u0627\u06cc\u062c\u0627\u062f \u0634\u062f\u0647 \u0648 \u06af\u0631\u0648\u0647 1 \u0648 \u06af\u0631\u0648\u0647 2 \u0627\u0646\u062a\u062e\u0628\u06cc \u0627\u0633\u062a \u0648 \u0628\u0631 \u0627\u0633\u0627\u0633 \u0627\u0646\u062a\u062e\u0627\u0628 \u0647\u0631 \u06a9\u062f\u0627\u0645 \u0645\u062d\u062f\u0648\u062f\u0647 \u0645\u062a\u0641\u0627\u0648\u062a\u06cc \u062f\u0631 \u0622\u0631\u06af\u0648\u0645\u0627\u0646 \u062f\u0648\u0645 VLOOKUP \u0642\u0631\u0627\u0631 \u0645\u06cc\u06af\u06cc\u0631\u062f.<\/p>\n\n\n<h2 class=\"wp-block-heading\">\u0645\u062b\u0627\u0644 \u0686\u0647\u0627\u0631\u0645 &#8211; \u0633\u0627\u062e\u062a\u0627\u0631 \u067e\u06cc\u0686\u06cc\u062f\u0647 \u062a\u0631 \u0628\u0627 SWITCH<\/h2>\n\n\n<p>\u0627\u0632 \u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u0628\u0631\u0627\u06cc \u062d\u0644 \u0645\u0633\u0627\u0626\u0644 \u067e\u06cc\u0686\u06cc\u062f\u0647 \u062a\u0631 \u0647\u0645 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f \u060c \u0645\u062b\u0644\u0627 \u062f\u0631 \u062c\u0627\u06cc\u06cc \u06a9\u0647 \u0628\u0627\u06cc\u062f \u062f\u0648 \u0634\u0631\u0637 \u062c\u062f\u0627\u06af\u0627\u0646\u0647 \u0628\u0631\u0631\u0633\u06cc \u0634\u0648\u062f .<\/p>\n<p>\u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644 \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0645\u062d\u062f\u0648\u062f\u0647 \u062f\u0627\u062f\u0647 \u062f\u0627\u0631\u06cc\u0645 \u06a9\u0647 \u062f\u0631 \u0622\u0646 \u06a9\u062f \u067e\u0631\u0633\u0646\u0644\u06cc \u0648 \u062c\u0627\u06cc\u06af\u0627\u0647 \u0634\u063a\u0644\u06cc \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0627\u0633\u062a \u0648 \u0628\u0631 \u0627\u0633\u0627\u0633 \u062c\u0627\u06cc\u06af\u0627\u0647 \u0634\u063a\u0644\u06cc \u0648 \u0627\u0645\u062a\u06cc\u0627\u0632 \u06a9\u0633\u0628 \u0634\u062f\u0647 \u0642\u0631\u0627\u0631 \u0627\u0633\u062a \u067e\u0627\u062f\u0627\u0634 \u062f\u0631\u06cc\u0627\u0641\u062a \u06a9\u0646\u0646\u062f .<\/p>\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:false,&quot;languageLabel&quot;:&quot;file&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;vbscript&quot;,&quot;mime&quot;:&quot;text\/vbscript&quot;,&quot;theme&quot;:&quot;abcdef&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;script.vbs&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VBScript&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vb&quot;}\">=SWITCH(B3,&quot;\u0645\u062f\u06cc\u0631&quot;,IF(C3 &gt; 10, 5000, 3000),&quot;\u0645\u0639\u0627\u0648\u0646&quot;,IF(C3 &gt; 5, 3500, 2000),&quot;\u06a9\u0627\u0631\u0645\u0646\u062f&quot;, IF(C3&gt;3,2000, 1000),&quot;\u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0646\u0627\u0645\u0639\u062a\u0628\u0631&quot;)<\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"474\" src=\"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/06\/SWITCH5-1024x474.png\" alt=\"\u062a\u0627\u0628\u0639 SWITCH \u0628\u0627 \u0686\u0646\u062f \u0634\u0631\u0637\" class=\"wp-image-9383\" srcset=\"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/06\/SWITCH5-1024x474.png 1024w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/06\/SWITCH5-300x139.png 300w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/06\/SWITCH5-768x355.png 768w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/06\/SWITCH5-600x278.png 600w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/06\/SWITCH5.png 1135w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n<p>\u0627\u0644\u0628\u062a\u0647 \u0627\u06cc\u0646 \u06cc\u06a9 \u0641\u0631\u0645\u0648\u0644 \u067e\u06cc\u0634\u0646\u0647\u0627\u062f\u06cc \u0645\u06cc \u0628\u0627\u0634\u062f \u0648 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0628\u0631\u0627\u0628\u0631 \u0628\u0627 \u0645\u0642\u0627\u062f\u0631\u06cc \u062f\u06cc\u06af\u0631\u06cc \u0628\u0627\u0634\u062f \u0645\u062b\u0644\u0627 \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0648\u0631\u062f \u0645\u062f\u06cc\u0631 \u0648 \u0645\u0639\u0627\u0648\u0646 \u0628\u0627 \u062a\u0648\u062c\u0647 \u0628\u0647 \u0627\u0645\u062a\u06cc\u0627\u0632 \u06cc\u06a9\u0633\u0627\u0646 \u067e\u0627\u062f\u0627\u0634\u0647\u0627\u06cc \u0645\u062a\u0641\u0627\u0648\u062a\u06cc \u062f\u0631\u06cc\u0627\u0641\u062a \u06a9\u0631\u062f\u0647 \u0627\u0646\u062f \u0648 \u062a\u0645\u0627\u0645 \u067e\u0627\u0631\u0627\u0645\u062a\u0631\u0647\u0627 \u0642\u0627\u0628\u0644 \u062a\u063a\u06cc\u06cc\u0631 \u0627\u0633\u062a \u0648 \u0645\u0647\u0645 \u062f\u0631\u06a9 \u0646\u062d\u0648\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0635\u062d\u06cc\u062d \u0627\u0632 \u062a\u0627\u0628\u0639 SWITCH \u0645\u06cc \u0628\u0627\u0634\u062f.<\/p>\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button has-custom-width wp-block-button__width-100\"><a class=\"wp-block-button__link has-light-green-cyan-color has-text-color has-background has-link-color wp-element-button\" href=\"https:\/\/www.dl.officebaz.ir\/free\/PDF\/SWITCH.pdf\" style=\"border-radius:12px;background-color:#274d41\">\u062f\u0627\u0646\u0644\u0648\u062f \u0646\u0633\u062e\u0647 PDF \u0622\u0645\u0648\u0632\u0634<\/a><\/div>\n<\/div>\n\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-center kksr-valign-bottom\"\n    data-payload='{&quot;align&quot;:&quot;center&quot;,&quot;id&quot;:&quot;9374&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;bottom&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;4&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;4.5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;4&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;4.5\\\/5 - (4 \u0627\u0645\u062a\u06cc\u0627\u0632)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;\u062a\u0627\u0628\u0639 SWITCH \u0627\u06a9\u0633\u0644 \u062c\u0627\u06cc\u06af\u0632\u06cc\u0646 \u062a\u0627\u0628\u0639 IF&quot;,&quot;width&quot;:&quot;124&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 124px;\">\n            <div class=\"kksr-star\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            4.5\/5 - (4 \u0627\u0645\u062a\u06cc\u0627\u0632)    <\/div>\n    <\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u062a\u0627\u0628\u0639 SWITCH \u0627\u06a9\u0633\u0644 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u062c\u0627\u06cc\u06af\u0632\u06cc\u0646 \u0645\u0646\u0627\u0633\u0628\u06cc \u0628\u0631\u0627\u06cc \u062a\u0627\u0628\u0639 IF\u00a0 \u0648 \u06cc\u0627 \u062d\u062a\u06cc \u062a\u0627\u0628\u0639 IFS\u00a0 \u0628\u0627\u0634\u062f \u0632\u0645\u0627\u0646\u06cc \u06a9\u0647 \u0628\u062e\u0648\u0627\u0647\u06cc\u062f \u0634\u0631\u0648\u0637 \u0631\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u062a\u0648 \u062f\u0631 \u062a\u0648 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f \u060c \u0627\u0644\u0628\u062a\u0647 \u0628\u0631\u062e\u06cc \u06a9\u0627\u0628\u0631\u0627\u0646 \u0627\u06a9\u0633\u0644 \u0647\u0645 \u0639\u0645\u0644\u06a9\u0631\u062f \u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u0631\u0627 \u0628\u0627 \u062a\u0627\u0628\u0639 CHOOSE\u00a0 \u0627\u0634\u062a\u0628\u0627\u0647 \u0645\u06cc\u06af\u06cc\u0631\u0646\u062f \u06a9\u0647 \u062f\u0631 \u0627\u062f\u0627\u0645\u0647 \u0628\u0627 \u062a\u0648\u0636\u06cc\u062d\u0627\u062a\u06cc \u06a9\u0647 \u062f\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f \u0645\u062a\u0648\u062c\u0647 \u062a\u0641\u0627\u0648\u062a\u0647\u0627\u06cc \u0627\u06cc\u0646 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":9375,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_uag_custom_page_level_css":"","advgb_blocks_editor_width":"","advgb_blocks_columns_visual_guide":"","footnotes":""},"categories":[33],"tags":[142,193],"class_list":["post-9374","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-function","tag-if","tag-switch"],"acf":[],"author_meta":{"display_name":"\u0646\u0627\u062f\u0631 \u0628\u062d\u0631\u06cc","author_link":"https:\/\/officebaz.ir\/ex\/author\/administrator\/"},"featured_img":"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/06\/SWITCH-300x169.png","uagb_featured_image_src":{"full":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/06\/SWITCH.png",1280,720,false],"thumbnail":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/06\/SWITCH-150x150.png",150,150,true],"medium":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/06\/SWITCH-300x169.png",300,169,true],"medium_large":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/06\/SWITCH-768x432.png",768,432,true],"large":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/06\/SWITCH-1024x576.png",800,450,true],"1536x1536":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/06\/SWITCH.png",1280,720,false],"2048x2048":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/06\/SWITCH.png",1280,720,false],"gform-image-choice-sm":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/06\/SWITCH.png",300,169,false],"gform-image-choice-md":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/06\/SWITCH.png",400,225,false],"gform-image-choice-lg":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/06\/SWITCH.png",600,338,false]},"uagb_author_info":{"display_name":"\u0646\u0627\u062f\u0631 \u0628\u062d\u0631\u06cc","author_link":"https:\/\/officebaz.ir\/ex\/author\/administrator\/"},"uagb_comment_info":1,"uagb_excerpt":"\u062a\u0627\u0628\u0639 SWITCH \u0627\u06a9\u0633\u0644 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u062c\u0627\u06cc\u06af\u0632\u06cc\u0646 \u0645\u0646\u0627\u0633\u0628\u06cc \u0628\u0631\u0627\u06cc \u062a\u0627\u0628\u0639 IF\u00a0 \u0648 \u06cc\u0627 \u062d\u062a\u06cc \u062a\u0627\u0628\u0639 IFS\u00a0 \u0628\u0627\u0634\u062f \u0632\u0645\u0627\u0646\u06cc \u06a9\u0647 \u0628\u062e\u0648\u0627\u0647\u06cc\u062f \u0634\u0631\u0648\u0637 \u0631\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u062a\u0648 \u062f\u0631 \u062a\u0648 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f \u060c \u0627\u0644\u0628\u062a\u0647 \u0628\u0631\u062e\u06cc \u06a9\u0627\u0628\u0631\u0627\u0646 \u0627\u06a9\u0633\u0644 \u0647\u0645 \u0639\u0645\u0644\u06a9\u0631\u062f \u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u0631\u0627 \u0628\u0627 \u062a\u0627\u0628\u0639 CHOOSE\u00a0 \u0627\u0634\u062a\u0628\u0627\u0647 \u0645\u06cc\u06af\u06cc\u0631\u0646\u062f \u06a9\u0647 \u062f\u0631 \u0627\u062f\u0627\u0645\u0647 \u0628\u0627 \u062a\u0648\u0636\u06cc\u062d\u0627\u062a\u06cc \u06a9\u0647 \u062f\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f \u0645\u062a\u0648\u062c\u0647 \u062a\u0641\u0627\u0648\u062a\u0647\u0627\u06cc \u0627\u06cc\u0646&hellip;","coauthors":[],"tax_additional":{"categories":{"linked":["<a href=\"https:\/\/officebaz.ir\/ex\/category\/function\/\" class=\"advgb-post-tax-term\">\u062a\u0648\u0627\u0628\u0639 \u0627\u06a9\u0633\u0644<\/a>"],"unlinked":["<span class=\"advgb-post-tax-term\">\u062a\u0648\u0627\u0628\u0639 \u0627\u06a9\u0633\u0644<\/span>"]},"tags":{"linked":["<a href=\"https:\/\/officebaz.ir\/ex\/category\/function\/\" class=\"advgb-post-tax-term\">IF<\/a>","<a href=\"https:\/\/officebaz.ir\/ex\/category\/function\/\" class=\"advgb-post-tax-term\">SWITCH<\/a>"],"unlinked":["<span class=\"advgb-post-tax-term\">IF<\/span>","<span class=\"advgb-post-tax-term\">SWITCH<\/span>"]}},"comment_count":"1","relative_dates":{"created":"\u0645\u0646\u062a\u0634\u0631 \u0634\u062f\u0647 2 \u0633\u0627\u0644 \u067e\u06cc\u0634","modified":"\u0628\u0647\u200c\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u0634\u062f\u0647 2 \u0633\u0627\u0644 \u067e\u06cc\u0634"},"absolute_dates":{"created":"\u0645\u0646\u062a\u0634\u0631 \u0634\u062f\u0647 \u062f\u0631 21 \u062e\u0631\u062f\u0627\u062f 1403","modified":"\u0628\u0647\u200c\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u0634\u062f\u0647 \u062f\u0631 22 \u062e\u0631\u062f\u0627\u062f 1403"},"absolute_dates_time":{"created":"\u0645\u0646\u062a\u0634\u0631 \u0634\u062f\u0647 \u062f\u0631 21 \u062e\u0631\u062f\u0627\u062f 1403 12:40 \u0642.\u0638","modified":"\u0628\u0647\u200c\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u0634\u062f\u0647 \u062f\u0631 22 \u062e\u0631\u062f\u0627\u062f 1403 6:34 \u0642.\u0638"},"featured_img_caption":"\u062a\u0627\u0628\u0639 SWITCH","series_order":"","_links":{"self":[{"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/posts\/9374","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/comments?post=9374"}],"version-history":[{"count":0,"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/posts\/9374\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/media\/9375"}],"wp:attachment":[{"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/media?parent=9374"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/categories?post=9374"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/tags?post=9374"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}