{"id":103,"date":"2019-02-10T09:25:50","date_gmt":"2019-02-10T07:25:50","guid":{"rendered":"http:\/\/5252.co.il\/?page_id=103"},"modified":"2019-02-10T12:10:49","modified_gmt":"2019-02-10T10:10:49","slug":"%d7%a7%d7%95%d7%a8%d7%a1-%d7%9e%d7%95%d7%9e%d7%97%d7%94-if-%d7%91%d7%90%d7%a7%d7%a1%d7%9c-%d7%9c%d7%a4%d7%95%d7%a0%d7%a7%d7%a6%d7%99%d7%95%d7%aa-%d7%aa%d7%a0%d7%90%d7%99-%d7%a0","status":"publish","type":"page","link":"http:\/\/5252.co.il\/?page_id=103","title":{"rendered":"\u05e7\u05d5\u05e8\u05e1 \u05de\u05d5\u05de\u05d7\u05d4 IF \u05d1\u05d0\u05e7\u05e1\u05dc -\u05dc\u05e4\u05d5\u05e0\u05e7\u05e6\u05d9\u05d5\u05ea \u05ea\u05e0\u05d0\u05d9 (\u05e0)"},"content":{"rendered":"<h1><span style=\"color: #008000;\"><strong>\u05d1\u05e8\u05db\u05d5\u05ea\u05d9 \u05e2\u05dc \u05d4\u05d7\u05dc\u05d8\u05ea\u05da \u05dc\u05d4\u05d9\u05d5\u05ea\u00a0<\/strong>\u05de\u05d5\u05de\u05d7\u05d4 \u05dc\u05e4\u05d5\u05e0\u05e7\u05e6\u05d9\u05d5\u05ea \u05ea\u05e0\u05d0\u05d9 \u05d1\u05d0\u05e7\u05e1\u05dc IF<\/span><\/h1>\n<h3><strong>\u05e7\u05d5\u05d1\u05e5 \u05dc\u05ea\u05e8\u05d2\u05d5\u05dc:\u00a0<\/strong><a title=\"carsales\" href=\"http:\/\/5252.co.il\/files\/ifex.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\">\u00a0ifex.xlsx<\/a><\/h3>\n<h3><a title=\"\u05ea\u05e8\u05d2\u05d9\u05dc\u05d9\u05dd \" href=\"http:\/\/5252.co.il\/files\/ifex.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">\u05ea\u05e8\u05d2\u05d9\u05dc\u05d9\u05dd<\/a><\/h3>\n<h3>\u05e4\u05ea\u05d9\u05d7\u05d4<\/h3>\n<p>&nbsp;<\/p>\n<h3>\u05e4\u05d5\u05e0\u05e7\u05e6\u05d9\u05d9\u05ea \u05ea\u05e0\u05d0\u05d9 IF<\/h3>\n<p>&nbsp;<\/p>\n<h4><span style=\"color: #800080;\">\u05e0\u05d0 \u05dc\u05e2\u05e9\u05d5\u05ea \u05d0\u05ea \u05ea\u05e8\u05d2\u05d9\u05dc 1<\/span><\/h4>\n<h3>IF \u05d1\u05ea\u05d5\u05da IF &#8211; IF \u05de\u05e7\u05d5\u05e0\u05df<\/h3>\n<p>&nbsp;<\/p>\n<h4><span style=\"color: #800080;\">\u05e0\u05d0 \u05dc\u05e2\u05e9\u05d5\u05ea \u05d0\u05ea \u05ea\u05e8\u05d2\u05d9\u05dc 2<\/span><\/h4>\n<h3>IF \u05de\u05d5\u05e8\u05db\u05d1<\/h3>\n<p>&nbsp;<\/p>\n<h4><span style=\"color: #800080;\">\u05e0\u05d0 \u05dc\u05e2\u05e9\u05d5\u05ea \u05d0\u05ea \u05ea\u05e8\u05d2\u05d9\u05dc 3<\/span><\/h4>\n<h3>\u05e2\u05d9\u05e6\u05d5\u05d1 \u05de\u05d5\u05ea\u05e0\u05d4<\/h3>\n<p>&nbsp;<\/p>\n<h4><span style=\"color: #800080;\">\u05e0\u05d0 \u05dc\u05e2\u05e9\u05d5\u05ea \u05d0\u05ea \u05ea\u05e8\u05d2\u05d9\u05dc 4<\/span><\/h4>\n<h3>\u05d4\u05e4\u05d5\u05e0\u05e7\u05e6\u05d9\u05d4 COUNTIF<\/h3>\n<p>&nbsp;<\/p>\n<h4><span style=\"color: #800080;\">\u05e0\u05d0 \u05dc\u05e2\u05e9\u05d5\u05ea \u05d0\u05ea \u05ea\u05e8\u05d2\u05d9\u05dc 5<\/span><\/h4>\n<h3>\u05d9\u05e6\u05d9\u05e8\u05ea \u05e2\u05de\u05d5\u05d3\u05d4 \u05d1\u05d4 \u05e0\u05d9\u05ea\u05df \u05dc\u05d4\u05d6\u05d9\u05df \u05e8\u05e7 \u05ea\u05d5\u05db\u05df \u05d7\u05d3 \u05e2\u05e8\u05db\u05d9<\/h3>\n<p>&nbsp;<\/p>\n<h4><span style=\"color: #800080;\">\u05e0\u05d0 \u05dc\u05e2\u05e9\u05d5\u05ea \u05d0\u05ea \u05ea\u05e8\u05d2\u05d9\u05dc 6<\/span><\/h4>\n<h3>\u05d4\u05e4\u05d5\u05e0\u05e7\u05e6\u05d9\u05d5\u05ea SUMIF AVERAGEIF<\/h3>\n<p>&nbsp;<\/p>\n<h4><span style=\"color: #800080;\">\u05e0\u05d0 \u05dc\u05e2\u05e9\u05d5\u05ea \u05d0\u05ea \u05ea\u05e8\u05d2\u05d9\u05dc 7<\/span><\/h4>\n<h3>\u05d4\u05e4\u05d5\u05e0\u05e7\u05e6\u05d9\u05d4 COUNTIFS<\/h3>\n<p>&nbsp;<\/p>\n<h4><span style=\"color: #800080;\">\u05e0\u05d0 \u05dc\u05e2\u05e9\u05d5\u05ea \u05d0\u05ea \u05ea\u05e8\u05d2\u05d9\u05dc 8<\/span><\/h4>\n<h3>\u05d4\u05e4\u05d5\u05e0\u05e7\u05e6\u05d9\u05d5\u05ea SUMIFS AVERAGEIFS<\/h3>\n<p>&nbsp;<\/p>\n<h4><span style=\"color: #800080;\">\u05e0\u05d0 \u05dc\u05e2\u05e9\u05d5\u05ea \u05d0\u05ea \u05ea\u05e8\u05d2\u05d9\u05dc 9<\/span><\/h4>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u05d1\u05e8\u05db\u05d5\u05ea\u05d9 \u05e2\u05dc \u05d4\u05d7\u05dc\u05d8\u05ea\u05da \u05dc\u05d4\u05d9\u05d5\u05ea\u00a0\u05de\u05d5\u05de\u05d7\u05d4 \u05dc\u05e4\u05d5\u05e0\u05e7\u05e6\u05d9\u05d5\u05ea \u05ea\u05e0\u05d0\u05d9 \u05d1\u05d0\u05e7\u05e1\u05dc IF \u05e7\u05d5\u05d1\u05e5 \u05dc\u05ea\u05e8\u05d2\u05d5\u05dc:\u00a0\u00a0ifex.xlsx \u05ea\u05e8\u05d2\u05d9\u05dc\u05d9\u05dd \u05e4\u05ea\u05d9\u05d7\u05d4 &nbsp; \u05e4\u05d5\u05e0\u05e7\u05e6\u05d9\u05d9\u05ea \u05ea\u05e0\u05d0\u05d9 IF &nbsp; \u05e0\u05d0 \u05dc\u05e2\u05e9\u05d5\u05ea \u05d0\u05ea \u05ea\u05e8\u05d2\u05d9\u05dc 1 IF \u05d1\u05ea\u05d5\u05da IF &#8211; IF \u05de\u05e7\u05d5\u05e0\u05df &nbsp; \u05e0\u05d0 \u05dc\u05e2\u05e9\u05d5\u05ea \u05d0\u05ea \u05ea\u05e8\u05d2\u05d9\u05dc 2 IF \u05de\u05d5\u05e8\u05db\u05d1 &nbsp; \u05e0\u05d0 \u05dc\u05e2\u05e9\u05d5\u05ea \u05d0\u05ea <span class=\"excerpt-dots\">&hellip;<\/span> <a class=\"more-link\" href=\"http:\/\/5252.co.il\/?page_id=103\"><span class=\"more-msg\">\u05d4\u05de\u05e9\u05da \u05e7\u05e8\u05d9\u05d0\u05d4 &larr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-103","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/5252.co.il\/index.php?rest_route=\/wp\/v2\/pages\/103","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/5252.co.il\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/5252.co.il\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/5252.co.il\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/5252.co.il\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=103"}],"version-history":[{"count":2,"href":"http:\/\/5252.co.il\/index.php?rest_route=\/wp\/v2\/pages\/103\/revisions"}],"predecessor-version":[{"id":110,"href":"http:\/\/5252.co.il\/index.php?rest_route=\/wp\/v2\/pages\/103\/revisions\/110"}],"wp:attachment":[{"href":"http:\/\/5252.co.il\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=103"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}