{"id":5177,"date":"2018-10-03T09:02:59","date_gmt":"2018-10-03T07:02:59","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=5177"},"modified":"2022-01-28T16:13:13","modified_gmt":"2022-01-28T15:13:13","slug":"excel-muveletek","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/excel-muveletek\/","title":{"rendered":"Milyen m\u0171veletek vannak az Excelben?"},"content":{"rendered":"

Az Excel m\u0171veletek fajt\u00e1i – ak\u00e1rcsak az ‘\u00e9letben’: matematikai<\/span><\/a>, logikai<\/span><\/a> (azaz \u00f6sszehasonl\u00edt\u00e1sok) \u00e9s sz\u00f6veges m\u0171veletek<\/a><\/span>. Ezeket ak\u00e1r egym\u00e1ssal is vari\u00e1lhatod.<\/p>\n

A m\u0171velet saj\u00e1toss\u00e1ga, hogy mindig minimum 2 elem \u00e9s egy m\u0171veleti jel sz\u00fcks\u00e9ges hozz\u00e1<\/strong>, azaz csak valamit lehet ‘m\u0171veltetetni’ valamivel.<\/p>\n

P\u00e9ld\u00e1ul a szorz\u00e1shoz, mint m\u0171velethez kell a 2 \u00e9rt\u00e9k, amit \u00f6sszeszorzol: 3*2 vagy B2*C2 vagy B2*2.\u00a0<\/p>\n

Persze maga az elem lehet egy megadott \u00e9rt\u00e9k (pl. 3), egy cellahivatkoz\u00e1s (pl. B2), \u00e9s ak\u00e1r f\u00fcggv\u00e9ny is (pl. SZUM(A2:D10) ). Vagy ak\u00e1r egy k\u00e9sz m\u0171velet is, \u00edgy \u00fajabb m\u0171veleti jellel korl\u00e1tlanul halmozhat\u00f3ak a tagok. (V\u00e9g\u00fcl mindig eggyel t\u00f6bb elem lesz, mint m\u0171veleti jel.) Pl: B2 + 100 – C2 * 0,75<\/p>\n

\"\"A 3 elem k\u00f6z\u00fcl b\u00e1rmelyiket elhagyva \u00e9rtelmetlen a m\u0171velet. Vagyis nem megengedett,\u00a0pl ez: 3*, *2,\u00a0*B2, B2C2, vagy m\u00e1s lesz az \u00e9rtelme, pl a fenti p\u00e9lda * jel n\u00e9lk\u00fcl:\u00a032, B22.<\/p>\n

Ez \u00edgy \u00e9rthet\u0151en hangzik, de valahogy a gyakorlatban k\u00f6nny\u0171 elfeljteni, \u00e9s azt\u00e1n nem \u00e9rted, hogy mi\u00e9rt nem lett j\u00f3 a k\u00e9pleted.<\/p>\n

Ha az Excellel akarsz egy m\u0171veletet elv\u00e9geztetni (ezt h\u00edvjuk k\u00e9pletnek), akkor egyenl\u0151s\u00e9gjellel (=) vagy plusz jellel (+) kell kezdened<\/strong>, ebb\u0151l tudja az Excel, hogy nem sz\u00f6veget \u00edrt\u00e1l, hanem elv\u00e9gezve a m\u0171veletet a v\u00e9geredm\u00e9nyt kell ki\u00edrnia.<\/p>\n

Matematikai m\u0171veletek<\/h2>\n

Ez a legh\u00e9tk\u00f6znapibb csoport, m\u00e1r \u00e1ltal\u00e1nos iskol\u00e1ban megtanultuk, \u00e9s mindenki naponta haszn\u00e1lja fejben vagy sz\u00e1mol\u00f3g\u00e9p seg\u00edts\u00e9g\u00e9vel: \u00f6sszead\u00e1s, kivon\u00e1s, oszt\u00e1s, szorz\u00e1s\u00a0(+, -, \/, *).<\/p>\n

\"AA matematikai m\u0171veleteken bel\u00fcl van egy m\u0171veleti sorrend<\/a><\/span>, az oszt\u00e1s-szorz\u00e1s magasabb rend\u0171, azaz el\u0151bb kell kisz\u00e1molni.<\/p>\n

A matematikai m\u0171veletekr\u0151l m\u00e1r \u00edrtam kor\u00e1bban, olvasd el a cikkeket \u00e9s p\u00e9ld\u00e1kat<\/a>.<\/span><\/p>\n

Logikai m\u0171veletek<\/h2>\n

A k\u00f6vetkez\u0151 nagy csoport a logikai m\u0171veletek, melyek seg\u00edts\u00e9g\u00e9vel \u00f6sszehasonl\u00edt\u00e1sokat v\u00e9gezhetsz el.\u00a0Gyakorlatilag ez is als\u00f3s tananyag, biztosan eml\u00e9kszel a ‘kacsacs\u0151r\u00f6kre’. 3 jellel \u00f6sszesen 6 f\u00e9le m\u0171velet v\u00e9gezhet\u0151:<\/span><\/p>\n

\n

\u00a0<\/p>\n<\/colgroup> <\/colgroup> <\/colgroup> <\/colgroup>\n\n\n\n\n\n\n\n\n
\n
\n
\n

\u00d6sszehasonl\u00edt\u00f3 jel<\/p>\n<\/div>\n<\/div>\n<\/td>\n

\n
\n
\n

Jelent\u00e9s<\/p>\n<\/div>\n<\/div>\n<\/td>\n

\n
\n
\n

P\u00e9lda<\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

=<\/p>\n<\/div>\n<\/div>\n<\/td>\n

\n
\n
\n

Egyenl\u0151<\/p>\n<\/div>\n<\/div>\n<\/td>\n

\n
\n
\n

A2=B2 vagy\u00a0C2=\u201dv\u00e1ros\u201d<\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

><\/p>\n<\/div>\n<\/div>\n<\/td>\n

\n
\n
\n

Nagyobb, mint<\/p>\n<\/div>\n<\/div>\n<\/td>\n

\n
\n
\n

A2>100<\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

<<\/p>\n<\/div>\n<\/div>\n<\/td>\n

\n
\n
\n

Kisebb, mint<\/p>\n<\/div>\n<\/div>\n<\/td>\n

\n
\n
\n

A2<B2*C2<\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

>=<\/p>\n<\/div>\n<\/div>\n<\/td>\n

\n
\n
\n

Nagyobb vagy egyenl\u0151<\/p>\n<\/div>\n<\/div>\n<\/td>\n

\n
\n
\n

A2+B2>=100<\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

<=<\/p>\n<\/div>\n<\/div>\n<\/td>\n

\n
\n
\n

Kisebb vagy egyenl\u0151<\/p>\n<\/div>\n<\/div>\n<\/td>\n

\n
\n
\n

A2*B2<=10000<\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

<><\/p>\n<\/div>\n<\/div>\n<\/td>\n

\n
\n
\n

Nem egyenl\u0151<\/p>\n<\/div>\n<\/div>\n<\/td>\n

\n
\n
\n

D2<>”n\u0151”<\/p>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n
\n

A logikai vizsg\u00e1latn\u00e1l (\u00f6sszehasonl\u00edt\u00e1sn\u00e1l) is meg kell mondani, hogy mit mivel hogyan hasonl\u00edtok \u00f6ssze, azaz itt is megvan a m\u0171velet 3 \u00f6sszetev\u0151je.\u00a0(A sz\u00f6vegeket mindig tedd id\u00e9z\u0151jelek k\u00f6z\u00e9.)<\/span><\/p>\n

\"AA logikai m\u0171velet eredm\u00e9nye mindig IGAZ vagy HAMIS logikai \u00e9rt\u00e9k lesz<\/strong>.\u00a0Erre \u00e9p\u00fcl a HA f\u00fcggv\u00e9ny<\/span><\/a>, amelynen le lehet cser\u00e9lni az IGAZ, HAMIS logikai \u00e9rt\u00e9ket m\u00e1s eredm\u00e9nyre, illetve a Felt\u00e9teles form\u00e1z\u00e1s<\/span><\/a>\u00a0is az IGAZ \u00e9rt\u00e9keket sz\u00ednezi be.<\/p>\n

De \u00f6nmag\u00e1ban egy egyszer\u0171 \u00f6sszehasonl\u00edt\u00e1s is informat\u00edv, hiszen tudsz r\u00e1 sz\u0171rni, vagy ez alapj\u00e1n sorba rendezni.<\/p>\n

P\u00e9ld\u00e1ul ellen\u0151rizheted, hogy 2 t\u00e1bl\u00e1zatban megegyezik-e k\u00e9t oszlop tartalma, vagy a t\u00e9ny forgalom meghaladta-e az el\u0151\u00edrt tervet.<\/span><\/p>\n

Sz\u00f6veges m\u0171veletek<\/h2>\n

Az & (\u00e9s-jel) m\u0171veleti jelet kell haszn\u00e1lhatod, ha\u00a0k\u00fcl\u00f6n oszlopban szerepl\u0151 sz\u00f6vegeket akarsz \u00f6sszeoll\u00f3zni, vagy valamivel ki akarod eg\u00e9sz\u00edteni a megl\u00e9v\u0151 sz\u00f6veget.<\/p>\n

\"\"2 dologra \u00e9rdemes odafigyelni: minden tag k\u00f6z\u00e9 kell az & jel (ahogy a cikk elej\u00e9n eml\u00edtettem, hogy mindig meg kell mondani, hogy mit m\u0171veltetsz mivel), itt a legk\u00f6nnyebb elfeledkezni r\u00f3la.<\/p>\n

A sz\u00f6vegeket id\u00e9z\u0151jelek k\u00f6z\u00e9 kell tenni, \u00e9s\u00a0a sz\u00f3k\u00f6z is k\u00fcl\u00f6n karakter!<\/p>\n

R\u00e9szletesebb magyar\u00e1zat\u00e9rt \u00e9s p\u00e9ld\u00e1k\u00e9rt (pl. vezet\u00e9kn\u00e9v, keresztn\u00e9v vagy ir\u00e1ny\u00edt\u00f3sz\u00e1m, v\u00e1ros, utca \u00f6sszef\u0171z\u00e9se) olvasd el a sz\u00f6vegek \u00f6sszef\u0171z\u00e9s\u00e9r\u0151l<\/a><\/span>\u00a0\u00edrt bejegyz\u00e9st.<\/p>\n<\/div>\n<\/div>\n<\/div>\n

\n
\n
\n

M\u0171veleti sorrend<\/h2>\n

A 3 m\u0171veleti csoport viszonya: matematika > sz\u00f6veges > logikai.<\/p>\n

Azaz, ha vegyesen szerepelnek a m\u0171veletek – z\u00e1r\u00f3jel n\u00e9lk\u00fcl – akkor mindig a matematikai sz\u00e1m\u00edt\u00e1sokkal kell kezdeni, \u00e9s legv\u00e9g\u00e9re marad a logikai \u00f6sszehasonl\u00edt\u00e1s. Ezt persze az Excel pontosan tudja – Neked kell ennek megfelel\u0151en gondolkodni, \u00e9s z\u00e1r\u00f3jelezni.<\/p>\n

P\u00e9ld\u00e1ul\u00a0A2+B2>=100 eset\u00e9n\u00a0A2+B2 \u00f6sszeg\u00e9t kell a 100-hoz viszony\u00edtani, mivel a\u00a0matematikai m\u0171velet magasabb rend\u0171, mint a logikai.<\/p>\n

Vagy A2&B2=””, azaz az A2 \u00e9s B2 k\u00fcl\u00f6n-k\u00fcl\u00f6n \u00e9s egy\u00fctt is \u00fcres.<\/p>\n

A logikai \u00e9rt\u00e9kekkel tov\u00e1bbi egyszer\u0171 sz\u00e1m\u00edt\u00e1sok v\u00e9gezhet\u0151ek<\/strong>, ak\u00e1r extra f\u00fcggv\u00e9ny n\u00e9lk\u00fcl is: ugyanis az IGAZ \u00e9rt\u00e9ke 1, a HAMIS \u00e9rt\u00e9ke 0. Ilyenkor a m\u0171veleti sorrend miatt mindig kell a z\u00e1r\u00f3jel!<\/p>\n

P\u00e9ld\u00e1ul 200*(C2>=14) eset\u00e9n a v\u00e9geredm\u00e9ny att\u00f3l f\u00fcgg\u0151en lesz 200 vagy 0, hogy C2 \u00e9rt\u00e9ke el\u00e9ri vagy meghaladja a 14-t. Klasszikus p\u00e9lda erre az idegenforgalmi ad\u00f3: a 14 \u00e9v feletti vend\u00e9gekre 200 Ft\/\u00e9j k\u00f6lts\u00e9g fizetend\u0151, amit a k\u00e9plet m\u00e1r ki is sz\u00e1molt, felt\u00e9ve, hogy a C2 cell\u00e1ban az \u00e9letkor szerepel.<\/p>\n

Vagy 2000*(B2=”igen”) r\u00f6gt\u00f6n sz\u00e1molja a sz\u00e1ll\u00edt\u00e1si k\u00f6lts\u00e9get, ha valaki ig\u00e9nyelte azt.<\/p>\n

Tov\u00e1bbi hasznos Excel tippek<\/h2>\n

Ha szeretn\u00e9l szem\u00e9lyes seg\u00edts\u00e9get az Excelhez, fordulj hozz\u00e1nk bizalommal!<\/a><\/span><\/p>\n

Az 5 leg\u00e1ltal\u00e1nosabb Excel hiba, amit Te is elk\u00f6vetsz \u2013 hacsak nem olvasod el ezt a cikket<\/span><\/a><\/p>\n

30 Excel f\u00fcggv\u00e9ny, amit mindenkinek tudni \u00e9rdemes<\/span><\/a><\/p>\n<\/div>\n<\/div>\n<\/div>\n\n\n","protected":false},"excerpt":{"rendered":"

Az Excel m\u0171veletek fajt\u00e1i – ak\u00e1rcsak az ‘\u00e9letben’: matematikai, logikai (azaz \u00f6sszehasonl\u00edt\u00e1sok) \u00e9s sz\u00f6veges m\u0171veletek. Ezeket ak\u00e1r egym\u00e1ssal is vari\u00e1lhatod. A m\u0171velet saj\u00e1toss\u00e1ga, hogy mindig minimum 2 elem \u00e9s egy m\u0171veleti jel sz\u00fcks\u00e9ges hozz\u00e1, azaz csak valamit lehet ‘m\u0171veltetetni’ valamivel. P\u00e9ld\u00e1ul a szorz\u00e1shoz, mint m\u0171velethez kell a 2 \u00e9rt\u00e9k, amit \u00f6sszeszorzol: 3*2 vagy B2*C2 vagy […]<\/p>\n","protected":false},"author":1,"featured_media":6988,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[76,106,100,35,34],"class_list":["post-5177","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-tippek-gyakori-kerdesek","tag-keplet","tag-logikai","tag-osszefuggesek","tag-szamolas","tag-szovegek"],"yoast_head":"\nMilyen m\u0171veletek vannak az Excelben? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek<\/title>\n<meta name=\"description\" content=\"Az Excelben l\u00e9teznek matematikai, logikai (azaz \u00f6sszehasonl\u00edt\u00e1sok) \u00e9s sz\u00f6veges m\u0171veletek. Ezeket ak\u00e1r egym\u00e1ssal is vari\u00e1lhatod.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sosexcel.com\/exceltippek\/excel-muveletek\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Milyen m\u0171veletek vannak az Excelben? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"Az Excelben l\u00e9teznek matematikai, logikai (azaz \u00f6sszehasonl\u00edt\u00e1sok) \u00e9s sz\u00f6veges m\u0171veletek. Ezeket ak\u00e1r egym\u00e1ssal is vari\u00e1lhatod.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/excel-muveletek\/\" \/>\n<meta property=\"og:site_name\" content=\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/bernadett.koros\" \/>\n<meta property=\"article:published_time\" content=\"2018-10-03T07:02:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-01-28T15:13:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/10\/igaz-hamis-logikai-vizsgalat.png\" \/>\n\t<meta property=\"og:image:width\" content=\"940\" \/>\n\t<meta property=\"og:image:height\" content=\"788\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Bernadett\" \/>\n<meta name=\"twitter:label1\" content=\"Szerz\u0151:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bernadett\" \/>\n\t<meta name=\"twitter:label2\" content=\"Becs\u00fclt olvas\u00e1si id\u0151\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-muveletek\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-muveletek\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"Milyen m\u0171veletek vannak az Excelben?\",\"datePublished\":\"2018-10-03T07:02:59+00:00\",\"dateModified\":\"2022-01-28T15:13:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-muveletek\/\"},\"wordCount\":988,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#organization\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-muveletek\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/10\/excel-muveletek.jpg\",\"keywords\":[\"k\u00e9plet\",\"logikai\",\"\u00f6sszef\u00fcgg\u00e9sek\",\"sz\u00e1mol\u00e1s\",\"sz\u00f6vegek\"],\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/sosexcel.com\/exceltippek\/excel-muveletek\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-muveletek\/\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/excel-muveletek\/\",\"name\":\"Milyen m\u0171veletek vannak az Excelben? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-muveletek\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-muveletek\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/10\/excel-muveletek.jpg\",\"datePublished\":\"2018-10-03T07:02:59+00:00\",\"dateModified\":\"2022-01-28T15:13:13+00:00\",\"description\":\"Az Excelben l\u00e9teznek matematikai, logikai (azaz \u00f6sszehasonl\u00edt\u00e1sok) \u00e9s sz\u00f6veges m\u0171veletek. Ezeket ak\u00e1r egym\u00e1ssal is vari\u00e1lhatod.\",\"breadcrumb\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-muveletek\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/sosexcel.com\/exceltippek\/excel-muveletek\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-muveletek\/#primaryimage\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/10\/excel-muveletek.jpg\",\"contentUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/10\/excel-muveletek.jpg\",\"width\":1400,\"height\":425},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/excel-muveletek\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/sosexcel.com\/exceltippek\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Milyen m\u0171veletek vannak az Excelben?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#website\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/\",\"name\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"description\":\"ha S.O.S. seg\u00edts\u00e9gre van sz\u00fcks\u00e9ged!\",\"publisher\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/sosexcel.com\/exceltippek\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"hu\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#organization\",\"name\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png\",\"contentUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png\",\"width\":600,\"height\":133,\"caption\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b\",\"name\":\"Bernadett\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"caption\":\"Bernadett\"},\"description\":\"Bernadett 10 \u00e9vig dolgozott a versenyszf\u00e9r\u00e1ban, majd az ott szerzett tapasztalatok alapj\u00e1n \u00e1ll\u00edtotta \u00f6ssze az ExcelTitok k\u00e9pz\u00e9si m\u00f3dszert. 2010 szeptembere \u00f3ta csak Excel oktat\u00e1ssal foglalkozik. Oktat\u00f3i csapat\u00e1val m\u00e1ra m\u00e1r t\u00f6bb mint 2000 emberrel foglalkoztak szem\u00e9lyesen, egy\u00e9ni oktat\u00e1s keret\u00e9ben. C\u00e9lja, hogy \u00edr\u00e1sainak \u00e9s munk\u00e1j\u00e1nak k\u00f6sz\u00f6nhet\u0151en min\u00e9l t\u00f6bben megbar\u00e1tkozzanak az Excellel.\",\"sameAs\":[\"http:\/\/exceltitok.hu\/\",\"https:\/\/www.facebook.com\/bernadett.koros\"],\"url\":\"https:\/\/sosexcel.com\/exceltippek\/author\/sos-excel\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Milyen m\u0171veletek vannak az Excelben? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"Az Excelben l\u00e9teznek matematikai, logikai (azaz \u00f6sszehasonl\u00edt\u00e1sok) \u00e9s sz\u00f6veges m\u0171veletek. Ezeket ak\u00e1r egym\u00e1ssal is vari\u00e1lhatod.","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:\/\/sosexcel.com\/exceltippek\/excel-muveletek\/","og_locale":"hu_HU","og_type":"article","og_title":"Milyen m\u0171veletek vannak az Excelben? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"Az Excelben l\u00e9teznek matematikai, logikai (azaz \u00f6sszehasonl\u00edt\u00e1sok) \u00e9s sz\u00f6veges m\u0171veletek. Ezeket ak\u00e1r egym\u00e1ssal is vari\u00e1lhatod.","og_url":"https:\/\/sosexcel.com\/exceltippek\/excel-muveletek\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2018-10-03T07:02:59+00:00","article_modified_time":"2022-01-28T15:13:13+00:00","og_image":[{"width":940,"height":788,"url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/10\/igaz-hamis-logikai-vizsgalat.png","type":"image\/png"}],"author":"Bernadett","twitter_misc":{"Szerz\u0151:":"Bernadett","Becs\u00fclt olvas\u00e1si id\u0151":"5 perc"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sosexcel.com\/exceltippek\/excel-muveletek\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/excel-muveletek\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"Milyen m\u0171veletek vannak az Excelben?","datePublished":"2018-10-03T07:02:59+00:00","dateModified":"2022-01-28T15:13:13+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/excel-muveletek\/"},"wordCount":988,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/excel-muveletek\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/10\/excel-muveletek.jpg","keywords":["k\u00e9plet","logikai","\u00f6sszef\u00fcgg\u00e9sek","sz\u00e1mol\u00e1s","sz\u00f6vegek"],"articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/excel-muveletek\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/excel-muveletek\/","url":"https:\/\/sosexcel.com\/exceltippek\/excel-muveletek\/","name":"Milyen m\u0171veletek vannak az Excelben? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/excel-muveletek\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/excel-muveletek\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/10\/excel-muveletek.jpg","datePublished":"2018-10-03T07:02:59+00:00","dateModified":"2022-01-28T15:13:13+00:00","description":"Az Excelben l\u00e9teznek matematikai, logikai (azaz \u00f6sszehasonl\u00edt\u00e1sok) \u00e9s sz\u00f6veges m\u0171veletek. Ezeket ak\u00e1r egym\u00e1ssal is vari\u00e1lhatod.","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/excel-muveletek\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/excel-muveletek\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/excel-muveletek\/#primaryimage","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/10\/excel-muveletek.jpg","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/10\/excel-muveletek.jpg","width":1400,"height":425},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/excel-muveletek\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"Milyen m\u0171veletek vannak az Excelben?"}]},{"@type":"WebSite","@id":"https:\/\/sosexcel.com\/exceltippek\/#website","url":"https:\/\/sosexcel.com\/exceltippek\/","name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"ha S.O.S. seg\u00edts\u00e9gre van sz\u00fcks\u00e9ged!","publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sosexcel.com\/exceltippek\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"hu"},{"@type":"Organization","@id":"https:\/\/sosexcel.com\/exceltippek\/#organization","name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","url":"https:\/\/sosexcel.com\/exceltippek\/","logo":{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png","width":600,"height":133,"caption":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b","name":"Bernadett","image":{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","caption":"Bernadett"},"description":"Bernadett 10 \u00e9vig dolgozott a versenyszf\u00e9r\u00e1ban, majd az ott szerzett tapasztalatok alapj\u00e1n \u00e1ll\u00edtotta \u00f6ssze az ExcelTitok k\u00e9pz\u00e9si m\u00f3dszert. 2010 szeptembere \u00f3ta csak Excel oktat\u00e1ssal foglalkozik. Oktat\u00f3i csapat\u00e1val m\u00e1ra m\u00e1r t\u00f6bb mint 2000 emberrel foglalkoztak szem\u00e9lyesen, egy\u00e9ni oktat\u00e1s keret\u00e9ben. C\u00e9lja, hogy \u00edr\u00e1sainak \u00e9s munk\u00e1j\u00e1nak k\u00f6sz\u00f6nhet\u0151en min\u00e9l t\u00f6bben megbar\u00e1tkozzanak az Excellel.","sameAs":["http:\/\/exceltitok.hu\/","https:\/\/www.facebook.com\/bernadett.koros"],"url":"https:\/\/sosexcel.com\/exceltippek\/author\/sos-excel\/"}]}},"_links":{"self":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/5177","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/comments?post=5177"}],"version-history":[{"count":20,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/5177\/revisions"}],"predecessor-version":[{"id":9409,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/5177\/revisions\/9409"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media\/6988"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=5177"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=5177"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=5177"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}