{"id":2126,"date":"2018-12-03T11:53:26","date_gmt":"2018-12-03T06:23:26","guid":{"rendered":"https:\/\/www.joshtalks.com\/joshkosh\/?p=2126"},"modified":"2019-01-04T13:15:03","modified_gmt":"2019-01-04T07:45:03","slug":"%e0%a4%8f%e0%a4%ae%e0%a4%8f%e0%a4%b8-%e0%a4%8f%e0%a4%95%e0%a5%8d%e0%a4%b8%e0%a5%87%e0%a4%b2-%e0%a4%ab%e0%a4%82%e0%a4%95%e0%a5%8d%e0%a4%b6%e0%a4%a8","status":"publish","type":"post","link":"https:\/\/www.joshtalks.com\/joshkosh\/hi\/%e0%a4%95%e0%a4%b0%e0%a4%bf%e0%a4%af%e0%a4%b0\/%e0%a4%8f%e0%a4%ae%e0%a4%8f%e0%a4%b8-%e0%a4%8f%e0%a4%95%e0%a5%8d%e0%a4%b8%e0%a5%87%e0%a4%b2-%e0%a4%ab%e0%a4%82%e0%a4%95%e0%a5%8d%e0%a4%b6%e0%a4%a8\/","title":{"rendered":"\u090f\u092e\u090f\u0938 \u090f\u0915\u094d\u0938\u0947\u0932 \u0915\u0947 \u092b\u0902\u0915\u094d\u0936\u0928"},"content":{"rendered":"<p style=\"text-align: center;\"><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/skill-development-courses\/ms-excel-functions\/\"><span class=\"td_btn td_btn_sm td_round_btn td_btn_md td_shadow_btn\">Hinglish \u092e\u0947\u0902 \u092a\u095d\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u092f\u0939\u093e\u0901 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947\u0902<\/span><\/a><\/p>\n<p><span style=\"font-weight: 400;\">\u090f\u092e\u090f\u0938 \u090f\u0915\u094d\u0938\u0947\u0932 \u090f\u0915 \u0924\u0930\u0939 \u0915\u093e \u0915\u0948\u0932\u0915\u0941\u0932\u0947\u091f\u0930 \u0939\u094b\u0924\u093e \u0939\u0948. \u090f\u0915\u094d\u0938\u0947\u0932 \u092e\u0947\u0902 \u092c\u0939\u0941\u0924 \u0906\u0938\u093e\u0928\u0940 \u0938\u0947 \u0915\u0948\u0932\u0915\u0941\u0932\u0947\u0936\u0928 \u0915\u0940 \u091c\u093e \u0938\u0915\u0924\u0940 \u0939\u0948. \u091a\u093e\u0939\u0947 \u0915\u093f\u0924\u0928\u093e \u092d\u0940 \u092c\u095c\u093e \u0921\u093e\u091f\u093e \u0939\u094b \u0932\u0947\u0915\u093f\u0928 \u090f\u0915\u094d\u0938\u0947\u0932 \u0915\u0940 \u092e\u0926\u0926 \u0938\u0947 \u0915\u0941\u091b \u0938\u0947\u0915\u0902\u0921 \u092e\u0947\u0902 \u0939\u0940 \u0938\u092c \u0915\u0948\u0932\u0915\u0941\u0932\u0947\u0936\u0928 \u0915\u0940 \u091c\u093e \u0938\u0915\u0924\u0940 \u0939\u0948. \u0907\u0938 \u0906\u0930\u094d\u091f\u093f\u0915\u0932 \u092e\u0947\u0902 \u0915\u094b \u092a\u095d\u0915\u0930 \u0918\u0930 \u092c\u0948\u0920\u0947 \u0939\u0940 \u0906\u092a \u090f\u092e\u090f\u0938 \u090f\u0915\u094d\u0938\u0947\u0932 \u0915\u0947 \u092b\u0902\u0915\u094d\u0936\u0928 \u0938\u0940\u0916 \u0938\u0915\u0924\u0947 \u0939\u0948.<\/span><\/p>\n<h2><strong>\u0907\u0938 \u0906\u0930\u094d\u091f\u093f\u0915\u0932 \u092e\u0947\u0902 \u0906\u092a \u0906\u0938\u093e\u0928\u0940 \u0938\u0947 \u090f\u092e\u090f\u0938 \u090f\u0915\u094d\u0938\u0947\u0932 \u0915\u0947 \u092b\u0902\u0915\u094d\u0936\u0928 \u0938\u0940\u0916 \u0938\u0915\u0924\u0947 \u0939\u0948:<\/strong><\/h2>\n<p><strong><a href=\"#maths\">\u092e\u0948\u0925\u0947\u092e\u0947\u091f\u093f\u0915\u0932 \u092b\u0902\u0915\u094d\u0936\u0928<\/a><\/strong><br \/>\n<strong><a href=\"#stats\">\u0938\u094d\u091f\u0947\u091f\u093f\u0915\u0932 \u092b\u0902\u0915\u094d\u0936\u0928<\/a><\/strong><br \/>\n<strong><a href=\"#log\">\u0932\u0949\u091c\u093f\u0915\u0932 \u092b\u0902\u0915\u094d\u0936\u0928<\/a><\/strong><br \/>\n<strong><a href=\"#text\">\u091f\u0947\u0915\u094d\u0938\u094d\u091f \u092b\u0902\u0915\u094d\u0936\u0928<\/a><\/strong><br \/>\n<a href=\"#other\"><strong>\u0905\u0928\u094d\u092f \u092b\u0902\u0915\u094d\u0936\u0928<\/strong><\/a><\/p>\n<h3><strong>\u090f\u092e\u090f\u0938 \u090f\u0915\u094d\u0938\u0947\u0932 \u0915\u0947 \u092b\u0902\u0915\u094d\u0936\u0928<\/strong><\/h3>\n<p><span style=\"font-weight: 400;\">\u090f\u092e\u090f\u0938 \u090f\u0915\u094d\u0938\u0947\u0932 \u092b\u0902\u0915\u094d\u0936\u0928 \u0915\u0947 \u0932\u093f\u090f \u090f\u0915 \u095e\u0949\u0930\u094d\u092e\u0942\u0932\u093e \u0939\u0948 \u091c\u094b \u0939\u0930 \u0915\u0948\u0932\u0915\u0941\u0932\u0947\u0936\u0928 \u092e\u0947\u0902 \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948:<\/span><\/p>\n<p><span class=\"td_btn td_btn_sm td_round_btn td_btn_lg\"><span style=\"color: #ffff00;\">=formula<strong>(<\/strong><\/span><span style=\"font-weight: 400;\"><strong><span style=\"color: #ffff00;\">Value 1, Value 2, Value 3, \u2026\u2026 Value 20)<\/span> <\/strong>press <span style=\"color: #ffff00;\"><strong>ENTER<\/strong><\/span><\/span><\/span><\/p>\n<p><img class=\" wp-image-2015 aligncenter\" src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/basic-300x105.png\" alt=\"\" width=\"386\" height=\"135\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/basic-300x105.png 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/basic.png 611w\" sizes=\"(max-width: 386px) 100vw, 386px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>\u0935\u0948\u0932\u094d\u092f\u0942\u091c \u0926\u094b \u0938\u094d\u091f\u093e\u0907\u0932 \u092e\u0947\u0902 \u0921\u093e\u0932 \u0938\u0915\u0924\u0947 \u0939\u0948:<\/p>\n<ul>\n<li><strong>Cell range<\/strong><\/li>\n<\/ul>\n<p><span class=\"td_btn td_btn_lg td_round_btn\"><span style=\"color: #ffff00;\">=formula(A1:A10)\u00a0<\/span><span style=\"font-weight: 400;\">press <\/span><span style=\"color: #ffff00;\"><b>ENTER<\/b><\/span><\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u0909\u0926\u093e\u0939\u0930\u0923 \u0915\u0947 \u0932\u093f\u090f:<\/span> <span class=\"td_btn td_btn_lg td_round_btn\"><strong><span style=\"color: #ffff00;\">=sum(A1,A2,A3,&#8230;&#8230;&#8230;..A20)<\/span><\/strong> <span style=\"font-weight: 400;\">press <strong><span style=\"color: #ffff00;\">ENTER<\/span><\/strong><\/span><\/span><b>\u00a0<\/b><\/p>\n<p><b>\u092f\u093e,\u00a0<\/b><span class=\"td_btn td_btn_lg td_round_btn\"><span style=\"color: #ffff00;\"><strong>=sum(A1:A20) <\/strong><\/span><span style=\"font-weight: 400;\">press <\/span><span style=\"color: #ffff00;\"><b>ENTER<\/b><\/span><\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u0907\u0938 \u095e\u0949\u0930\u094d\u092e\u0942\u0932\u093e \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0915\u0947 \u0939\u092e\u0928\u0947 A1 cell \u0938\u0947 \u0932\u0947\u0915\u0930 A20 cell \u0924\u0915 \u0915\u0947 \u0928\u0902\u092c\u0930 \u0915\u094b \u091c\u094b\u095c \u0926\u093f\u092f\u093e \u0939\u0948.<\/span><\/p>\n<p><img class=\" wp-image-2008 aligncenter\" src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/range-300x220.png\" alt=\"\" width=\"345\" height=\"253\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/range-300x220.png 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/range.png 527w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/range-80x60.png 80w\" sizes=\"(max-width: 345px) 100vw, 345px\" \/><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><strong>Individual cell<\/strong><\/li>\n<\/ul>\n<p><img class=\" wp-image-2009 aligncenter\" src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/individual-300x186.png\" alt=\"\" width=\"358\" height=\"222\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/individual-300x186.png 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/individual.png 622w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/individual-356x220.png 356w\" sizes=\"(max-width: 358px) 100vw, 358px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">\u0907\u0938\u0915\u0947 \u0905\u0932\u093e\u0935\u093e \u091a\u093f\u0939\u094d\u0928 (symbols) \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0915\u0947 \u092d\u0940 \u0915\u0948\u0932\u0915\u0941\u0932\u0947\u0936\u0928 \u0915\u0940 \u091c\u093e \u0938\u0915\u0924\u0940 \u0939\u0948.<\/span><\/p>\n<p><span class=\"td_btn td_btn_lg td_round_btn\"><span style=\"color: #ffff00;\"><span style=\"font-weight: 400;\"><strong>=Value1<\/strong><span style=\"color: #ff0000;\">symbol<\/span><\/span><\/span><span style=\"font-weight: 400;\"><strong><span style=\"color: #ffff00;\">Value2<\/span><\/strong> press <\/span><span style=\"color: #ffff00;\"><b>ENTER<\/b><\/span><\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u0909\u0926\u093e\u0939\u0930\u0923 \u0915\u0947 \u0932\u093f\u090f: <span class=\"td_btn td_btn_lg td_round_btn\"><span style=\"color: #ffff00;\">=12+34<\/span> press <span style=\"color: #ffff00;\">ENTER<\/span><\/span><\/span><\/p>\n<p><span class=\"td_btn td_btn_lg td_round_btn\"><span style=\"color: #ffff00;\"><span style=\"font-weight: 400;\"><strong>=Value1<\/strong><span style=\"color: #ff0000;\">symbol<\/span><\/span><span style=\"font-weight: 400;\"><strong>(Value2<\/strong><span style=\"color: #ff0000;\">symbol<\/span><\/span><\/span><span style=\"font-weight: 400;\"><strong><span style=\"color: #ffff00;\">Value3)<\/span><\/strong> press <\/span><span style=\"color: #ffff00;\"><b>ENTER<\/b><\/span><\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u0909\u0926\u093e\u0939\u0930\u0923 \u0915\u0947 \u0932\u093f\u090f: =1+(2*6)<\/span> <span style=\"font-weight: 400;\">press <\/span><b>Enter <\/b><\/p>\n<p><img class=\"size-medium wp-image-2011 aligncenter\" src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/symbol-300x222.png\" alt=\"\" width=\"300\" height=\"222\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/symbol-300x222.png 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/symbol.png 522w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/symbol-80x60.png 80w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/symbol-485x360.png 485w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">\u0907\u0928 \u0915\u0948\u0932\u0915\u0941\u0932\u0947\u0936\u0928 \u092e\u0947\u0902 \u0939\u092e\u0947\u0902 \u0938\u092c\u0938\u0947 \u092a\u0939\u0932\u0947 <strong>BODMAS<\/strong> \u0915\u093e \u0915\u0902\u0938\u0947\u092a\u094d\u091f \u0932\u0917\u093e\u0928\u093e \u0939\u094b\u0917\u093e \u091c\u094b \u0939\u092e \u0938\u092c\u0928\u0947 \u0938\u094d\u0915\u0942\u0932 \u092e\u0947\u0902 \u0938\u0940\u0916\u093e \u0925\u093e.<\/span><\/p>\n<p><b>\u0907\u0928\u092e\u0947\u0902 \u0938\u0947 \u0905\u0917\u0930 \u0906\u092a \u090f\u0915 \u092d\u0940 \u092b\u0948\u0915\u094d\u091f\u0930 \u091b\u094b\u095c \u0926\u0947\u0902\u0917\u0947 \u0924\u094b \u0906\u092a\u0915\u094b \u0915\u0948\u0932\u0915\u0941\u0932\u0947\u0936\u0928 \u0915\u093e \u092a\u0930\u093f\u0923\u093e\u092e \u0928\u0939\u0940\u0902 \u092e\u093f\u0932\u0947\u0917\u093e. <\/b><\/p>\n<p><b>\u090f\u0915 \u092c\u093e\u0924 \u0915\u093e \u0959\u093e\u0938 \u0927\u094d\u092f\u093e\u0928 \u0930\u0916\u0947\u0902 \u0915\u093f \u0905\u0917\u0930 \u0906\u092a\u0928\u0947 \u090f\u0915 \u092c\u094d\u0930\u0948\u0915\u0947\u091f \u0915\u094b \u0913\u092a\u0928 \u0915\u093f\u092f\u093e \u0939\u0948 \u0924\u094b \u0909\u0938\u0947 \u0915\u094d\u0932\u094b\u091c \u0915\u0930\u0928\u093e \u092d\u0940 \u0928\u0939\u0940\u0902 \u092d\u0942\u0932\u0928\u093e \u091a\u093e\u0939\u093f\u090f.<\/b><\/p>\n<h4><span style=\"color: #ff0000; background-color: #ffffff;\"><b>\u090f\u092e\u090f\u0938 \u090f\u0915\u094d\u0938\u0947\u0932 \u0915\u0947 \u092b\u0902\u0915\u094d\u0936\u0928\u094b\u0902 \u0915\u0940 \u0938\u0942\u091a\u0940<\/b><\/span><\/h4>\n<h4><strong>1. \u092e\u0948\u0925\u0947\u092e\u0947\u091f\u093f\u0915\u0932 \u092b\u0902\u0915\u094d\u0936\u0928<\/strong><\/h4>\n<ul>\n<li><b>SUM: Cell \u0930\u0947\u0902\u091c \u0915\u093e sum (addition) \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f.<\/b><\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400;\">SUM (CELL RANGE)<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=sum(cell range)<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=sum(A1:A10)<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><img class=\"size-medium wp-image-1945 aligncenter\" src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/sumfinal-300x219.png\" alt=\"\" width=\"300\" height=\"219\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/sumfinal-300x219.png 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/sumfinal-324x235.png 324w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/sumfinal.png 517w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<ul>\n<li><b>SUM: \u0905\u0932\u0917-\u0905\u0932\u0917 cell \u0915\u093e sum (addition) \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f.<\/b><\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400;\">SUM (INDIVIDUAL CELL)<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=Value1+Value2<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=A1+A2<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><img class=\"size-medium wp-image-1946 aligncenter\" src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/sum-300x220.png\" alt=\"\" width=\"300\" height=\"220\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/sum-300x220.png 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/sum-80x60.png 80w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/sum.png 513w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<ul>\n<li><b><span style=\"font-weight: 400;\"><strong>SUMIF:<\/strong>\u00a0<\/span>Cells \u0915\u093e sum \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0932\u0947\u0915\u093f\u0928 \u091c\u093f\u0938\u092e\u0947\u0902 \u090f\u0915 \u0915\u094d\u0930\u093e\u0908\u091f\u0947\u0930\u093f\u092f\u0928 \u0939\u094b.<\/b><\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400;\">SUMIF<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=SUMIF(cell range,\u201dcriterion\u201d)<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=SUMIF(A1:A10,\u201d&gt;8\u201d)<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><img class=\"size-medium wp-image-1947 aligncenter\" src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/sumif-300x144.png\" alt=\"\" width=\"300\" height=\"144\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/sumif-300x144.png 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/sumif-696x335.png 696w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/sumif.png 701w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><b><span style=\"font-weight: 400;\"><strong>SUMIFS:<\/strong>\u00a0<\/span>Cells \u0915\u093e sum \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0932\u0947\u0915\u093f\u0928 \u091c\u093f\u0938\u092e\u0947\u0902 \u090f\u0915 \u0938\u0947 \u091c\u094d\u092f\u093e\u0926\u093e \u0915\u094d\u0930\u093e\u0908\u091f\u0947\u0930\u093f\u092f\u0928 \u0939\u094b.<\/b><\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400;\">SUMIFS<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=SUMIFS(cell range,\u201dcriterion1\u201d,\u201dcriterion2\u201d)<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=SUMIFS(A1:A10,\u201dred\u201d,\u201d&gt;8\u201d)<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><img class=\" wp-image-1948 aligncenter\" src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/sumifs-300x112.png\" alt=\"\" width=\"396\" height=\"148\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/sumifs-300x112.png 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/sumifs-768x286.png 768w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/sumifs-696x259.png 696w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/sumifs.png 815w\" sizes=\"(max-width: 396px) 100vw, 396px\" \/><\/p>\n<p><a href=\"https:\/\/www.contextures.com\/xlFunctions01.html\"><span style=\"font-weight: 400;\"><strong>Sum \u0915\u0947 \u0914\u0930 \u092b\u0902\u0915\u094d\u0936\u0928 \u0915\u0947 \u0932\u093f\u090f \u092f\u0939\u093e\u0901 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947\u0902<\/strong><\/span><\/a><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\"><strong>Subtraction: Cells \u0915\u094b subtract<\/strong>\u00a0<strong>\u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f<\/strong><\/span><strong>.<\/strong><\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400;\">Subtraction<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=Value1-Value2<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=A1-A2<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><img class=\"size-medium wp-image-1950 aligncenter\" src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/sub-300x224.png\" alt=\"\" width=\"300\" height=\"224\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/sub-300x224.png 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/sub-80x60.png 80w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/sub-160x120.png 160w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/sub-265x198.png 265w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/sub-485x360.png 485w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/sub.png 515w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<ul>\n<li><b><span style=\"font-weight: 400;\"><strong>Multiplication:<\/strong>\u00a0<\/span>Cells \u0915\u094b multiply \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f.<\/b><\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400;\">Multiplication<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=Value1*Value2<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=A1*A2<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><img class=\"size-medium wp-image-1951 aligncenter\" src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/multiply-300x224.png\" alt=\"\" width=\"300\" height=\"224\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/multiply-300x224.png 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/multiply-80x60.png 80w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/multiply-160x120.png 160w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/multiply-265x198.png 265w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/multiply-485x360.png 485w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/multiply.png 526w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<ul>\n<li><strong>Divide:\u00a0Cells \u0915\u094b<\/strong><b>\u00a0divide \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f.<\/b><\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400;\">Divide<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=Value1\/Value2<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=A1\/A2<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><img class=\"size-medium wp-image-1952 aligncenter\" src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/divide-300x223.png\" alt=\"\" width=\"300\" height=\"223\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/divide-300x223.png 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/divide-80x60.png 80w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/divide-160x120.png 160w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/divide-265x198.png 265w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/divide-485x360.png 485w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/divide.png 513w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<ul>\n<li><b><span style=\"font-weight: 400;\"><strong>COUNT:<\/strong>\u00a0<\/span>Cells \u0915\u094b \u0915\u093e\u0909\u0902\u091f \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f.<\/b><\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400;\">COUNT<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=COUNT(cell range)<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=COUNT(A1:A30)<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><img class=\"size-medium wp-image-1936 aligncenter\" src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/count-300x206.png\" alt=\"\" width=\"300\" height=\"206\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/count-300x206.png 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/count.png 612w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/count-100x70.png 100w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/count-218x150.png 218w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/count-436x300.png 436w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<ul>\n<li><b><span style=\"font-weight: 400;\"><strong>COUNTIF:<\/strong>\u00a0<\/span>Cells \u0915\u094b \u0915\u093e\u0909\u0902\u091f \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0932\u0947\u0915\u093f\u0928 \u091c\u093f\u0938\u092e\u0947\u0902 \u090f\u0915 \u0915\u094d\u0930\u093e\u0908\u091f\u0947\u0930\u093f\u092f\u0928 \u0939\u094b.<\/b><\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400;\">COUNTIF<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=COUNTIF(cell range,\u201d&gt;criterion\u201d)<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=COUNTIF(A1:A10,\u201d&gt;7\u201d)<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><img class=\"size-medium wp-image-1937 aligncenter\" src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/countif-300x166.png\" alt=\"\" width=\"300\" height=\"166\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/countif-300x166.png 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/countif-696x386.png 696w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/countif.png 704w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<ul>\n<li><b>COUNTIFS:\u00a0Cells \u0915\u094b \u0915\u093e\u0909\u0902\u091f \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0932\u0947\u0915\u093f\u0928 \u090f\u0915 \u091c\u094d\u092f\u093e\u0926\u093e \u0915\u094d\u0930\u093e\u0908\u091f\u0947\u0930\u093f\u092f\u0928 \u0939\u094b.<\/b><\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400;\">COUNTIFS<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=COUNTIFS(cell range,\u201dcriterion1\u201d,\u201d&gt;criterion2\u201d)<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=COUNTIFS(A1:A10,\u201dred\u201d,\u201d&gt;7\u2019)<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><img class=\"size-medium wp-image-1938 aligncenter\" src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/countifs-300x126.png\" alt=\"\" width=\"300\" height=\"126\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/countifs-300x126.png 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/countifs-768x322.png 768w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/countifs-696x292.png 696w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/countifs.png 805w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h5><b><a name=\"stats\"><\/a>2. \u0938\u094d\u091f\u0947\u091f\u093f\u0915\u0932 \u095e\u0949\u0930\u094d\u092e\u0942\u0932\u093e<\/b><\/h5>\n<ul>\n<li><b>AVERAGE:\u00a0Cells \u0915\u093e average \u0915\u0948\u0932\u0915\u0941\u0932\u0947\u091f \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f.<\/b><\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400;\">AVERAGE<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=AVERAGE(cell range)<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=AVERAGE(A1:A30)<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><img class=\"size-medium wp-image-1988 aligncenter\" src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/avearge-300x193.png\" alt=\"\" width=\"300\" height=\"193\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/avearge-300x193.png 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/avearge.png 607w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<ul>\n<li><b>AVERAGEIF:\u00a0Cells \u0915\u093e average \u0915\u0948\u0932\u0915\u0941\u0932\u0947\u091f \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f.<\/b><\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400;\">AVERAGEIF<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=AVERAGEIF(cell range,\u201dcriterion\u201d)<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=AVERAGE(A1:A30,\u201d&lt;&gt;1\u201d)<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><img class=\"size-medium wp-image-1989 aligncenter\" src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/averageif-300x162.png\" alt=\"\" width=\"300\" height=\"162\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/averageif-300x162.png 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/averageif.png 712w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/averageif-696x376.png 696w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<ul>\n<li><b>MEDIAN:\u00a0Cells \u0915\u093e median \u0915\u0948\u0932\u0915\u0941\u0932\u0947\u091f \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f.<\/b><\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400;\">MEDIAN<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=MEDIAN(cell range)<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=MEDIAN(A1:A10)<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><img class=\"size-medium wp-image-1990 aligncenter\" src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/median-300x189.png\" alt=\"\" width=\"300\" height=\"189\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/median-300x189.png 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/median.png 608w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<ul>\n<li><b>MODE:\u00a0Cells \u0915\u093e \u092e\u094b\u0921 \u0915\u0948\u0932\u0915\u0941\u0932\u0947\u091f \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f.<\/b><\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400;\">MODE<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=MODE(cell range)<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=MODE(A1:A10)<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><img class=\"size-medium wp-image-1991 aligncenter\" src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/mode-300x204.png\" alt=\"\" width=\"300\" height=\"204\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/mode-300x204.png 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/mode.png 614w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<ul>\n<li><b><span style=\"font-weight: 400;\"><strong>STANDARD DEVIATION:<\/strong>\u00a0<\/span>Standard deviation \u0915\u0948\u0932\u0915\u0941\u0932\u0947\u091f \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f.<\/b><\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400;\">STANDARD DEVIATION<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=STDEV(cell range)<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=STDEV(A1:A10)<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><img class=\"size-medium wp-image-1992 aligncenter\" src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/stdev-300x205.png\" alt=\"\" width=\"300\" height=\"205\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/stdev-300x205.png 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/stdev-218x150.png 218w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/stdev-436x300.png 436w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/stdev.png 614w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<ul>\n<li><b>MAX:\u00a0Maximum value (\u0938\u092c\u0938\u0947 \u092c\u095c\u0940 \u0935\u0948\u0932\u094d\u092f\u0942) \u0922\u0942\u0902\u0922\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f.<\/b><\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400;\">MAX<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=MAX(cell range)<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=MAX(A1:A10)<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><img class=\"size-medium wp-image-1993 aligncenter\" src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/max-300x241.png\" alt=\"\" width=\"300\" height=\"241\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/max-300x241.png 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/max.png 515w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<ul>\n<li><b>MIN: Minimum value (\u0938\u092c\u0938\u0947 \u091b\u094b\u091f\u0940 \u0935\u0948\u0932\u094d\u092f\u0942) \u0922\u0942\u0902\u0922\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f.<\/b><\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td>MIN<\/td>\n<td>=MIN(cell range)<\/td>\n<td>=MIN(A1:A10)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><img class=\"size-medium wp-image-1994 aligncenter\" src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/min-300x241.png\" alt=\"\" width=\"300\" height=\"241\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/min-300x241.png 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/min.png 519w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p><a href=\"https:\/\/www.excel-easy.com\/examples\/maxifs-minifs.html\"><span style=\"font-weight: 400;\"><strong>\u0938\u092c\u0938\u0947 \u092c\u095c\u0940 \u0914\u0930 \u0938\u092c\u0938\u0947 \u091b\u094b\u091f\u0940 \u0935\u0948\u0932\u094d\u092f\u0942 \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u0935\u093f\u0938\u094d\u0924\u093e\u0930 \u0938\u0947 \u091c\u093e\u0928\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u092f\u0939\u093e\u0901 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947\u0902<\/strong><\/span><\/a><\/p>\n<ul>\n<li><b><span style=\"font-weight: 400;\"><strong>LARGE:<\/strong>\u00a0<\/span>Third\/Fourth, \u0907\u0924\u094d\u092f\u093e\u0926\u093f.. \u0938\u092c\u0938\u0947 \u092c\u095c\u0940 \u0935\u0948\u0932\u094d\u092f\u0942 \u0922\u0942\u0902\u0922\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f.<\/b><\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400;\">LARGE<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=LARGE(cell range,value)<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=LARGE(A1:M1,4)<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><img class=\"size-medium wp-image-1995 aligncenter\" src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/large-300x205.png\" alt=\"\" width=\"300\" height=\"205\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/large-300x205.png 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/large-218x150.png 218w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/large-436x300.png 436w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/large.png 612w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<ul>\n<li><b><span style=\"font-weight: 400;\"><strong>SMALL:<\/strong>\u00a0<\/span>Second smallest value (\u0926\u0942\u0938\u0930\u0940 \u0938\u092c\u0938\u0947 \u091b\u094b\u091f\u0940 \u0935\u0948\u0932\u094d\u092f\u0942) \u0922\u0942\u0902\u0922\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f.<\/b><\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400;\">SMALL<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=SMALL(cell range,value)<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=SMALL(A1:M1,3)<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><img class=\"size-medium wp-image-1996 aligncenter\" src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/small-300x203.png\" alt=\"\" width=\"300\" height=\"203\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/small-300x203.png 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/small.png 614w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><b>RANK: Cells \u0915\u094b \u0930\u0948\u0902\u0915 (order) \u092e\u0947\u0902 \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f.<\/b><\/li>\n<\/ul>\n<p><strong>Descending order<\/strong><\/p>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400;\">RANK<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=RANK(number,ref,[order])<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=RANK(B1,$B$1:$B$9)<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><img class=\"size-medium wp-image-1997 aligncenter\" src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/rank0-300x178.png\" alt=\"\" width=\"300\" height=\"178\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/rank0-300x178.png 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/rank0-696x413.png 696w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/rank0.png 700w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p><strong>Ascending order<\/strong><\/p>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400;\">RANK<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=RANK(value, cell range,1)<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=RANK(B1,$B$1:$B$9,1)<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><img class=\"size-medium wp-image-1998 aligncenter\" src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/rank2-300x179.png\" alt=\"\" width=\"300\" height=\"179\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/rank2-300x179.png 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/rank2-705x420.png 705w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/rank2.png 712w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/rank2-696x414.png 696w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Number : \u0938\u0947\u0932 \u0915\u093e \u0928\u0902\u092c\u0930<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Ref: \u0928\u0902\u092c\u0930 \u0915\u094b \u092a\u0942\u0930\u0940 \u0938\u0942\u091a\u0940 \u0915\u0947 \u0928\u092e\u094d\u092c\u0930\u094b\u0902 \u0938\u0947 \u092e\u093f\u0932\u093e\u0928\u093e \u0939\u094b\u0917\u093e $B$1:$B$9. Cell range \u0915\u094b \u0938\u0932\u0947\u0915\u094d\u091f \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f\u00a0<\/span><b>$B1:$B$9<\/b><span style=\"font-weight: 400;\">\u00a0\u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0947\u0902 \u0924\u093e\u0915\u093f \u0930\u0948\u0902\u091c \u090f\u0915 \u091c\u0948\u0938\u0940 \u0930\u0939\u0947 \u091c\u092c \u0906\u092a \u095e\u0949\u0930\u094d\u092e\u0942\u0932\u093e \u0915\u094b \u0928\u0940\u091a\u0947 \u0915\u0949\u092a\u0940 \u0915\u0930\u0947\u0902\u0917\u0947.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Order: \u0906\u092a\u0915\u094b \u0932\u093f\u0938\u094d\u091f \u0915\u093f\u0938 \u0911\u0930\u094d\u0921\u0930 \u092e\u0947\u0902 \u091a\u093e\u0939\u093f\u090f Ascending ya Descending.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Descending: \u091c\u0940\u0930\u094b \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0915\u0947 \u092f\u093e \u092c\u094d\u0932\u0948\u0902\u0915 \u091b\u094b\u095c \u0926\u0947\u0902. \u0909\u0926\u093e\u0939\u0930\u0923 \u0915\u0947 \u0932\u093f\u090f: ($B$1:$B$9)<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Ascending: \u090f\u0915 (1) \u092f\u093e \u0915\u094b\u0908 \u092d\u0940 \u0928\u0902\u092c\u0930 \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0947\u0902 \u091c\u0940\u0930\u094b \u0915\u0947 \u0905\u0932\u093e\u0935\u093e ($B$1:$B$9,1)<\/span><\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.contextures.com\/excel-functions-rank.html\"><span style=\"font-weight: 400;\"><strong>\u0930\u0948\u0902\u0915 \u092b\u0902\u0915\u094d\u0936\u0928 \u0915\u094b \u0921\u093f\u091f\u0947\u0932 \u092e\u0947\u0902 \u0938\u0940\u0916\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u092f\u0939\u093e\u0901 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947\u0902<\/strong><\/span><\/a><\/p>\n<h4><strong><a name=\"log\"><\/a>3. \u0932\u0949\u091c\u093f\u0915\u0932 \u092b\u0902\u0915\u094d\u0936\u0928<\/strong><\/h4>\n<ul>\n<li><span style=\"font-weight: 400;\"><strong>IF: IF \u092b\u0902\u0915\u094d\u0936\u0928 \u091a\u0947\u0915 \u0915\u0930\u0924\u093e \u0939\u0948 \u0915\u093f \u0915\u0902\u0921\u093f\u0936\u0928 \u092a\u0942\u0930\u0940 \u0939\u0941\u0908 \u0939\u0948 \u092f\u093e \u0928\u0939\u0940\u0902 \u0914\u0930 \u092a\u0930\u093f\u0923\u093e\u092e \u092e\u0947\u0902 \u090f\u0915 \u0935\u0948\u0932\u094d\u092f\u0942 \u2018True\u2019 \u0939\u094b\u0924\u0940 \u0939\u0948 \u0935\u094b \u2018False\u2019.<\/strong><\/span><\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400;\">IF STATEMENT<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=IF(logical test, \u201cresult if the test answer is true\u201d, \u201cresult if the test answer is false\u201d) <\/span><\/td>\n<td><span style=\"font-weight: 400;\">=IF(B2&gt;69,\u201dPass\u201d,\u201dFail\u201d) <\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><img class=\"size-medium wp-image-1999 aligncenter\" src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/if-300x200.png\" alt=\"\" width=\"300\" height=\"200\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/if-300x200.png 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/if-629x420.png 629w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/if.png 645w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<ul>\n<li><strong>EXACT: EXACT \u092b\u0902\u0915\u094d\u0936\u0928 \u0926\u094b \u0935\u0948\u0932\u094d\u092f\u0942 \u0915\u094b \u092e\u093f\u0932\u093e\u0924\u093e \u0939\u0948 \u0914\u0930 \u0905\u0917\u0930 \u0926\u094b\u0928\u094b\u0902 \u0935\u0948\u0932\u094d\u092f\u0942 \u090f\u0915 \u091c\u0948\u0938\u0940 \u0939\u0948 \u0924\u094b \u092a\u0930\u093f\u0923\u093e\u092e \u2018True\u2019 \u0939\u094b\u0924\u093e \u0939\u0948 \u0914\u0930 \u0905\u0917\u0930 \u090f\u0915 \u0935\u0948\u0932\u094d\u092f\u0942 \u0905\u0932\u0917 \u0939\u0948 \u0924\u094b \u092a\u0930\u093f\u0923\u093e\u092e &#8216;False&#8217; \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0917\u093e.<\/strong><\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400;\">EXACT<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=EXACT(Value1, value2) <\/span><\/td>\n<td><span style=\"font-weight: 400;\">=EXACT(B2, C2) <\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><img class=\"size-medium wp-image-2000 aligncenter\" src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/exact-300x148.png\" alt=\"\" width=\"300\" height=\"148\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/exact-300x148.png 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/exact-324x160.png 324w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/exact-533x261.png 533w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/exact.png 623w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\"><strong>AND: \u0905\u0917\u0930 \u0926\u094b\u0928\u094b\u0902 \u0915\u094d\u0930\u093e\u0908\u091f\u0947\u0930\u093f\u092f\u0928 \u092e\u0947\u0932 \u0916\u093e\u0924\u0947 \u0939\u0948 \u0924\u094b \u2018True\u2019 \u092a\u0930\u093f\u0923\u093e\u092e \u0926\u093f\u0916\u0947\u0917\u093e \u0914\u0930 \u0905\u0917\u0930 \u090f\u0915 \u092d\u0940 \u0915\u094d\u0930\u093e\u0908\u091f\u0947\u0930\u093f\u092f\u0928 \u092e\u0947\u0932 \u0928\u0939\u0940\u0902 \u0916\u093e\u0924\u0940 \u0939\u0948 \u0924\u094b \u092a\u0930\u093f\u0923\u093e\u092e \u2018False\u2019 \u0939\u094b\u0924\u093e \u0939\u0948.<\/strong><\/span><\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400;\">AND<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=AND(Value1,criterion, value2,criterion) <\/span><\/td>\n<td><span style=\"font-weight: 400;\">=EXACT(B2&gt;30, C2&gt;35) <\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><img class=\"size-medium wp-image-2001 aligncenter\" src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/and-300x128.png\" alt=\"\" width=\"300\" height=\"128\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/and-300x128.png 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/and.png 617w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p><strong><a href=\"https:\/\/www.excel-easy.com\/functions\/logical-functions.html\">\u0932\u0949\u091c\u093f\u0915\u0932 \u092b\u0902\u0915\u094d\u0936\u0928 \u0915\u0940 \u0938\u0942\u091a\u0940 \u0926\u0947\u0916\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u092f\u0939\u093e\u0901 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947\u0902<\/a><\/strong><\/p>\n<h4><b><a name=\"text\"><\/a>4. \u091f\u0947\u0915\u094d\u0938\u094d\u091f \u092b\u0902\u0915\u094d\u0936\u0928<\/b><\/h4>\n<ul>\n<li><b>J<\/b><strong>OIN STRINGS:<\/strong><b>\u00a0\u0905\u0932\u0917-\u0905\u0932\u0917 cells \u0915\u0947 \u091f\u0947\u0915\u094d\u0938\u094d\u091f \u0915\u094b \u0938\u093e\u0925 \u092e\u0947\u0902 \u091c\u094b\u095c\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f<\/b><\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400;\">JOIN STRINGS<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=value1 &amp; \u201c \u201c &amp; value2<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=A1 &amp; \u201c \u201c &amp; B1<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><img class=\"size-medium wp-image-2002 aligncenter\" src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/join-300x116.png\" alt=\"\" width=\"300\" height=\"116\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/join-300x116.png 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/join.png 624w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<ul>\n<li><strong>LEFT: Cell \u0915\u0947 \u092c\u093e\u092f\u0940\u0902 \u0924\u0930\u092b \u0915\u0947 \u0915\u0948\u0930\u0947\u0915\u094d\u091f\u0930 \u0915\u094b \u0936\u0949\u0930\u094d\u091f \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f<\/strong><\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td><span style=\"font-weight: 400;\">LEFT<\/span><\/td>\n<td><span style=\"font-weight: 400;\">=LEFT(Value1, number of characters) <\/span><\/td>\n<td><span style=\"font-weight: 400;\">=LEFT(B2, 3) <\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><img class=\"size-medium wp-image-2004 aligncenter\" src=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/left-300x172.png\" alt=\"\" width=\"300\" height=\"172\" srcset=\"https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/left-300x172.png 300w, https:\/\/www.joshtalks.com\/joshkosh\/wp-content\/uploads\/2018\/11\/left.png 526w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p><a href=\"https:\/\/www.excel-easy.com\/functions\/text-functions.html\"><b>\u091f\u0947\u0915\u094d\u0938\u094d\u091f \u092b\u0902\u0915\u094d\u0936\u0928 \u0915\u0947 \u0938\u093e\u0930\u0940 \u091c\u093e\u0928\u0915\u093e\u0930\u0940 \u0915\u0947 \u0932\u093f\u090f \u092f\u0939\u093e\u0901 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947\u0902<\/b><\/a><\/p>\n<h5><span style=\"text-decoration: underline;\"><span style=\"color: #ff0000; text-decoration: underline;\"><strong><a style=\"color: #ff0000; text-decoration: underline;\" href=\"https:\/\/www.excel-easy.com\/functions.html\" target=\"_blank\" rel=\"noopener\">\u090f\u0915\u094d\u0938\u0947\u0932 \u0915\u0947 \u0938\u093e\u0930\u0947 \u092b\u0902\u0915\u094d\u0936\u0928 \u0915\u094b \u0905\u091a\u094d\u091b\u0947 \u0938\u0947 \u0938\u0940\u0916\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u092f\u0939\u093e\u0901 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947\u0902<\/a><\/strong><\/span><\/span><\/h5>\n<p>\u090f\u0915\u094d\u0938\u0947\u0932 \u0915\u094b \u0935\u093f\u0938\u094d\u0924\u093e\u0930 \u0938\u0947 \u0938\u0940\u0916\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0906\u092a\u0915\u094b \u0905\u091a\u094d\u091b\u0947 \u0938\u0947 \u0905\u092d\u094d\u092f\u093e\u0938 \u0915\u0930\u0928\u093e \u0939\u094b\u0917\u093e. \u0906\u092a \u0938\u093e\u0930\u0947 \u092b\u0902\u0915\u094d\u0936\u0928 \u0915\u094b \u0909\u0926\u093e\u0939\u0930\u0923 \u0915\u0947 \u0938\u093e\u0925 \u0905\u092d\u094d\u092f\u093e\u0938 \u0915\u0930\u0947\u0902 \u0924\u094b \u091c\u0932\u094d\u0926 \u0939\u0940 \u0938\u0940\u0916 \u091c\u093e\u092f\u0947\u0902\u0917\u0947.<\/p>\n<p><strong><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/hi\/%E0%A4%95%E0%A5%8C%E0%A4%B6%E0%A4%B2-%E0%A4%B5%E0%A4%BF%E0%A4%95%E0%A4%BE%E0%A4%B8\/%E0%A4%91%E0%A4%A8%E0%A4%B2%E0%A4%BE%E0%A4%87%E0%A4%A8-%E0%A4%B8%E0%A5%80%E0%A4%96%E0%A5%87%E0%A4%82-%E0%A4%8F%E0%A4%AE%E0%A4%8F%E0%A4%B8-%E0%A4%8F%E0%A4%95%E0%A5%8D%E0%A4%B8%E0%A5%87%E0%A4%B2\/\" target=\"_blank\" rel=\"noopener\">\u090f\u092e\u090f\u0938 \u090f\u0915\u094d\u0938\u0947\u0932 \u0915\u0947 \u092c\u0947\u0938\u093f\u0915<\/a><\/strong>\u00a0\u0914\u0930 <strong><a href=\"https:\/\/www.joshtalks.com\/joshkosh\/hi\/%E0%A4%95%E0%A5%8C%E0%A4%B6%E0%A4%B2-%E0%A4%B5%E0%A4%BF%E0%A4%95%E0%A4%BE%E0%A4%B8\/%E0%A4%8F%E0%A4%AE%E0%A4%8F%E0%A4%B8-%E0%A4%8F%E0%A4%95%E0%A5%8D%E0%A4%B8%E0%A5%87%E0%A4%B2-%E0%A4%95%E0%A5%87-%E0%A4%B6%E0%A5%89%E0%A4%B0%E0%A5%8D%E0%A4%9F%E0%A4%95%E0%A4%9F\/\">\u0936\u0949\u0930\u094d\u091f\u0915\u091f<\/a><\/strong> \u0915\u0947 \u0932\u093f\u090f \u0907\u0928 \u0926\u093f\u090f \u0917\u090f \u0932\u093f\u0902\u0915\u094b\u0902 \u092a\u0930 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947\u0902 \u0906\u092a\u0915\u094b \u0935\u093f\u0938\u094d\u0924\u093e\u0930 \u092e\u0947\u0902 \u091c\u093e\u0928\u0915\u093e\u0930\u0940 \u092e\u093f\u0932 \u091c\u093e\u092f\u0947\u0917\u0940.<\/p>\n<p>\u0916\u0948\u0930 \u0905\u0917\u0930 \u0906\u092a\u0915\u094b \u0907\u0938 \u0906\u0930\u094d\u091f\u093f\u0915\u0932 \u092e\u0947\u0902 \u0915\u094b\u0908 \u092c\u093e\u0924 \u0938\u092e\u091d \u0928\u0939\u0940\u0902 \u0906\u092f\u0940 \u0939\u0948 \u0924\u094b \u092c\u0947\u091d\u093f\u091d\u0915 \u0939\u092e\u0947\u0902 \u092f\u0939\u093e\u0901 \u0928\u0940\u091a\u0947 \u0915\u092e\u0947\u0902\u091f \u0915\u0940\u091c\u093f\u092f\u0947 \u0914\u0930 \u0907\u0938\u0915\u093e \u0938\u092e\u093e\u0927\u093e\u0928 \u0928\u093f\u0915\u093e\u0932\u0928\u0947 \u0915\u0940 \u092a\u0942\u0930\u0940 \u0915\u094b\u0936\u093f\u0936 \u0915\u0930\u0947\u0902.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hinglish \u092e\u0947\u0902 \u092a\u095d\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u092f\u0939\u093e\u0901 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947\u0902 \u090f\u092e\u090f\u0938 \u090f\u0915\u094d\u0938\u0947\u0932 \u090f\u0915 \u0924\u0930\u0939 \u0915\u093e \u0915\u0948\u0932\u0915\u0941\u0932\u0947\u091f\u0930 \u0939\u094b\u0924\u093e \u0939\u0948. \u090f\u0915\u094d\u0938\u0947\u0932 \u092e\u0947\u0902 \u092c\u0939\u0941\u0924 \u0906\u0938\u093e\u0928\u0940 \u0938\u0947 \u0915\u0948\u0932\u0915\u0941\u0932\u0947\u0936\u0928 \u0915\u0940 \u091c\u093e \u0938\u0915\u0924\u0940 \u0939\u0948. \u091a\u093e\u0939\u0947 \u0915\u093f\u0924\u0928\u093e \u092d\u0940 \u092c\u095c\u093e \u0921\u093e\u091f\u093e \u0939\u094b \u0932\u0947\u0915\u093f\u0928 \u090f\u0915\u094d\u0938\u0947\u0932 \u0915\u0940 \u092e\u0926\u0926 \u0938\u0947 \u0915\u0941\u091b \u0938\u0947\u0915\u0902\u0921 \u092e\u0947\u0902 \u0939\u0940 \u0938\u092c \u0915\u0948\u0932\u0915\u0941\u0932\u0947\u0936\u0928 \u0915\u0940 \u091c\u093e \u0938\u0915\u0924\u0940 \u0939\u0948. \u0907\u0938 \u0906\u0930\u094d\u091f\u093f\u0915\u0932 \u092e\u0947\u0902 \u0915\u094b \u092a\u095d\u0915\u0930 \u0918\u0930 \u092c\u0948\u0920\u0947 \u0939\u0940 [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":2071,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"tdm_status":"","tdm_grid_status":""},"categories":[44,83],"tags":[73],"yst_prominent_words":[],"_links":{"self":[{"href":"https:\/\/www.joshtalks.com\/joshkosh\/hi\/wp-json\/wp\/v2\/posts\/2126"}],"collection":[{"href":"https:\/\/www.joshtalks.com\/joshkosh\/hi\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.joshtalks.com\/joshkosh\/hi\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.joshtalks.com\/joshkosh\/hi\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.joshtalks.com\/joshkosh\/hi\/wp-json\/wp\/v2\/comments?post=2126"}],"version-history":[{"count":9,"href":"https:\/\/www.joshtalks.com\/joshkosh\/hi\/wp-json\/wp\/v2\/posts\/2126\/revisions"}],"predecessor-version":[{"id":2317,"href":"https:\/\/www.joshtalks.com\/joshkosh\/hi\/wp-json\/wp\/v2\/posts\/2126\/revisions\/2317"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.joshtalks.com\/joshkosh\/hi\/wp-json\/wp\/v2\/media\/2071"}],"wp:attachment":[{"href":"https:\/\/www.joshtalks.com\/joshkosh\/hi\/wp-json\/wp\/v2\/media?parent=2126"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.joshtalks.com\/joshkosh\/hi\/wp-json\/wp\/v2\/categories?post=2126"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.joshtalks.com\/joshkosh\/hi\/wp-json\/wp\/v2\/tags?post=2126"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.joshtalks.com\/joshkosh\/hi\/wp-json\/wp\/v2\/yst_prominent_words?post=2126"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}