{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Readme","HVIS","BooleskAlgebra","HVIS+","Opgaver","Procentregning","Lommeregner","ABC_analyse"],"not_rendered":{"charts":6,"images":12,"macros":1,"external_links":0,"defined_names":8,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Readme","index":0,"n_rows":38,"n_cols":3,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Excel kursus"]
[]
[null,"Her er så nummer to fil af de filer jeg for mange år siden brugte til Excel-under-"]
[null,"visning af primært kollegaer. "]
[]
[null,"Filen hedder Logiske_Funktioner og omhandler primært funktionerne der hedder:"]
[]
[null,"Dansk","Engelsk"]
[null,"HVIS","IF"]
[null,"ELLER","OR"]
[null,"OG","AND"]
[null,"IKKE","NOT"]
[]
[null,"herunder en del om den disciplin der hedder Boolesk Algebra. Enkelte steder er "]
[null,"der dog også gjort brug af andre funktioner blandt andet HELTAL/INT og REST/MOD."]
[null,"Filen indeholder også en del eksempler på betinget formatering, men i øvrigt,"]
[null,"meget mere herom i næste fil."]
[null,"Hvis du ikke umiddelbart kender en given funktion, så studer Excels hjælp til"]
[null,"funktionen."]
[]
[null,"I arket Opgaver er der en række eksempler på brug af de logiske funktioner. Her, "]
[null,"som i flere af de andre ark, er der lagt op til, at du selv forsøger dig, men samtidig "]
[null,"har jeg givet mulighed for at få hjælp, hvis du sætter et x i relevant celle."]
[]
[null,"Arkene Procentregning og Lommeregner er mest for sjov. De har næppe den store"]
[null,"praktiske relevans."]
[]
[null,"Arket ABC_analyse indeholder et formentligt nogenlunde praktisk relevant eksempel"]
[null,"på, hvad man kan anvende Excel til inden for virksomhedsøkonomi."]
[]
[null,"Hvis der er fejl i materialet eller hvis du i øvrigt har kommentarer eller spørgsmål til"]
[null,"filen er du meget velkommen til at skrive. Min mailadresse er:"]
[null,"hans.knudsen@mail.tele.dk"]
[null,"Enhver reaktion er velkommen. Slet ingen reaktion er fra mit ståsted noget af det"]
[null,"mest demotiverende. Hvis der er helt andre Excel-ting du hellere vil se/høre/lære"]
[null,"noget om, så sig frem."]

{"sheet":"HVIS","index":1,"n_rows":161,"n_cols":12,"rows_kept":161,"cut":false,"hidden":false,"merged":[[89,1,89,8]]}
[]
[null,"HVIS"]
[]
[null,"Funktionen HVIS returnerer én værdi hvis en betingelse du specificerer er opfyldt (= SAND) "]
[null,"og en anden værdi, hvis betingelsen ikke er opfyldt (= FALSK)."]
[]
[null,"Syntaks"]
[null,"HVIS(Logisk_test; Værdi_hvis_sand; Værdi_hvis_falsk)"]
[]
[null,"HVIS funktionen har tre argumenter. Et argument er det der i parentesen adskilles af semi-"]
[null,"kolon. Første argument er en logisk test, det vil sige et udsagn som enten kan være opfyldt "]
[null,"eller ikke opfyldt – SAND eller FALSK. Det andet argument er den værdi som HVIS funktionen "]
[null,"returnerer, hvis den logiske test er SAND. Det tredie argument er den værdi HVIS funktionen"]
[null,"returnerer, hvis den logiske test er FALSK."]
[]
[]
[null,"Eksempel 1"]
[]
[null,null,{"$f":"CHAR(COLUMN()+64)","v":"C"},{"$f":"CHAR(COLUMN()+64)","v":"D"},{"$f":"CHAR(COLUMN()+64)","v":"E"}]
[null,null,null,null,"Er tallet i"]
[null,null,null,null,"kolonne D"]
[null,null,"Første","Andet","> end tallet"]
[null,null,"tal","tal","i kolonne E"]
[null,{"$f":"ROW()","v":24},32,32,null,null,{"$f":"\"Lav en formel (logisk test) i \"&mycell(E24)&\" der retur-\"","v":"Lav en formel (logisk test) i E24 der retur-"},null,null,null,null,{"$f":"C24>D24","v":false}]
[null,{"$f":"ROW()","v":25},90,15,null,null,{"$f":"\"nerer SAND hvis tallet i \"&mycell(C24)&\" er større\"","v":"nerer SAND hvis tallet i C24 er større"},null,null,null,null,{"$f":"C25>D25","v":true}]
[null,{"$f":"ROW()","v":26},25,84,null,null,{"$f":"\"end (>) tallet i \"&mycell(D24)&\" og ellers returnerer .\"","v":"end (>) tallet i D24 og ellers returnerer ."},null,null,null,null,false]
[null,{"$f":"ROW()","v":27},20,52,null,null,"FALSK.",null,null,null,null,false]
[null,{"$f":"ROW()","v":28},1,38,null,null,{"$f":"\"Med celle \"&ADDRESS(ROW(E24),COLUMN(E24),4)&\" aktiveret, dobbeltklik på det\"","v":"Med celle E24 aktiveret, dobbeltklik på det"},null,null,null,null,false]
[null,{"$f":"ROW()","v":29},18,4,null,null,"lille kvadrat i nederste højre hjørne af cellen",null,null,null,null,true]
[null,{"$f":"ROW()","v":30},81,79,null,null,"for at kopiere formlen nedad.",null,null,null,null,true]
[]
[]
[null,"Sæt x hvis du ønsker hjælp"]
[]
[]
[]
[]
[null,"Eksempel 2"]
[]
[null,null,{"$f":"CHAR(COLUMN()+64)","v":"C"},{"$f":"CHAR(COLUMN()+64)","v":"D"},{"$f":"CHAR(COLUMN()+64)","v":"E"}]
[null,null,null,null,"Er tallet i"]
[null,null,null,null,"kolonne D"]
[null,null,"Første","Andet","> end tallet"]
[null,null,"tal","tal","i kolonne E"]
[null,{"$f":"ROW()","v":45},26,43,null,null,{"$f":"\"Lav en HVIS formel i celle \"&ADDRESS(ROW(E45),COLUMN(E45),4)&\" der returner\"","v":"Lav en HVIS formel i celle E45 der returner"},null,null,null,null,{"$f":"IF(C45>D45,\"JA\",\"NEJ\")","v":"NEJ"}]
[null,{"$f":"ROW()","v":46},63,31,null,null,{"$f":"\"\"\"JA\"\" hvis tallet i \"&mycell(C45)&\" er større end\"","v":"\"JA\" hvis tallet i C45 er større end"},null,null,null,null,{"$f":"IF(C46>D46,\"JA\",\"NEJ\")","v":"JA"}]
[null,{"$f":"ROW()","v":47},90,41,null,null,{"$f":"\"tallet i \"&mycell(D45)&\" og ellers returnerer \"\"NEJ\"\".\"","v":"tallet i D45 og ellers returnerer \"NEJ\"."},null,null,null,null,"JA"]
[null,{"$f":"ROW()","v":48},5,19,null,null,{"$f":"\"Med celle \"&ADDRESS(ROW(E45),COLUMN(E45),4)&\" aktiveret, dobbeltklik det\"","v":"Med celle E45 aktiveret, dobbeltklik det"},null,null,null,null,"NEJ"]
[null,{"$f":"ROW()","v":49},68,3,null,null,"lille kvadrat i nederste højre hjørne af",null,null,null,null,"JA"]
[null,{"$f":"ROW()","v":50},85,59,null,null,"cellen for at kopiere formlen ned til ",null,null,null,null,"JA"]
[null,{"$f":"ROW()","v":51},7,12,null,null,{"$f":"\"og med celle \"&mycell(E53)&\".\"","v":"og med celle E53."},null,null,null,null,"NEJ"]
[]
[]
[null,"Sæt x hvis du ønsker hjælp"]
[]
[]
[]
[null,"I stedet for JA og NEJ er der en række andre muligheder. Prøv (nedenfor) at indtaste følgende:"]
[]
[null,{"$f":"\"I celle \"&mycell(E73)&\":\"","v":"I celle E73:"},null,{"$f":"\"=HVIS(\"&mycell(C73)&\" > \"&mycell(D73)&\"; 1; 2)\"","v":"=HVIS(C73 > D73; 1; 2)"}]
[]
[null,{"$f":"\"I celle \"&mycell(E74)&\":\"","v":"I celle E74:"},null,{"$f":"\"=HVIS(\"&mycell(C74)&\" > \"&mycell(D74)&\"; \"\"JA\"\"; \"\"\"\")\"","v":"=HVIS(C74 > D74; \"JA\"; \"\")"}]
[]
[null,{"$f":"\"I celle \"&mycell(E75)&\":\"","v":"I celle E75:"},null,{"$f":"\"=HVIS(\"&mycell(C75)&\" < \"&mycell(D75)&\"; \"\"Ring til 3420\"\"; \"\"Lønforhøjelse til den herre\"\")\"","v":"=HVIS(C75 < D75; \"Ring til 3420\"; \"Lønforhøjelse til den herre\")"}]
[]
[null,{"$f":"\"I celle \"&mycell(E76)&\":\"","v":"I celle E76:"},null,{"$f":"\"=HVIS(\"&mycell(C76)&\" > \"&mycell(D76)&\"; \"\"Kontakt sælger nn\"\"; \"&mycell(D76)&\"*10%)\"","v":"=HVIS(C76 > D76; \"Kontakt sælger nn\"; D76*10%)"}]
[]
[]
[]
[null,null,{"$f":"CHAR(COLUMN()+64)","v":"C"},"D","E"]
[null,null,"Første","Andet"]
[null,null,"tal","tal"]
[null,{"$f":"ROW()","v":73},3,5,null,null,null,{"$f":"IF(C73>D73,1,2)","v":2}]
[null,{"$f":"ROW()","v":74},11,7,null,null,null,{"$f":"IF(C74>D74,\"JA\",\"\")","v":"JA"}]
[null,{"$f":"ROW()","v":75},1213548,1000000,null,null,null,{"$f":"IF(C75<D75,\"Ring til 3420\",\"Lønforhøjelse til den herre\")","v":"Lønforhøjelse til den herre"}]
[null,{"$f":"ROW()","v":76},26489,23698,null,null,null,{"$f":"IF(C76>D76,\"Kontakt sælger nn\",D76*10%)","v":"Kontakt sælger nn"}]
[]
[]
[null,"Sæt x hvis du ønsker hjælp"]
[]
[]
[]
[]
[null,"Eksempel 3"]
[]
[null,"Færdiggør salgsnotaen herunder ved at indsætte relevante formler i de gule celler. Brug en "]
[null,"HVIS funktion til at beregne eventuel rabat. Moms beregnes som 25% af samlet pris minus "]
[null,"rabat."]
[]
[null,"Salgsnota Tæppelageret ApS – tæpper efter mål",null,null,null,null,null,null,null,null,"Hjælpe-"]
[null,null,null,null,null,null,{"$f":"\"Der ydes \"&TEXT(K92,\"0%\")&\" rabat ved køb over:\"","v":"Der ydes 15% rabat ved køb over:"},{"$f":"K93","v":9500},null,null,"celler"]
[null,null,null,null,"Dimension i meter",null,"Areal","Pris","Samlet",null,0.15]
[null,"Betegnelse",null,null,"Bredde","Længde","i m2","pr. m2","pris",null,9500]
[null,"Dørmåtte lille",null,null,0.6,1.2,{"$f":"E94*F94","v":0.72},45.45,{"$f":"G94*H94","v":32.724000000000004}]
[null,"Dørmåtte stor",null,null,1.3,1.8,{"$f":"E95*F95","v":2.3400000000000003},70,{"$f":"G95*H95","v":163.80000000000001},null,{"$f":"\"Se formlen i celle \"&mycell(G91)&\".\"","v":"Se formlen i celle G91."}]
[null,"Løber lille",null,null,0.8,2,1.6,68.5,109.60000000000001]
[null,"Løber stor",null,null,1.4,4,5.6,65,364]
[null,"Lille tæppe",null,null,3.5,4.5,15.75,75,1181.25]
[null,"Stort tæppe",null,null,5.7,6.5,37.050000000000004,85,3149.2500000000005]
[null,"Aflangt tæppe",null,null,3.5,4,14,68.5,959]
[null,"Lille kvadr. tæppe",null,null,4,4,16,85,1360]
[null,"Stort kvadr. tæppe",null,null,6.6,6.5,42.9,85,3646.5]
[null,null,null,null,null,null,null,null,null,null,"Alternativt"]
[null,null,null,null,null,null,null,"Samlet pris   ",{"$f":"SUM(I94:I102)","v":10966.124},null,{"$f":"SUM(I94:I102)","v":10966.124}]
[null,null,null,null,"Hvis funktion her",null,null,"Rabat   ",{"$f":"IF(I104>H91,K92*I104,0)","v":1644.9186},null,{"$f":"-IF(I104>H91,K92*I104,0)","v":-1644.9186}]
[null,null,null,null,null,null,null,"Moms   ",{"$f":"(I104-I105)*25%","v":2330.3013499999997},null,{"$f":"25%*(K104+K105)","v":2330.3013499999997}]
[null,null,null,null,null,null,null,"Pris i alt   ",{"$f":"I104-I105+I106","v":11651.506749999999},null,{"$f":"SUM(K104:K106)","v":11651.506749999999}]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"_xlfn.FORMULATEXT(I107)","v":"=I104-I105+I106"},null,{"$f":"_xlfn.FORMULATEXT(K107)","v":"=SUM(K104:K106)"}]
[]
[]
[]
[null,"Eksempel 4"]
[]
[null,null,{"$f":"CHAR(COLUMN()+64)","v":"C"},{"$f":"CHAR(COLUMN()+64)","v":"D"},{"$f":"CHAR(COLUMN()+64)","v":"E"}]
[]
[null,{"$f":"ROW()","v":118},null,100,null,"Kritisk lagerniveau"]
[]
[]
[null,{"$f":"ROW()","v":121},"Nr.","Antal","Besked"]
[null,{"$f":"ROW()","v":122},"136A",96,null,{"$f":"\"Aktiver celle \"&mycell(E122)&\" og lav en HVIS-funktion der skriver\"","v":"Aktiver celle E122 og lav en HVIS-funktion der skriver"},null,null,null,null,null,{"$f":"IF(D118>$D$122,\"OK\",\"Bestil\")","v":"OK"}]
[null,{"$f":"ROW()","v":123},"584B",80,null,"en meddelelse afhængig af lagerniveauet for hver ",null,null,null,null,null,{"$f":"IF(D119>$D$122,\"OK\",\"Bestil\")","v":"Bestil"}]
[null,{"$f":"ROW()","v":124},"239C",117,null,"enkelt varenummer.",null,null,null,null,null,"Bestil"]
[null,{"$f":"ROW()","v":125},"499D",118,null,null,null,null,null,null,null,"OK"]
[null,{"$f":"ROW()","v":126},"137E",95,null,{"$f":"\"Hvis antallet i celle \"&mycell(D122)&\" er større end eller lig med det \"","v":"Hvis antallet i celle D122 er større end eller lig med det "},null,null,null,null,null,"Bestil"]
[null,{"$f":"ROW()","v":127},"187P",100,null,{"$f":"\"kritiske lagerniveau (= antallet i \"&ADDRESS(ROW(D118),COLUMN(D118),4)&\") skal HVIS funktionen\"","v":"kritiske lagerniveau (= antallet i D118) skal HVIS funktionen"},null,null,null,null,null,"Bestil"]
[null,{"$f":"ROW()","v":128},"341S",84,null,"returnere “OK”. I modsat fald skal den returnere",null,null,null,null,null,"OK"]
[null,{"$f":"ROW()","v":129},"187R",105,null,"“Bestil”.",null,null,null,null,null,"OK"]
[null,{"$f":"ROW()","v":130},"234F",99,null,null,null,null,null,null,null,"Bestil"]
[null,{"$f":"ROW()","v":131},"546N",109,null,null,null,null,null,null,null,"OK"]
[null,{"$f":"ROW()","v":132},"473P",117,null,null,null,null,null,null,null,"Bestil"]
[]
[]
[null,"Sæt x hvis du ønsker hjælp"]
[]
[]
[]
[null,"Eksempel 5"]
[]
[null,null,{"$f":"CHAR(COLUMN()+64)","v":"C"},{"$f":"CHAR(COLUMN()+64)","v":"D"},{"$f":"CHAR(COLUMN()+64)","v":"E"}]
[]
[null,{"$f":"ROW()","v":143},null,100,null,"Kritisk lagerniveau"]
[]
[]
[null,{"$f":"ROW()","v":146},"Nr.","Antal","Besked"]
[null,{"$f":"ROW()","v":147},"136A",99,null,"Her skal du gentage løsningen fra det foregående",null,null,null,null,null,{"$f":"IF(D147>$D$143*2,\"Alarm\",IF(D147>$D$143,\"OK\",\"Bestil\"))","v":"Bestil"}]
[null,{"$f":"ROW()","v":148},"584B",86,null,"eksempel, men med den tilføjelse, at hvis antal på lager ",null,null,null,null,null,{"$f":"IF(D148>$D$143*2,\"Alarm\",IF(D148>$D$143,\"OK\",\"Bestil\"))","v":"Bestil"}]
[null,{"$f":"ROW()","v":149},"239C",117,null,"overstiger det kritiske lagerniveau med mere end 100%",null,null,null,null,null,"OK"]
[null,{"$f":"ROW()","v":150},"499D",92,null,"så skal HVIS funktionen returnere teksten \"Alarm\" og",null,null,null,null,null,"Bestil"]
[null,{"$f":"ROW()","v":151},"137E",110,null,"teksten skal være rød.",null,null,null,null,null,"OK"]
[null,{"$f":"ROW()","v":152},"187P",300,null,"Det skal altså stadigvæk være sådan, at hvis antallet er",null,null,null,null,null,"Alarm"]
[null,{"$f":"ROW()","v":153},"341S",115,null,"mindre end det kritiske niveau, skal HVIS-funktionen ",null,null,null,null,null,"OK"]
[null,{"$f":"ROW()","v":154},"187R",83,null,"returnere teksten \"Bestil\", hvis antallet på lager er lig",null,null,null,null,null,"Bestil"]
[null,{"$f":"ROW()","v":155},"234F",220.00000000000003,null,"med eller større ned det kritiske niveau, men dog mindre",null,null,null,null,null,"Alarm"]
[null,{"$f":"ROW()","v":156},"546N",87,null,"end det kritiske niveau plus 100 procent, så skal HVIS-",null,null,null,null,null,"Bestil"]
[null,{"$f":"ROW()","v":157},"473P",88,null,"funktionen returnere meddelelsen \"OK\".",null,null,null,null,null,"Bestil"]
[null,{"$f":"ROW()","v":158},"473P",118,null,null,null,null,null,null,null,"OK"]
[]
[]
[null,"Sæt x hvis du ønsker hjælp"]

{"sheet":"BooleskAlgebra","index":2,"n_rows":375,"n_cols":32,"rows_kept":375,"cut":false,"hidden":false,"merged":[[325,3,327,5],[325,6,327,6],[323,3,324,5],[323,6,324,6],[223,2,223,3],[223,4,223,5],[223,6,223,7],[269,2,269,3],[270,2,270,3],[271,2,271,3],[320,3,321,5],[320,6,321,6],[225,2,225,3],[226,2,226,3],[227,2,227,3],[228,2,228,3],[223,8,223,9],[267,2,267,3],[268,2,268,3],[221,2,221,3],[221,4,221,5],[221,6,221,7],[221,8,221,9],[222,2,222,3],[222,4,222,5],[222,6,222,7],[222,8,222,9],[244,2,244,3],[245,2,245,3],[244,4,244,5],[245,4,245,5],[219,2,219,3],[219,4,219,5],[219,6,219,7],[219,8,219,9],[220,2,220,3],[220,4,220,5],[220,6,220,7],[220,8,220,9],[183,2,183,3],[183,4,183,5],[183,6,183,7],[183,8,183,9],[218,2,218,3],[218,4,218,5],[218,6,218,7],[218,8,218,9],[181,2,181,3],[181,4,181,5],[181,6,181,7],[181,8,181,9],[182,2,182,3],[182,4,182,5],[182,6,182,7],[182,8,182,9],[179,2,179,3],[179,4,179,5],[179,6,179,7],[179,8,179,9],[180,2,180,3],[180,4,180,5],[180,6,180,7],[180,8,180,9],[178,8,178,9],[164,2,164,3],[164,4,164,5],[178,2,178,3],[178,4,178,5],[178,6,178,7]]}
[]
[]
[null,"Boolesk algebra"]
[null,"Boolsk algebra (og boolsk logik) er et komplet system til logiske operationer, baseret på algebra"]
[null,{"$f":"\"med variabler, som kun kan have to tilstande eller værdier, der normalt udtrykkes som \"&TRUE","v":"med variabler, som kun kan have to tilstande eller værdier, der normalt udtrykkes som TRUE"}]
[null,{"$f":"\"eller \"&FALSE&\". Boolsk algebra er opfundet og udviklet af den engelske matematiker og filosof\"","v":"eller FALSE. Boolsk algebra er opfundet og udviklet af den engelske matematiker og filosof"}]
[null,"George Boole I 1850'erne."]
[null,"Algebraen anvendes eksempelvis i matematisk logik, i elektroniske kredsløb som for eksempel"]
[null,"i processorer, og inden for datalogi, hvor den engelske stavemåde boolean anvendes om en"]
[null,"datatype, der kun kan antage sandhedsværdier."]
[]
[]
[]
[]
[null,null,null,null,null,"George Boole (født 2. november 1815, død 8. december,"]
[null,null,null,null,null,"1864) var en engelsk filosof og matematiker, mest kendt "]
[null,null,null,null,null,"for sin opfindelse og udvikling af Boolesk algebra."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"I slutningen af 1930’erne var der en ung, amerikansk "]
[null,null,null,null,null,"ingeniørstuderende ved navn Claude Shannon (1916-2001),"]
[null,null,null,null,null,"der stødte på Boole i et kursus i filosofi og fik den idé at"]
[null,null,null,null,null,"overføre Booles system direkte til udviklingen af kom-"]
[null,null,null,null,null,"plekse elektriske kredsløb. For et elektrisk kredsløb er "]
[null,null,null,null,null,"altid enten tændt eller slukket – præcis som enhederne"]
[null,null,null,null,null,"i Booles system også kun kan have to værdier: sand (1) "]
[null,null,null,null,null,"eller falsk (0)."]
[null,null,null,null,null,"I sin kandidatafhandling fra 1937 beskrev Shannon, hvordan "]
[null,null,null,null,null,"man med boolesk algebra kunne forenkle telefon-"]
[null,null,null,null,null,"omstillingen, som på det tidspunkt var det mest"]
[null,null,null,null,null,"komplekse elektriske kredsløb, som man kendte til."]
[null,null,null,null,null,"Claude Shannons opdagelse blev senere taget op af"]
[null,null,null,null,null,"blandt andre Alan Turing, som opfandt computeren."]
[]
[]
[null,"Grundlæggende operationer"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Logisk\noperation",null,"Operator","Logisk\nnotation","Excel\nnotation","Definition"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Konjunktion",null,"OG","xÙy","=OG (x,y)","xÙy=1 hvis x = y = 1, xÙy=0 i alle andre tilfælde."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Disjunktion",null,"ELLER","xÚy","= ELLER(x,y)","xÚy=1 hvis x = y = 1, xÚy=0 i alle andre tilfælde."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Negation",null,"IKKE","Ø x","= IKKE(x)","Ø x =0 if x = 1, Ø x = 1 hvis x = 0."]
[]
[]
[null,"Vi lægger forsigtigt ud."]
[]
[null,null,{"$f":"CHAR(COLUMN()+64)","v":"C"},{"$f":"CHAR(COLUMN()+64)","v":"D"},{"$f":"CHAR(COLUMN()+64)","v":"E"}]
[null,{"$f":"ROW()","v":55}]
[null,{"$f":"ROW()","v":56},null,null,null,"Vi kan stille et meget enkelt spørgsmål. For eksem-"]
[null,{"$f":"ROW()","v":57},null,null,null,{"$f":"\"pel, er tallet i celle \"&mycell(C59)&\" større end tallet i celle \"&mycell(D59)&\"?\"","v":"pel, er tallet i celle C59 større end tallet i celle D59?"}]
[null,{"$f":"ROW()","v":58},null,null,null,{"$f":"\"Den nødvendige formel er indtastet i celle \"&mycell(E59)&\" og \"","v":"Den nødvendige formel er indtastet i celle E59 og "}]
[null,{"$f":"ROW()","v":59},15,10,{"$f":"C59>D59","v":true},{"$f":"\"svaret er \"&TRUE&\".\"","v":"svaret er TRUE."}]
[null,{"$f":"ROW()","v":60}]
[null,{"$f":"ROW()","v":61}]
[null,{"$f":"ROW()","v":62},null,null,null,"Du kan konvertere henholdsvis SAND og FALSK til "]
[null,{"$f":"ROW()","v":63},null,null,null,"værdierne 1 og 0 ved at gange det logisk udtryk, altså"]
[null,{"$f":"ROW()","v":64},15,10,{"$f":"(C64>D64)*1","v":1},{"$f":"\"SAND eller FALSK med 1. Se celle \"&mycell(E64)&\" der indeholder\"","v":"SAND eller FALSK med 1. Se celle E64 der indeholder"}]
[null,{"$f":"ROW()","v":65},null,null,null,{"$f":"\"formlen: \"&_xlfn.FORMULATEXT(E64)&\".\"","v":"formlen: =(C64>D64)*1."}]
[null,{"$f":"ROW()","v":66},null,null,null,"Det er dog ikke nødvendigt at konvertere et logisk ud-"]
[null,{"$f":"ROW()","v":67},null,null,null,{"$f":"\"tryk til 1 eller 0. Se for eksempel celle \"&mycell(E69)&\" der inde-\"","v":"tryk til 1 eller 0. Se for eksempel celle E69 der inde-"}]
[null,{"$f":"ROW()","v":68},null,null,null,"holder følgende formel:"]
[null,{"$f":"ROW()","v":69},null,null,{"$f":"(C64 > D64)*1000","v":1000},{"$f":"_xlfn.FORMULATEXT(E69)","v":"=(C64 > D64)*1000"}]
[null,{"$f":"ROW()","v":70}]
[null,{"$f":"ROW()","v":71}]
[null,{"$f":"ROW()","v":72},null,null,null,"Lad os sige, at vi ønsker at stille to spørgsmål. Er vær-"]
[null,{"$f":"ROW()","v":73},null,null,null,{"$f":"\"dien i celle \"&mycell(C80)&\" større end værdien i celle \"&mycell(D80)&\" og\"","v":"dien i celle C80 større end værdien i celle D80 og"}]
[null,{"$f":"ROW()","v":74},null,null,null,{"$f":"\"er værdien i celle \"&mycell(C80)&\" også mindre end 52.\"","v":"er værdien i celle C80 også mindre end 52."}]
[null,{"$f":"ROW()","v":75}]
[null,{"$f":"ROW()","v":76},null,null,null,{"$f":"\"Det første spørgsmål er stillet via formlen i celle \"&mycell(E80)","v":"Det første spørgsmål er stillet via formlen i celle E80"}]
[null,{"$f":"ROW()","v":77},null,null,null,{"$f":"\"og det sidste spørgsmål via formlen i celle \"&mycell(E81)&\". I celle\"","v":"og det sidste spørgsmål via formlen i celle E81. I celle"}]
[null,{"$f":"ROW()","v":78},null,null,null,{"$f":"mycell(E82)&\" er de to resultater ganget sammen.\"","v":"E82 er de to resultater ganget sammen."}]
[null,{"$f":"ROW()","v":79}]
[null,{"$f":"ROW()","v":80},5,10,{"$f":"C80 > D80","v":false},null,{"$f":"_xlfn.FORMULATEXT(E80)","v":"=C80 > D80"}]
[null,{"$f":"ROW()","v":81},null,null,{"$f":"C80 < 52","v":true},null,{"$f":"_xlfn.FORMULATEXT(E81)","v":"=C80 < 52"}]
[null,{"$f":"ROW()","v":82},null,null,{"$f":"E80 * E81","v":0},null,{"$f":"_xlfn.FORMULATEXT(E82)","v":"=E80 * E81"}]
[null,{"$f":"ROW()","v":83}]
[null,{"$f":"ROW()","v":84},null,null,null,"Det følgende gælder:"]
[null,{"$f":"ROW()","v":85}]
[null,{"$f":"ROW()","v":86},null,null,null,"Begge logiske udtryk = SAND."]
[null,{"$f":"ROW()","v":87},null,null,null,"Begge logiske udtryk = FALSK."]
[null,{"$f":"ROW()","v":88},null,null,null,"Første logiske udtryk = SAND og det andet logiske udtryk"]
[null,{"$f":"ROW()","v":89},null,null,null,"FALSK."]
[null,{"$f":"ROW()","v":90},null,null,null,"Første logiske udtryk = FALSK og det andet logiske udtryk"]
[null,{"$f":"ROW()","v":91},null,null,null,"SAND."]
[null,{"$f":"ROW()","v":92},null,null,null,"Altså for to udsagn X og Y har vi",null,null,"X","Y"]
[null,{"$f":"ROW()","v":93},null,null,null,"følgende muligheder:",null,null,{"$f":"TRUE","v":true},{"$f":"TRUE","v":true}]
[null,{"$f":"ROW()","v":94},null,null,null,null,null,null,{"$f":"TRUE","v":true},{"$f":"FALSE","v":false}]
[null,{"$f":"ROW()","v":95},null,null,null,null,null,null,{"$f":"FALSE","v":false},{"$f":"TRUE","v":true}]
[null,{"$f":"ROW()","v":96},null,null,null,null,null,null,{"$f":"FALSE","v":false},{"$f":"FALSE","v":false}]
[null,{"$f":"ROW()","v":97}]
[null,{"$f":"ROW()","v":98},null,null,null,"Vi gentager lige tabellen fra",null,null,"X","Y"]
[null,{"$f":"ROW()","v":99},null,null,null,"ovenfor (se formlerne i",null,null,{"$f":"I93","v":true},{"$f":"J93","v":true}]
[null,{"$f":"ROW()","v":100},null,null,null,{"$f":"mycell(I99)&\";\"&mycell(J102)&\"). Prøv nu at gange\"","v":"I99;J102). Prøv nu at gange"},null,null,{"$f":"I94","v":true},false]
[null,{"$f":"ROW()","v":101},null,null,null,"alle disse formler med 1, altså",null,null,false,true]
[null,{"$f":"ROW()","v":102},null,null,null,{"$f":"\"for eksempel: = \"&mycell(I93)&\" * 1\"","v":"for eksempel: = I93 * 1"},null,null,false,false]
[null,{"$f":"ROW()","v":103}]
[null,{"$f":"ROW()","v":104},null,null,null,"Bemærk altså, at når SAND og FALSK indgår I regneopera-"]
[null,{"$f":"ROW()","v":105},null,null,null,"tioner så konverteres SAND til 1 og FALSK til 0."]
[null,{"$f":"ROW()","v":106}]
[null,{"$f":"ROW()","v":107}]
[null,{"$f":"ROW()","v":108},null,null,null,{"$f":"\"I celle \"&mycell(E112)&\" er indtastet en formel der stiller to spørgs-\"","v":"I celle E112 er indtastet en formel der stiller to spørgs-"}]
[null,{"$f":"ROW()","v":109},null,null,null,"mål og returnerer 1 eller 0 afhængig af begge spørgs-"]
[null,{"$f":"ROW()","v":110},null,null,null,"besvares med SAND."]
[null,{"$f":"ROW()","v":111}]
[null,{"$f":"ROW()","v":112},5,10,{"$f":"(C112 > D112)*(C112 < 52)","v":0},{"$f":"_xlfn.FORMULATEXT(E112)","v":"=(C112 > D112)*(C112 < 52)"}]
[null,{"$f":"ROW()","v":113}]
[null,{"$f":"ROW()","v":114},null,null,null,{"$f":"\"Prøv at ændre værdien i celle \"&mycell(C112)&\" til for eksempel\"","v":"Prøv at ændre værdien i celle C112 til for eksempel"}]
[null,{"$f":"ROW()","v":115},null,null,null,{"$f":"\"15 og bemærk hvad der sker i celle \"&mycell(E112)&\".\"","v":"15 og bemærk hvad der sker i celle E112."}]
[null,{"$f":"ROW()","v":116}]
[null,{"$f":"ROW()","v":117},null,null,null,"Hvad nu hvis vi ønsker at teste om blot en af betin-"]
[null,{"$f":"ROW()","v":118},null,null,null,"gelserne er SAND?"]
[null,{"$f":"ROW()","v":119}]
[null,{"$f":"ROW()","v":120},null,null,null,"Lad os stille følgende spørgsmål:"]
[null,{"$f":"ROW()","v":121}]
[null,{"$f":"ROW()","v":122},5,10,{"$f":"(C122=D122)","v":false},{"$f":"\"Er værdien i celle \"&mycell(C122)&\" lig med værdien i celle \"&mycell(D122)&\"?\"","v":"Er værdien i celle C122 lig med værdien i celle D122?"}]
[null,{"$f":"ROW()","v":123},null,null,{"$f":"(C122>100)","v":false},{"$f":"\"Er værdien i celle \"&mycell(C122)&\" større end 100?\"","v":"Er værdien i celle C122 større end 100?"}]
[null,{"$f":"ROW()","v":124},null,null,{"$f":"(D122>8)","v":true},{"$f":"\"Er værdien i celle \"&mycell(D122)&\" større end 8?\"","v":"Er værdien i celle D122 større end 8?"}]
[null,{"$f":"ROW()","v":125}]
[null,{"$f":"ROW()","v":126},null,null,{"$f":"E122+E123+E124","v":1},{"$f":"_xlfn.FORMULATEXT(E126)","v":"=E122+E123+E124"}]
[null,{"$f":"ROW()","v":127}]
[null,{"$f":"ROW()","v":128},null,null,null,"I tilfældet her ønsker vi at vide om blot en af betin-"]
[null,{"$f":"ROW()","v":129},null,null,null,"gelserne er SAND. Det spiller ingen rolle hvor mange"]
[null,{"$f":"ROW()","v":130},null,null,null,"der er SAND, så længe bare en af dem er SAND. "]
[null,{"$f":"ROW()","v":131},null,null,null,"Svaret er nemt at finde simpelthen ved at summere"]
[null,{"$f":"ROW()","v":132},null,null,null,"resultaterne og se om summen er større end nul. I "]
[null,{"$f":"ROW()","v":133},null,null,{"$f":"((C122=D122) + (C122>100) + (D122>8)) > 0","v":true},{"$f":"\"cell \"&mycell(E133)&\" er vist hvordan man laver formlen.\"","v":"cell E133 er vist hvordan man laver formlen."}]
[]
[]
[null,null,null,null,{"$f":"_xlfn.FORMULATEXT(E133)","v":"=((C122=D122) + (C122>100) + (D122>8)) > 0"}]
[]
[]
[null,"OG"]
[]
[null,"OG funktionen returnerer SAND hvis alle argumenter er sande. Funktionen returnerer FALSK "]
[null,"hvis et eller flere argumenter er falske."]
[]
[null,"Syntaks"]
[null,"OG(logisk1; logiskl2, ...)"]
[null,"Logisk1, logisk2, ...   er 1 til 30 betingelser som kan være enter sande eller falske."]
[]
[null,null,{"$f":"CHAR(COLUMN()+64)","v":"C"},{"$f":"CHAR(COLUMN()+64)","v":"D"},{"$f":"CHAR(COLUMN()+64)","v":"E"},{"$f":"CHAR(COLUMN()+64)","v":"F"},{"$f":"CHAR(COLUMN()+64)","v":"G"}]
[]
[null,{"$f":"ROW()","v":150},"Formel",null,null,null,"Resultat"]
[null,{"$f":"ROW()","v":151},"=OG(5 > 3; 80 < 96)",null,null,null,null,"Indtast formler i"]
[null,{"$f":"ROW()","v":152},"=OG(2+2 = 4; 2*4 = 5)",null,null,null,null,{"$f":"mycell(G151)&\":\"&mycell(G154)&\" som vist i\"","v":"G151:G154 som vist i"}]
[null,{"$f":"ROW()","v":153},"=OG(SAND; FALSK)*1",null,null,null,null,{"$f":"mycell(C151)&\":\"&mycell(C154)&\".\"","v":"C151:C154."}]
[null,{"$f":"ROW()","v":154},"=OG(SAND; SAND)*1"]
[]
[]
[null,"Eksempel 6"]
[null,"Antag at oversigten herunder viser nogle kunders køb i løbet af det seneste år og de samme "]
[null,"kunders gæld ved årets udgang. Nu ønsker du at identificere de kunder, hvorom det gælder, "]
[null,"at de både har købt mere end 200 styk i årets løb og har en gæld ved årets udgang på mindre "]
[null,"end 2.000."]
[]
[null,{"$f":"\"Opret de nødvendige formler i \"&mycell(G167)&\":\"&mycell(G170)&\".\"","v":"Opret de nødvendige formler i G167:G170."}]
[]
[null,null,{"$f":"CHAR(COLUMN()+64)","v":"C"},null,{"$f":"CHAR(COLUMN()+64)","v":"E"},null,{"$f":"CHAR(COLUMN()+64)","v":"G"}]
[null,{"$f":"ROW()","v":166},"Købte antal styk",null,"Gæld",null,"Result"]
[null,{"$f":"ROW()","v":167},100,null,3000,null,null,null,null,{"$f":"AND(C167>200,E167<2000)","v":false}]
[null,{"$f":"ROW()","v":168},100,null,1000,null,null,null,null,{"$f":"AND(C168>200,E168<2000)","v":false}]
[null,{"$f":"ROW()","v":169},300,null,3000,null,null,null,null,false]
[null,{"$f":"ROW()","v":170},300,null,1000,null,null,null,null,true]
[]
[null,"Sæt x hvis du ønsker hjælp"]
[]
[]
[]
[]
[null,"Med to betingelser - kald dem p og q - er der følgende muligheder:"]
[]
[null,null,{"$f":"CHAR(COLUMN()+64)","v":"C"},{"$f":"CHAR(COLUMN()+64)","v":"D"},"E","F","G","H","I","J"]
[null,{"$f":"ROW()","v":180},"p",null,"q",null,{"$f":"_xlfn.FORMULATEXT(G181)","v":"=AND(C181;E181)"},null,{"$f":"_xlfn.FORMULATEXT(I181)","v":"=C181*E181"}]
[null,{"$f":"ROW()","v":181},{"$f":"FALSE","v":false},null,{"$f":"FALSE","v":false},null,{"$f":"AND(C181,E181)","v":false},null,{"$f":"C181*E181","v":0}]
[null,{"$f":"ROW()","v":182},{"$f":"FALSE","v":false},null,{"$f":"TRUE","v":true},null,{"$f":"AND(C182,E182)","v":false},null,{"$f":"C182*E182","v":0}]
[null,{"$f":"ROW()","v":183},{"$f":"TRUE","v":true},800,{"$f":"FALSE","v":false},null,{"$f":"AND(C183,E183)","v":false},null,{"$f":"C183*E183","v":0}]
[null,{"$f":"ROW()","v":184},{"$f":"TRUE","v":true},25,{"$f":"TRUE","v":true},null,{"$f":"AND(C184,E184)","v":true},null,{"$f":"C184*E184","v":1}]
[]
[null,"OG funktionen returnerer SAND hvis alle argumenter er sande, FALSK hvis bare ét af argumen-"]
[null,"terne er falske."]
[]
[null,"Bemærk, jf. kolonnen yderst til højre i ovenstående tabel, som tidligere nævnt, at når SAND og FALSK "]
[null,"indgår I et regneudtryk (her multiplikation) så bliver SAND og FALSK konverteret til henholdsvis 1 og 0."]
[]
[null,null,"= 0 * 0 = 0"]
[null,null,"= 0 * 1 = 0"]
[null,null,"= 1 * 0 = 0"]
[null,null,"= 1 * 1 = 1"]
[]
[]
[]
[null,"ELLER"]
[]
[null,"Returnerer SAND hvis ét eller flere af argumenterne er sande; returnerer FALSK hvis alle argu-"]
[null,"menter er falske."]
[]
[null,"Syntaks"]
[null,"ELLER(logisk1; logiskl2, ...)"]
[null,"Logisk1, logisk2, ...   er 1 til 30 betingelser som kan være enter sande eller falske."]
[]
[null,null,{"$f":"CHAR(COLUMN()+64)","v":"C"},{"$f":"CHAR(COLUMN()+64)","v":"D"},{"$f":"CHAR(COLUMN()+64)","v":"E"},{"$f":"CHAR(COLUMN()+64)","v":"F"},{"$f":"CHAR(COLUMN()+64)","v":"G"}]
[]
[null,{"$f":"ROW()","v":210},"Formel",null,null,null,"Resultat"]
[null,{"$f":"ROW()","v":211},"=ELLER(2>3; 3<4)",null,null,null,{"$f":"OR(2>3,3<4)","v":true},"Indtast formler i "]
[null,{"$f":"ROW()","v":212},"=ELLER(SAND; FALSK)*1",null,null,null,{"$f":"OR(TRUE,FALSE)*1","v":1},{"$f":"mycell(G211)&\":\"&mycell(G213)&\" som vist i\"","v":"G211:G213 som vist i"}]
[null,{"$f":"ROW()","v":213},"=ELLER(5=7; 2<>2)*1",null,null,null,{"$f":"OR(5=7,2<>2)*1","v":0},{"$f":"mycell(C211)&\":\"&mycell(C213)&\".\"","v":"C211:C213."}]
[]
[]
[]
[null,"Med to betingelser - kald dem p og q - er der følgende muligheder:"]
[]
[null,null,{"$f":"CHAR(COLUMN()+64)","v":"C"},null,{"$f":"CHAR(COLUMN()+64)","v":"E"},null,{"$f":"CHAR(COLUMN()+64)","v":"G"},null,{"$f":"CHAR(COLUMN()+64)","v":"I"}]
[null,{"$f":"ROW()","v":220},"p",null,"q",null,"=ELLER(p;q)",null,"= ((p + q) > 0) *1"]
[null,{"$f":"ROW()","v":221},false,null,false,null,{"$f":"OR(C221,E221)","v":false},null,{"$f":"((C221+E221)>0)*1","v":0}]
[null,{"$f":"ROW()","v":222},false,null,true,null,{"$f":"OR(C222,E222)","v":true},null,{"$f":"((C222+E222)>0)*1","v":1}]
[null,{"$f":"ROW()","v":223},true,800,false,null,{"$f":"OR(C223,E223)","v":true},null,{"$f":"((C223+E223)>0)*1","v":1}]
[null,{"$f":"ROW()","v":224},true,25,true,null,{"$f":"OR(C224,E224)","v":true},null,{"$f":"((C224+E224)>0)*1","v":1}]
[]
[null,null,"= 0 + 0 = 0"]
[null,null,"= 0 + 1 > 0"]
[null,null,"= 1 + 0 > 0"]
[null,null,"= 1 + 1 > 0"]
[]
[]
[null,"IKKE"]
[]
[null,"Vender argumentets værdi om. Brug IKKE når du vil sikre, at en værdi ikke er lig med en be-"]
[null,"stemt værdi."]
[]
[null,"Syntaks"]
[null,"IKKE(logisk)"]
[]
[null,"Logisk er en værdi eller et udsagn der kan være SAND eller FALSK. Hvis logisk er FALSK vil funk-"]
[null,"tionen IKKE returnere SAND; hvis logisk er SAND vil IKKE returnere FALSK."]
[]
[null,null,{"$f":"CHAR(COLUMN()+64)","v":"C"},null,{"$f":"CHAR(COLUMN()+64)","v":"E"}]
[null,{"$f":"ROW()","v":244},"Sandhedsværdi (p)",null,"=IKKE(p)"]
[null,{"$f":"ROW()","v":245},{"$f":"2=2","v":true},null,{"$f":"NOT(C245)","v":false}]
[null,{"$f":"ROW()","v":246},{"$f":"5=7","v":false},null,{"$f":"NOT(C246)","v":true}]
[]
[]
[null,"Opgaver"]
[]
[null,"Hvis du er sikker på, at du ønsker hjælp til opgaverne herunder kan du sætte et x i den "]
[null,"blå celle i kolonne C."]
[]
[]
[null,null,{"$f":"CHAR(COLUMN()+64)","v":"C"}]
[null,{"$f":"ROW()","v":256},"Data"]
[null,{"$f":"ROW()","v":257},15,{"$f":"\"Indtast en OG formel der viser om \"&mycell(C257)&\" > \"&mycell(C258)&\" og \"&mycell(C257)&\" < \"&mycell(C259)","v":"Indtast en OG formel der viser om C257 > C258 og C257 < C259"}]
[null,{"$f":"ROW()","v":258},9,"er SAND eller FALSK."]
[null,{"$f":"ROW()","v":259},8]
[]
[]
[]
[null,null,"A.",null,null,null,{"$f":"IF(B263=\"x\",_xlfn.FORMULATEXT(AB263),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(C257 > C258,C257 < C259)","v":false}]
[null,null,null,null,null,null,{"$f":"IF(B263=\"x\",\"alternativt\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(B263=\"x\",_xlfn.FORMULATEXT(AB265),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(C257 > C258)*(C257 < C259)","v":0}]
[]
[]
[null,null,{"$f":"CHAR(COLUMN()+64)","v":"C"}]
[null,{"$f":"ROW()","v":269},"Data"]
[null,{"$f":"ROW()","v":270},"Spade",null,{"$f":"\"Indtast en OG formel der viser om \"&mycell(C270)&\" = \"&mycell(C272)&\" og \"","v":"Indtast en OG formel der viser om C270 = C272 og "}]
[null,{"$f":"ROW()","v":271},"Vaskeklud",null,{"$f":"mycell(C270)&\" = \"&mycell(C271)&\" er SAND eller FALSK.\"","v":"C270 = C271 er SAND eller FALSK."}]
[null,{"$f":"ROW()","v":272},"Spade"]
[]
[]
[]
[]
[]
[null,null,"B.",null,null,null,{"$f":"IF(B278=\"x\",_xlfn.FORMULATEXT(AB278),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(C270 = C272,C270 = C271)","v":false}]
[null,null,null,null,null,null,{"$f":"IF(B278=\"x\",\"alternativt\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(B278=\"x\",_xlfn.FORMULATEXT(AB280),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(C270 = C272)*(C270 = C271)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(B278=\"x\", \"En spade er en spade - en spade kan ikke\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(B278=\"x\",\"på samme tid være både en spade og en\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(B278=\"x\",\"vaskeklud.\",\"\")","v":""}]
[]
[]
[]
[]
[]
[null,null,{"$f":"CHAR(COLUMN()+64)","v":"C"}]
[null,{"$f":"ROW()","v":290},"Data"]
[null,{"$f":"ROW()","v":291},15,{"$f":"\"Indtast en ELLER formel der viser om \"&mycell(C291)&\" > \"&mycell(C292)&\" eller \"&mycell(C291)&\" < \"&mycell(C293)","v":"Indtast en ELLER formel der viser om C291 > C292 eller C291 < C293"}]
[null,{"$f":"ROW()","v":292},9,"er SAND eller FALSK."]
[null,{"$f":"ROW()","v":293},8]
[]
[]
[]
[]
[null,null,"C.",null,null,null,{"$f":"IF(B298=\"x\",_xlfn.FORMULATEXT(AB298),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"OR(C291 > C292,C291 < C293)","v":true}]
[null,null,null,null,null,null,{"$f":"IF(B298=\"x\",_xlfn.FORMULATEXT(AB299),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"((C291 > C292)+(C291 < C293)) > 0","v":true}]
[]
[]
[]
[null,null,null,{"$f":"\"Indtast en formel der udtrykker at udsagnet \"&mycell(C291)&\" + \"&mycell(C292)&\" = 24 er FALSK.\"","v":"Indtast en formel der udtrykker at udsagnet C291 + C292 = 24 er FALSK."}]
[]
[null,null,"D.",null,null,null,{"$f":"IF(B305=\"x\",_xlfn.FORMULATEXT(AB305),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"((C291 + C292)=24) = FALSE","v":false}]
[]
[]
[]
[]
[null,"SAND/FALSK"]
[]
[null,null,{"$f":"CHAR(COLUMN()+64)","v":"C"},null,{"$f":"\"Indtast formler i \"&mycell(G320)&\":\"&mycell(G326)","v":"Indtast formler i G320:G326"}]
[null,{"$f":"ROW()","v":313},3,null,"der returnerer den korrekte værdi"]
[null,{"$f":"ROW()","v":314},5,null,"(SAND eller FALSK), også hvis du"]
[null,{"$f":"ROW()","v":315},"Hallo",null,{"$f":"\"ændrer værdierne i \"&mycell(C313)&\":\"&mycell(C315)&\".\"","v":"ændrer værdierne i C313:C315."}]
[]
[]
[]
[null,null,null,"Udsagn",null,null,"S/F"]
[null,null,"E.",{"$f":"\"Værdien i \"&mycell(C313)&\" er mindre end 4\"","v":"Værdien i C313 er mindre end 4"},null,null,null,{"$f":"IF(B320=\"x\",_xlfn.FORMULATEXT(AB320),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C313 < 4","v":true}]
[null,null,null,{"$f":"\"Summen af \"&mycell(C313)&\" og \"&mycell(C314)&\" er større end eller lig med 8\"","v":"Summen af C313 og C314 er større end eller lig med 8"}]
[null,null,"F.",null,null,null,null,{"$f":"IF(B322=\"x\",_xlfn.FORMULATEXT(AB322),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(C313 + C314) >= 8","v":true}]
[null,null,"G.",{"$f":"\"Teksten i \"&mycell(C315)&\" er \"\"hallo\"\"\"","v":"Teksten i C315 er \"hallo\""},null,null,null,{"$f":"IF(B323=\"x\",_xlfn.FORMULATEXT(AB323),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C315 = \"hello\"","v":false}]
[null,null,null,{"$f":"\"Værdien i \"&mycell(C313)&\" er lig med værdien i \"&mycell(C314)","v":"Værdien i C313 er lig med værdien i C314"}]
[null,null,"H.",null,null,null,null,{"$f":"IF(B325=\"x\",_xlfn.FORMULATEXT(AB325),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C313 = C314","v":false}]
[null,null,null,{"$f":"mycell(C313)&\" opløftet til potensen i \"&mycell(C314)&\" er mindre end \"&mycell(C314)&\" opløftet til potensen i \"&mycell(C313)&\".\"","v":"C313 opløftet til potensen i C314 er mindre end C314 opløftet til potensen i C313."}]
[]
[null,null,"I.",null,null,null,null,{"$f":"IF(B328=\"x\",_xlfn.FORMULATEXT(AB328),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C313^C314 < C314^C313","v":false}]
[]
[]
[]
[null,null,null,"IKKE"]
[]
[]
[]
[]
[null,null,"J.","=IKKE(2 + 2 = 4)",null,null,null,{"$f":"IF(OR(B337=\"x\",_xlfn.FORMULATEXT(AB337)=\"=IKKE(2+2=4)\"),_xlfn.FORMULATEXT(AB337),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NOT(2+2=4)","v":false}]
[null,null,null,null,null,null,null,{"$f":"IF(OR(B337=\"x\",_xlfn.FORMULATEXT(AB337)=\"=IKKE(2+2=4)\"),\"Et sandt udsagn negeres;\",\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(OR(B337=\"x\",_xlfn.FORMULATEXT(AB337)=\"=IKKE(2+2=4)\"),\"hvilket reulterer i FALSK.\",\"\")","v":""}]
[]
[null,null,"K.","=IKKE(5 = 7)",null,null,null,{"$f":"IF(OR(B341=\"x\",_xlfn.FORMULATEXT(AB341)=\"=IKKE(5=7)\"),_xlfn.FORMULATEXT(AB341),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NOT(5=7)","v":true}]
[null,null,null,null,null,null,null,{"$f":"IF(OR(B341=\"x\",_xlfn.FORMULATEXT(AB341)=\"=IKKE(5=7)\"),\"Et falsk udsagn negeres\",\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(OR(B341=\"x\",_xlfn.FORMULATEXT(AB341)=\"=IKKE(5=7)\"),\"hviket resulterer i SAND.\",\"\")","v":""}]
[]
[]
[null,"Herunder (i kolonne C) er anført en række formler (som tekst). I "]
[null,"kolonne E skal du skrive, hvad du tror formlen  vil returnere."]
[null,"Tjek herefter dine antagelser ved at indtaste (i kolonne G) de "]
[null,"formler der er vist i kolonne C."]
[]
[null,null,{"$f":"CHAR(COLUMN()+64)","v":"C"},"D","E","F","G"]
[{"$f":"1/FALSE","v":{"$error":"#DIV/0!"}},{"$f":"ROW()","v":352},{"$f":"_xlfn.FORMULATEXT(A352)","v":"=1/FALSE"},null,null,null,null,{"$f":"IFERROR(IF(ERROR.TYPE(G352=2),\"Husk, at når FALSK indgår i en regneoperation, så konverteres FALSK til 0, og 1/0 = #DIV/0!\",\"\"),\"\")","v":""}]
[{"$f":"\"B\">\"A\"","v":true},{"$f":"ROW()","v":353},{"$f":"_xlfn.FORMULATEXT(A353)","v":"=\"B\">\"A\""},null,null,null,null,{"$f":"IF(G353=\"\",\"\",\"Hænger, såvidt jeg ved, sammen med Excels sorteringmåde.\")","v":""}]
[{"$f":"\"a\"=\"A\"","v":true},{"$f":"ROW()","v":354},{"$f":"_xlfn.FORMULATEXT(A354)","v":"=\"a\"=\"A\""},null,null,null,null,{"$f":"IF(G354=TRUE,\"Excel skelner normalt ikke mellem små og store bogstaver.\",\"\")","v":""}]
[{"$f":"\"a\">99","v":true},{"$f":"ROW()","v":355},{"$f":"_xlfn.FORMULATEXT(A355)","v":"=\"a\">99"},null,null,null,null,{"$f":"IF(G355=TRUE,\"En hviken som helst tekst er større end et hvilken som helst tal.\",\"\")","v":""}]
[{"$f":"TRUE>FALSE","v":true},{"$f":"ROW()","v":356},{"$f":"_xlfn.FORMULATEXT(A356)","v":"=TRUE>FALSE"}]
[{"$f":"FALSE>\"SAND\"","v":true},{"$f":"ROW()","v":357},"=FALSE>\"SAND\"",null,null,null,null,{"$f":"IF(G357=\"\",\"\",\"Booleske værdier er større end en hvilken som helst tekst.\")","v":""}]
[{"$f":"TRUE>9.9999E+307","v":true},{"$f":"ROW()","v":358},"=TRUE>9,9999E+307",null,null,null,null,{"$f":"IF(G358=\"\",\"\",\"Enhver boolesk værdi (SAND eller FALSK) er større end et hvilken som helst tal.\")","v":""}]
[{"$f":"1>FALSE","v":false},{"$f":"ROW()","v":359},"=1>FALSE",null,null,null,null,{"$f":"IF(G359=\"\",\"\",\"Et hvert tal er mindre end en hver boolesk værdi.\")","v":""}]
[{"$f":"1-TRUE=FALSE","v":false},{"$f":"ROW()","v":360},"=1-TRUE=FALSE",null,null,null,null,{"$f":"IF(G360=\"\",\"\",\"Formlen evalueres til 1 - SAND = 0 --->  0 = FALSK.\")","v":""}]
[{"$f":"TRUE+TRUE","v":2},{"$f":"ROW()","v":361},"=TRUE+TRUE",null,null,null,null,{"$f":"IF(G361=\"\",\"\",\"I en regneoperation konverteres SAND til 1, hvorfor SAND + SAND konverteres til 1 + 1 = 2.\")","v":""}]
[{"$f":"IF(-7,\"A\",\"B\")","v":"A"},{"$f":"ROW()","v":362},"=IF(-7;\"A\";\"B\")",null,null,null,null,{"$f":"IF(G362=\"\",\"\",\"I en HVIS-funktion bliver et hvert tal forskellig fra nul 0 i det første argument konverteret til SAND.\")","v":""}]
[{"$f":"IF(0,\"A\",\"B\")","v":"B"},{"$f":"ROW()","v":363},"=IF(0;\"A\";\"B\")",null,null,null,null,{"$f":"IF(G363=\"\",\"\",\"I en HVIS-funktion bliver et hvert tal lig med 0 i det første argument konverteret til FALSK.\")","v":""}]
[{"$f":"IF(0,1)","v":false},{"$f":"ROW()","v":364},"=IF(0;1)",null,null,null,null,{"$f":"IF(G364=\"\",\"\",\"I en HVIS-funktion bliver et hvert tal lig med 0 i det første argument konverteret til FALSK.\")","v":""}]
[{"$f":"AND(0,0)","v":false},{"$f":"ROW()","v":365},"=AND(0;0)",null,null,null,null,{"$f":"IF(G365=\"\",\"\",\"I en OG-funktion bliver et hvert tal lig med 0 i det første argument konverteret til FALSK.\")","v":""}]
[{"$f":"AND(0=0,0=0)","v":true},{"$f":"ROW()","v":366},"=AND(0=0;0=0)",null,null,null,null,{"$f":"IF(G366=\"\",\"\",\"Formlen evalueres til =OG(SAND; SAND) der på sin side returnerer SAND.\")","v":""}]
[{"$f":"1=1=1","v":false},{"$f":"ROW()","v":367},"=1=1=1",null,null,null,null,{"$f":"IF(G367=\"\",\"\",\"Formlen evalueres til =SAND = 1, hvilket er FALSK jf. celle \"&mycell(H358)&\".\")","v":""}]
[{"$f":"1&2&3*5","v":"1215"},{"$f":"ROW()","v":368},"=1&2&3*5",null,null,null,null,{"$f":"IF(G368=\"\",\"\",\"Formlen evalueres først til =12 som herefter sammenkædes med 15, resultat altså 1215.\")","v":""}]
[{"$f":" \"1\" > 2","v":true},{"$f":"ROW()","v":369},"= \"1\" > 2",null,null,null,null,{"$f":"IF(G369=TRUE,\"En hviken som helst tekst er større end et hvilken som helst tal.\",\"\")","v":""}]
[{"$f":"3>4<7","v":false},{"$f":"ROW()","v":370},"=3>4<7",null,null,null,null,{"$f":"IF(G370=\"\",\"\",\"Formlen evalueres først til 3>4 som er FALSK og herefter FALSK < 7, hvilket er FALSK.\")","v":""}]
[{"$f":"AND(12,7)","v":true},{"$f":"ROW()","v":371},"=AND(12;7)",null,null,null,null,{"$f":"IF(G371=TRUE,\"Formlen evalueres først til =OG((12<>0);(7<>0)) og videre =OG(SAND; SAND) = SAND.\",\"\")","v":""}]
[]
[]
[]
[null,"SAND  >  FALSK  >  Tekst  >  Tal"]

{"sheet":"HVIS+","index":3,"n_rows":240,"n_cols":17,"rows_kept":240,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Rabat og leveringsgebyr"]
[]
[null,null,{"$f":"CHAR(COLUMN()+64)","v":"C"},{"$f":"CHAR(COLUMN()+64)","v":"D"},{"$f":"CHAR(COLUMN()+64)","v":"E"},"F","G","H","I","J"]
[null,{"$f":"ROW()","v":5},null,null,"Vare 1","Vare 2","Vare 3","Vare 4","Vare 5","Vare 6"]
[null,{"$f":"ROW()","v":6},"Antal",null,5,63,36,45,87,90]
[null,{"$f":"ROW()","v":7},"Stk. Pris",null,50,70,30,40,50,60]
[null,{"$f":"ROW()","v":8},"Køb",null,{"$f":"E6*E7","v":250},4410,1080,1800,4350,5400]
[null,{"$f":"ROW()","v":9},"Rabat %",null,null,null,null,null,null,null,null,{"$f":"IF(E8 > $I$17,  $J$17,  IF(E8 > $I$18,  $J$18,  IF(E8 > $I$19,  $J$19,  0)))","v":0},0.1,0.05,0.05,0.1,0.1]
[null,{"$f":"ROW()","v":10},"Leveringsgebyr %",null,null,null,null,null,null,null,null,{"$f":"IF(E6 >= $I$22,  J22,  IF(E6 >= $I$23,  $J$23,  IF(E6 >= $I$24,  $J$24,  IF(E6 > $I$25,  $J$25,  0))))","v":0.2},0.05,0.1,0.1,0,0]
[null,{"$f":"ROW()","v":11},"Rabat"]
[null,{"$f":"ROW()","v":12},"Leveringsgebyr"]
[null,{"$f":"ROW()","v":13},"Køb i alt"]
[]
[null,"Udregn prisen for varerne. I forbindelse med rabat og levering er der følgende betingelser:"]
[]
[null,"Der ydes rabat efter følgende regler",null,null,null,null,null,null,4000,0.1]
[null,"•  5% rabat ved køb mellem 1.000 og 4.000 (køb >= 1000 og køb < 4.000)",null,null,null,null,null,null,1000,0.05]
[null,"•  10% rabat ved køb større end 4.000 (køb >= 4.000)",null,null,null,null,null,null,0,0,"Hvis man senere ændrer i sine"]
[null,null,null,null,null,null,null,null,null,null,"rabat- eller leveringsbetingelser"]
[null,"Der skal betales leveringsgebyr efter følgende regler:",null,null,null,null,null,null,null,null,"er det nemmere at rette tallene i"]
[null,"•  20% af prisen på køb under 25 stk. (køb < 25)",null,null,null,null,null,null,75,0,"de grå celler i stedet for at skulle"]
[null,"•  10% af prisen på køb på 25, men under 50 stk. (25 <= køb < 50)",null,null,null,null,null,null,50,0.05,"rette alle formler. "]
[null,"•  5% af prisen på køb på 50, men under 75 stk. (50 <= køb < 75)",null,null,null,null,null,null,25,0.1]
[null,"•  0% af prisen på køb på 75 stk. eller mere. (køb >= 75)",null,null,null,null,null,null,0,0.2]
[]
[]
[null,"Ønsker du hjælp, sæt x"]
[]
[]
[]
[]
[null,"Jobkode baseret på to kriterier"]
[]
[null,"  ",{"$f":"CHAR(COLUMN()+64)","v":"C"},{"$f":"CHAR(COLUMN()+64)","v":"D"},{"$f":"CHAR(COLUMN()+64)","v":"E"},{"$f":"CHAR(COLUMN()+64)","v":"F"},{"$f":"CHAR(COLUMN()+64)","v":"G"},null,{"$f":"IF(AND(E53=\"x\",E54=\"x\",E55=\"x\"),\"3 forskellige formler\",\"\")","v":""}]
[null,{"$f":"ROW()","v":36},"Navn","Område","Salg","Anciennitet","Job-kode",null,"Job-kode","Job-kode","Job-kode"]
[{"$f":"IF((AND(F37>5,E37>60000)),2,1)","v":1},{"$f":"ROW()","v":37},"Anders","Øst",120000,2,null,null,{"$f":"IF((AND(F37>5,E37>60000)),2,1)","v":1},{"$f":"IF(OR(F37<=5,E37<=60000),1,2)","v":1},{"$f":"(E37>60000)*(F37>5)*2+((E37<=60000)+(F37<=5)>=1)","v":1},{"$f":"IF(E53=\"\",\"\",\"Formel i \"&mycell(I37)&\":    \"&_xlfn.FORMULATEXT(I37))","v":""}]
[{"$f":"IF(OR(F37<=5,E7<=60000),1,2)","v":1},{"$f":"ROW()","v":38},"Berit","Vest",253812,9,null,null,{"$f":"IF((AND(F38>5,E38>60000)),2,1)","v":2},{"$f":"IF(OR(F38<=5,E38<=60000),1,2)","v":2},{"$f":"(E38>60000)*(F38>5)*2+((E38<=60000)+(F38<=5)>=1)","v":2}]
[{"$f":"(E37>60000)*(F37>5)*2+((E37<=60000)+(F37<=5)>=1)","v":1},{"$f":"ROW()","v":39},"Carsten","Øst",253812,3,null,null,1,1,1]
[null,{"$f":"ROW()","v":40},"Dorthe","Syd",72000,12,null,null,2,2,2,{"$f":"IF(E54=\"\",\"\",\"Formel i \"&mycell(J40)&\":    \"&_xlfn.FORMULATEXT(J40))","v":""}]
[null,{"$f":"ROW()","v":41},"Esben","Syd",12300,6,null,null,1,1,1]
[null,{"$f":"ROW()","v":42},"Finn","Nord",61000,7,null,null,2,2,2]
[null,{"$f":"ROW()","v":43},"Gunhild","Øst",40000,4,null,null,1,1,1,{"$f":"IF(E55=\"\",\"\",\"Formel i \"&mycell(K43)&\":    \"&_xlfn.FORMULATEXT(K43))","v":""}]
[]
[null,"Ovenstående viser dine sælgeres årlige salg pr. område samt sælgernes",null,null,null,null,null,null,{"$f":"IF(AND(E53=\"x\",E54=\"x\",E55=\"x\"),\"Prøv på skift at vælge celle \"&mycell(I37)&\", \"&mycell(J40)&\" og \"&mycell(K43)&\",\",\"\")","v":""}]
[null,"anciennitet. Du ønsker en formel i kolonne H der returnerer en job kode,",null,null,null,null,null,null,{"$f":"IF(AND(E53=\"x\",E54=\"x\",E55=\"x\"),\"tryk på formler på båndet og herefter på\",\"\")","v":""}]
[null,"baseret på to forskellige kriterier. Sælgere med en anciennitet på mere",null,null,null,null,null,null,{"$f":"IF(AND(E53=\"x\",E54=\"x\",E55=\"x\"),\"Evaluer formel i gruppen Formelrevision.\",\"\")","v":""}]
[null,"end fem år og som har haft et årligt salg på mere end 60.000 skal have",null,null,null,null,null,null,{"$f":"IF(AND(E53=\"x\",E54=\"x\",E55=\"x\"),\"Tryk herefter Evaluer knappen og forstå,\",\"\")","v":""}]
[null,"job-kode 2. Alle andre skal have job-kode 1.",null,null,null,null,null,null,{"$f":"IF(AND(E53=\"x\",E54=\"x\",E55=\"x\"),\"hvad der sker for hvert klik (hvert bereg-\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(E53=\"x\",E54=\"x\",E55=\"x\"),\"ningstrin.\",\"\")","v":""}]
[null,"Lav sådan en formel."]
[]
[null,"Ønsker du at se et forslag"]
[null,"Endnu et forslag"]
[null,"Et tredje forslag"]
[]
[]
[]
[]
[null,"Gageforhøjelse"]
[]
[null,null,{"$f":"CHAR(COLUMN()+64)","v":"C"},"D","E","F","G","H"]
[]
[null,{"$f":"ROW()","v":64},"Navn",null,"Gage","Job-kode","Forhøjelse","Ny gage",null,"Formel1","Formel2","Formel3","Formel4","Formel5"]
[null,{"$f":"ROW()","v":65},"Peter",null,22600,1,null,null,null,{"$f":"IF(F65=1,$F$78,IF(F65=2,$F$78,IF(F65=3,$F$79,IF(F65=4,$F$79,0))))","v":0.02},{"$f":"IF(OR(F65={1,2}),$F$78,IF(OR(F65={3,4}),$F$79,0))","v":0.02},{"$f":"OR(F65=1,F65=2)*$F$78+OR(F65=3,F65=4)*$F$79","v":0.02},{"$f":"((((F65=1)+(F65=2))*$F$78+((F65=3)+(F65=4))*$F$79)+((F65<>1)*(F65<>2)*(F65<>3)*(F65<>4)*$F$80))","v":0.02},{"$f":"OR(F65={1,2})*$F$78+OR(F65={3,4})*$F$79","v":0.02}]
[null,{"$f":"ROW()","v":66},"Harry",null,29400,2,null,null,null,0.02,{"$f":"IF(OR(F66={1,2}),$F$78,IF(OR(F66={3,4}),$F$79,0))","v":0.02},0.02,0.02,{"$f":"OR(F66={1,2})*$F$78+OR(F66={3,4})*$F$79","v":0.02}]
[null,{"$f":"ROW()","v":67},"Kristian",null,24500,4,null,null,null,0.05,{"$f":"IF(OR(F67={1,2}),$F$78,IF(OR(F67={3,4}),$F$79,0))","v":0.05},0.05,0.05,{"$f":"OR(F67={1,2})*$F$78+OR(F67={3,4})*$F$79","v":0.05}]
[null,{"$f":"ROW()","v":68},"Hanne",null,32100,4,null,null,null,0.05,{"$f":"IF(OR(F68={1,2}),$F$78,IF(OR(F68={3,4}),$F$79,0))","v":0.05},0.05,0.05,{"$f":"OR(F68={1,2})*$F$78+OR(F68={3,4})*$F$79","v":0.05}]
[null,{"$f":"ROW()","v":69},"Erik",null,34000,3,null,null,null,0.05,{"$f":"IF(OR(F69={1,2}),$F$78,IF(OR(F69={3,4}),$F$79,0))","v":0.05},0.05,0.05,{"$f":"OR(F69={1,2})*$F$78+OR(F69={3,4})*$F$79","v":0.05}]
[null,{"$f":"ROW()","v":70},"Frank",null,28950,0,null,null,null,0,{"$f":"IF(OR(F70={1,2}),$F$78,IF(OR(F70={3,4}),$F$79,0))","v":0},0,0,{"$f":"OR(F70={1,2})*$F$78+OR(F70={3,4})*$F$79","v":0}]
[null,{"$f":"ROW()","v":71},"Grethe",null,31000,4,null,null,null,0.05,{"$f":"IF(OR(F71={1,2}),$F$78,IF(OR(F71={3,4}),$F$79,0))","v":0.05},0.05,0.05,{"$f":"OR(F71={1,2})*$F$78+OR(F71={3,4})*$F$79","v":0.05}]
[null,{"$f":"ROW()","v":72},"Ulla",null,19980,2,null,null,null,0.02,{"$f":"IF(OR(F72={1,2}),$F$78,IF(OR(F72={3,4}),$F$79,0))","v":0.02},0.02,0.02,{"$f":"OR(F72={1,2})*$F$78+OR(F72={3,4})*$F$79","v":0.02}]
[null,{"$f":"ROW()","v":73},"Jakob",null,27300,9,null,null,null,0,{"$f":"IF(OR(F73={1,2}),$F$78,IF(OR(F73={3,4}),$F$79,0))","v":0},0,0,{"$f":"OR(F73={1,2})*$F$78+OR(F73={3,4})*$F$79","v":0}]
[null,{"$f":"ROW()","v":74},"Svend",null,27000,1,null,null,null,0.02,{"$f":"IF(OR(F74={1,2}),$F$78,IF(OR(F74={3,4}),$F$79,0))","v":0.02},0.02,0.02,{"$f":"OR(F74={1,2})*$F$78+OR(F74={3,4})*$F$79","v":0.02}]
[null,{"$f":"ROW()","v":75},"Total"]
[]
[]
[null,"Job-kode 1 eller 2, forhøjelse",null,null,null,0.02," af gage"]
[null,"Job-kode 3 eller 4, forhøjelse",null,null,null,0.05," af gage"]
[null,"Job-kode forskellig fra 1, 2, 3 eller 4",null,null,null,0," af gage"]
[]
[null,"Lav en formel der beregner forhøjelse (i procent) og ny gage samt total."]
[]
[]
[null,"Sæt x hvis du ønsker hjælp?"]
[]
[]
[]
[]
[null,"BMI"]
[null," "]
[null,"BMI  er forkortelsen for  "]
[null,"Body Mass Index  -  kropsmasseindeks."]
[]
[null,"BMI angiver forholdet mellem",null,null,null,"For en person med en vis højde forhøjes BMI,"]
[null,"vægt og højde ifølge",null,null,null,"når vægten stiger."]
[null,"beregningen:",null,null,null,"I litteraturen findes der forskellige grænse-"]
[null,null,null,null,null,"værdier for, hvad der betragtes som overvægt."]
[null,null,null,null,null,"Nedenstående tabel viser de grænseværdier, "]
[null,null,null,null,null,"som WHO angav i 1985."]
[]
[null,null,null,null,null,"Vægtklasse",null,"Mand","Kvinde"]
[null,null,null,null,null,"Undervægtig",null,"<20","<18,6"]
[null,null,null,null,null,"Normalvægtig ",null,"20,0-25,0","18,6-23,8"]
[null,null,null,null,null,"Overvægtig",null,"25,0-30,0","23,8-28,6"]
[null,null,null,null,null,"Stærkt overvægtig",null,">30",">28,6"]
[]
[null,null,null,null,null,"Når BMI stiger til en værdi på over 25, vil det "]
[null,null,null,null,null,"normalt være udtryk for, at ens fedtdepoter er"]
[null,null,null,null,null,"så store at det har sundhedsmæssig betydning."]
[null,null,null,null,null,"Jo mere BMI overstiger denne grænse, jo"]
[null,null,null,null,null,"større negativ Indflydelse vil det have på sund-"]
[null,null,null,null,null,"hedstilstanden."]
[]
[null,"Prøv at lave en model, hvor du laver plads til indtastning af vægt (i kg) og højde "]
[null,"(i centimeter) og endelig til at angive, om det drejer sig om en mand eller en kvinde"]
[null,"I en tom celle skal du nu udregne BMI (med 1 decimal) i overensstemmelse med"]
[null,"formlen ovenfor. I en anden tom celle bruger du en funktion til at returnere en af"]
[null,{"$f":"\"teksterne i \"&mycell(F103)&\":\"&mycell(F106)&\", altså Undervægtig, Normalvægtig, Overvægtig eller Stærkt\"","v":"teksterne i F103:F106, altså Undervægtig, Normalvægtig, Overvægtig eller Stærkt"}]
[null,"overvægtig afhængig af BMI-tallet og afhængig af køn."]
[]
[null,"•  Beregn BMI for en mand på 87 kg med en højde på 170 cm."]
[null,"•  En 165 cm høj kvinde vejer 68 kg. Find hendes BMI og angiv hendes vægtklasse."]
[null,"   Hvor meget skal kvinden tabe sig for at være normalvægtig?"]
[null,"•  Prøv om du kan lave en formel, som selv udregner vægt, når du indtaster højde"]
[null,"   og ønsket BMI."]
[]
[]
[]
[]
[null,"Hvis du ønsker hjælp - sæt x her"]
[]
[null,"Køn",null,"Kvinde"]
[null,"Vægt, kg",null,68]
[null,"Højde, cm",null,165]
[]
[]
[null,"BMI",null,{"$f":"D134/(D135/100)^2","v":24.977043158861342},null,{"$f":"IF(D133=E142,INDEX(B143:B146,MATCH(D138,E143:E146,1)),INDEX(B143:B146,MATCH(D138,D143:D146,1)))","v":"Overvægtig"}]
[]
[]
[]
[null,"Vægtklasse",null,"Mand","Kvinde"]
[null,"Undervægtig",null,0,0]
[null,"Normalvægtig ",null,20,18.600000000000001]
[null,"Overvægtig",null,25,23.8]
[null,"Stærkt overvægtig",null,30,28.6]
[]
[]
[]
[]
[null,"Befordringsfradrag",null,null,null,"(Forældet)"]
[]
[null,"Herunder ser du gældende regler for befordringsfradrag."]
[null,{"$f":"\"Det er din opgave at lave en formel i celle \"&mycell(O174)&\" der udregner det korrekte fradrag, baseret på oplysningerne\"","v":"Det er din opgave at lave en formel i celle O174 der udregner det korrekte fradrag, baseret på oplysningerne"}]
[null,{"$f":"\"i cellerne \"&mycell(O158)&\":\"&mycell(O161)&\" og \"&mycell(O164)&\":\"&mycell(O165)&\". Læg i øvrigt mærke til, at disse celler kun indeholder tal.\"","v":"i cellerne O158:O161 og O164:O165. Læg i øvrigt mærke til, at disse celler kun indeholder tal."}]
[null,"Der ses bort fra reglerne om udkantskommuner."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Undergrænse",null,24]
[null,null,null,null,null,null,null,null,null,null,null,null,"Grænse for højeste sats",null,100]
[null,null,null,null,null,null,null,null,null,null,null,null,"Fradrag 24-100 km",null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,"Fradrag 0ver 100 km",null,1]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Kørte km pr. dag",null,100]
[null,null,null,null,null,null,null,null,null,null,null,null,"Antal arbejdsdage",null,200]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Fradrag"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Fradrag "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Sæt x for hjælp"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Fradrag",null,{"$f":"MAX(0,MIN((O164-O158)*2,(O159-O158)*O160+(O164-O159)*O161))","v":152}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Fradrag ",null,{"$f":"IF(O164<O158,0,IF(O164<100,(O164-O158)*O160,(O159-O158)*2+(O164-O159)*O161))","v":152}]
[]
[]
[]
[]
[null,"Flere OG-betingelser"]
[]
[]
[null,{"$f":"CHAR(COLUMN()+64)","v":"B"},{"$f":"CHAR(COLUMN()+64)","v":"C"},{"$f":"CHAR(COLUMN()+64)","v":"D"},"E",null,{"$f":"\"Lav en formel i celle \"&mycell(E184)&\" under følgende betingelser:\"","v":"Lav en formel i celle E184 under følgende betingelser:"}]
[null,{"$f":"ROW()","v":184},1,11,null,null,{"$f":"\"Hvis \"&mycell(C184)&\" > 0 og \"&mycell(D184)&\" >0 så skal \"&mycell(E184)&\" være lig med 10\"","v":"Hvis C184 > 0 og D184 >0 så skal E184 være lig med 10"}]
[null,{"$f":"ROW()","v":185},2,-12,null,null,{"$f":"\"Hvis\" &mycell(C184)&\" > 0 og \"&mycell(D184)&\" <0 så skal \"&mycell(E184)&\" være lig med 20\"","v":"HvisC184 > 0 og D184 <0 så skal E184 være lig med 20"}]
[null,{"$f":"ROW()","v":186},-5,12,null,null,{"$f":"\"Hvis \"&mycell(C184)&\" < 0 og \"&mycell(D184)&\" >0 så skal \"&mycell(E184)&\" være lig med 30\"","v":"Hvis C184 < 0 og D184 >0 så skal E184 være lig med 30"}]
[null,{"$f":"ROW()","v":187},-1,-1,null,null,{"$f":"\"Hvis \"&mycell(C184)&\" < 0 og \"&mycell(D184)&\" <0 så skal \"&mycell(E184)&\" være lig med 40\"","v":"Hvis C184 < 0 og D184 <0 så skal E184 være lig med 40"}]
[]
[null,null,null,null,null,null,{"$f":"\"Kopier formlen ned til celle \"&mycell(E187)&\".\"","v":"Kopier formlen ned til celle E187."}]
[]
[]
[null,"Sæt x for hjælp"]
[]
[null,{"$f":"CHAR(COLUMN()+64)","v":"B"},{"$f":"CHAR(COLUMN()+64)","v":"C"},{"$f":"CHAR(COLUMN()+64)","v":"D"},{"$f":"CHAR(COLUMN()+64)","v":"E"},{"$f":"CHAR(COLUMN()+64)","v":"F"}]
[null,{"$f":"ROW()","v":195},1,11,{"$f":"IF(AND(C195>0,D195>0),10,IF(AND(C195>0,D195<0),20,IF(AND(C195<0,D195>0),30,IF(AND(C195<0,D195<0),40))))","v":10},{"$f":"10*(BIN2DEC(N(C195<0)&N(D195<0))+1)","v":10}]
[null,{"$f":"ROW()","v":196},2,-12,{"$f":"IF(AND(C196>0,D196>0),10,IF(AND(C196>0,D196<0),20,IF(AND(C196<0,D196>0),30,IF(AND(C196<0,D196<0),40))))","v":20},{"$f":"10*(BIN2DEC(N(C196<0)&N(D196<0))+1)","v":20}]
[null,{"$f":"ROW()","v":197},-5,12,30,30]
[null,{"$f":"ROW()","v":198},-1,-1,40,40]
[]
[]
[]
[]
[null,"Minimum/Maksimum"]
[null,{"$f":"\"Lav en formel der på baggrund af et tal i celle \"&mycell(C207)&\" ganger det med 0,15, returnerer\"","v":"Lav en formel der på baggrund af et tal i celle C207 ganger det med 0,15, returnerer"}]
[null,"resultatet med et minimum på 200 og et maksimum på 400."]
[]
[null,null,3000,null,null,{"$f":"IF(C207*0.15<200,200,IF(C207*0.15>400,400,C207*0.15))","v":400}]
[null,null,null,null,null,{"$f":"MIN(MAX(C207*0.15,200),400)","v":400}]
[]
[]
[null,"Sæt x for hjælp",null,"x"]
[]
[]
[]
[]
[null,"Generer en af flere tabeller"]
[null,{"$f":"\"I celle \"&mycell(E232)&\" er der en Drop Down boks hvor du kan vælge mellem Ingen, Table1\"","v":"I celle E232 er der en Drop Down boks hvor du kan vælge mellem Ingen, Table1"}]
[null,"og Table2. Prøv de forskellige valgmuligheder."]
[]
[null,null,{"$f":"CHAR(COLUMN()+64)","v":"C"},"D","E","F","G","H"]
[]
[null,{"$f":"ROW()","v":222},null,"Table1 ",null,null,"Table2"]
[null,{"$f":"ROW()","v":223},null,"Tekst1","Tal1",null,"Tekst2","Tal21"]
[null,{"$f":"ROW()","v":224},null,"A",1,null,"p",111]
[null,{"$f":"ROW()","v":225},null,"B",2,null,"q",222]
[null,{"$f":"ROW()","v":226},null,"C",3,null,"r",333]
[null,{"$f":"ROW()","v":227},null,"D",4,null,"s",444]
[null,{"$f":"ROW()","v":228},null,"E",5,null,"t",555]
[null,{"$f":"ROW()","v":229}]
[null,{"$f":"ROW()","v":230}]
[null,{"$f":"ROW()","v":231}]
[null,{"$f":"ROW()","v":232},null,"Vis","Ingen",null,"Hvis du har lyst, kan du "]
[null,{"$f":"ROW()","v":233},null,null,null,null,"prøve at bruge betinget"]
[null,{"$f":"ROW()","v":234},null,{"$f":"IF(E232=\"Table1\",INDEX(Table1[],,),IF(E232=\"Table2\",INDEX(Table2[],,),\"\"))","v":""},null,null,"formatering til at gengive"]
[null,{"$f":"ROW()","v":235},null,null,null,null,"samme formatering i "]
[null,{"$f":"ROW()","v":236},null,null,null,null,{"$f":"\"området \"&mycell(D234)&\":\"&mycell(E238)&\" som\"","v":"området D234:E238 som"}]
[null,{"$f":"ROW()","v":237},null,null,null,null,"vist i de oprindelige"]
[null,{"$f":"ROW()","v":238},null,null,null,null,"tabeller. Det kræver en "]
[null,{"$f":"ROW()","v":239},null,null,null,null,"hel del arbejde."]
[null,{"$f":"ROW()","v":240}]

{"sheet":"Opgaver","index":4,"n_rows":274,"n_cols":9,"rows_kept":274,"cut":false,"hidden":false,"merged":[[138,3,138,4],[218,5,218,7]]}
[]
[null,"Opgaver der involverer logiske (+ enkelte andre) funktioner"]
[]
[]
[null,null,{"$f":"CHAR(COLUMN()+64)","v":"C"},"D","E","F","G","H","I"]
[]
[null,{"$f":"ROW()","v":7}]
[null,{"$f":"ROW()","v":8},1,"Jeg har regneark, hvor noget køb og salg ender ud i gevinst/tab i kolonne D. I kolonne"]
[null,{"$f":"ROW()","v":9},null,"E vil jeg gerne summere kolonne D løbende sammen, men ønsker kun der står tal"]
[null,{"$f":"ROW()","v":10},null,"løbende i kolonne E efterhånden som gevinst/tab bliver lagt ind. Er der en som har en"]
[null,{"$f":"ROW()","v":11},null,"løsning?"]
[null,{"$f":"ROW()","v":12}]
[null,{"$f":"ROW()","v":13}]
[null,{"$f":"ROW()","v":14},null,"Gevinst/Tab","Resultat"]
[{"$f":"IF(D15<>\"\",SUM(D$15:D15),\"\")","v":13765},{"$f":"ROW()","v":15},null,13765,null,null,null,{"$f":"IF(D15<>\"\",SUM(D$15:D15),\"\")","v":13765},{"$f":"IF($D15=\"\",\"\",SUM(OFFSET($D$15,,,COUNT($D$15:D15))))","v":13765}]
[{"$f":"IF(D16<>\"\",SUM(D$15:D16),\"\")","v":1912},{"$f":"ROW()","v":16},null,-11853,null,null,null,{"$f":"IF(D16<>\"\",SUM(D$15:D16),\"\")","v":1912},{"$f":"IF($D16=\"\",\"\",SUM(OFFSET($D$15,,,COUNT($D$15:D16))))","v":1912}]
[{"$f":"IF(D17<>\"\",SUM(D$15:D17),\"\")","v":-9570},{"$f":"ROW()","v":17},null,-11482,null,null,null,{"$f":"IF(D17<>\"\",SUM(D$15:D17),\"\")","v":-9570},{"$f":"IF($D17=\"\",\"\",SUM(OFFSET($D$15,,,COUNT($D$15:D17))))","v":-9570}]
[null,{"$f":"ROW()","v":18},null,12037,null,null,null,{"$f":"IF(D18<>\"\",SUM(D$15:D18),\"\")","v":2467},{"$f":"IF($D18=\"\",\"\",SUM(OFFSET($D$15,,,COUNT($D$15:D18))))","v":2467}]
[null,{"$f":"ROW()","v":19},null,null,null,null,null,{"$f":"IF(D19<>\"\",SUM(D$15:D19),\"\")","v":""},{"$f":"IF($D19=\"\",\"\",SUM(OFFSET($D$15,,,COUNT($D$15:D19))))","v":""}]
[null,{"$f":"ROW()","v":20},null,null,null,null,null,{"$f":"IF(D20<>\"\",SUM(D$15:D20),\"\")","v":""},{"$f":"IF($D20=\"\",\"\",SUM(OFFSET($D$15,,,COUNT($D$15:D20))))","v":""}]
[null,{"$f":"ROW()","v":21},null,null,null,null,null,{"$f":"IF(D21<>\"\",SUM(D$15:D21),\"\")","v":""},{"$f":"IF($D21=\"\",\"\",SUM(OFFSET($D$15,,,COUNT($D$15:D21))))","v":""}]
[null,{"$f":"ROW()","v":22},null,null,null,null,null,{"$f":"IF(D22<>\"\",SUM(D$15:D22),\"\")","v":""},{"$f":"IF($D22=\"\",\"\",SUM(OFFSET($D$15,,,COUNT($D$15:D22))))","v":""}]
[null,{"$f":"ROW()","v":23},null,null,null,null,null,{"$f":"IF(D23<>\"\",SUM(D$15:D23),\"\")","v":""},{"$f":"IF($D23=\"\",\"\",SUM(OFFSET($D$15,,,COUNT($D$15:D23))))","v":""}]
[null,{"$f":"ROW()","v":24},null,null,{"$f":"IF(D24<>\"\",SUM(D$15:D24),\"\")","v":""}]
[null,{"$f":"ROW()","v":25}]
[null,{"$f":"ROW()","v":26},null,null,{"$f":"IF(D26<>\"\",SUM(D$15:D26),\"\")","v":""},"Sæt x for hjælp"]
[null,{"$f":"ROW()","v":27},null,null,{"$f":"IF(D27<>\"\",SUM(D$15:D27),\"\")","v":""}]
[null,{"$f":"ROW()","v":28},null,null,{"$f":"IF(D28<>\"\",SUM(D$15:D28),\"\")","v":""}]
[null,{"$f":"ROW()","v":29}]
[null,{"$f":"ROW()","v":30}]
[null,{"$f":"ROW()","v":31},{"$f":"C8+1","v":2},"Mit problem er, at jeg gerne have Excel til (ved at bruge HVIS funktionen) at svare "]
[null,{"$f":"ROW()","v":32},null,"henholdsvis \"OK\" eller \"UMULIGT\" når den læser tallet i en celle."]
[null,{"$f":"ROW()","v":33},null,{"$f":"\"HVIS tallet i celle \"&mycell(D36)&\" IKKE er et kommatal skal formlen i celle \"&mycell(G36)&\" svare \"\"OK\"\"\"","v":"HVIS tallet i celle D36 IKKE er et kommatal skal formlen i celle G36 svare \"OK\""}]
[null,{"$f":"ROW()","v":34},null,{"$f":"\"HVIS tallet i celle \"&mycell(D36)&\" er et kommatal skal formlen i celle \"&mycell(G36)&\" svare \"\"UMULIGT\"\"\"","v":"HVIS tallet i celle D36 er et kommatal skal formlen i celle G36 svare \"UMULIGT\""}]
[null,{"$f":"ROW()","v":35}]
[null,{"$f":"ROW()","v":36}]
[null,{"$f":"ROW()","v":37}]
[null,{"$f":"ROW()","v":38}]
[null,{"$f":"ROW()","v":39}]
[null,{"$f":"ROW()","v":40},null,"Sæt x for hjælp",null,null,null,{"$f":"IF(MOD(D36,1)<>0,\"UMULIGT\",\"OK\")","v":"OK"}]
[null,{"$f":"ROW()","v":41}]
[null,{"$f":"ROW()","v":42}]
[null,{"$f":"ROW()","v":43},null,{"$f":"IF(F58<>\"x\",\"\",\"Hvis ikke du kender funktionen MOD (REST på dansk), så se nærmere i Excels hjælp.\")","v":""}]
[null,{"$f":"ROW()","v":44}]
[null,{"$f":"ROW()","v":45}]
[null,{"$f":"ROW()","v":46}]
[null,{"$f":"ROW()","v":47},{"$f":"C31+1","v":3},{"$f":"\"Jeg skal lave en formel i celle \"&mycell(H53)&\", hvor det skal gælde at:\"","v":"Jeg skal lave en formel i celle H53, hvor det skal gælde at:"}]
[null,{"$f":"ROW()","v":48},null,{"$f":"\"Hvis både cellerne \"&mycell(D53)&\" og \"&mycell(F53)&\" er tomme, så skal celle \"&mycell(H56)&\" være tom, men hvis ENTEN \"&mycell(D53)","v":"Hvis både cellerne D53 og F53 er tomme, så skal celle H56 være tom, men hvis ENTEN D53"}]
[null,{"$f":"ROW()","v":49},null,{"$f":"\"ELLER \"&mycell(F53)&\" indeholder en tal-værdi, så skal \"&mycell(H56)&\" vise resultatet af formlen \"&mycell(D53)&\" - \"&mycell(F53)&\".\"","v":"ELLER F53 indeholder en tal-værdi, så skal H56 vise resultatet af formlen D53 - F53."}]
[null,{"$f":"ROW()","v":50},null,"Hvordan ser sådan en formel ud"]
[null,{"$f":"ROW()","v":51}]
[null,{"$f":"ROW()","v":52}]
[null,{"$f":"ROW()","v":53},null,45,null,12]
[null,{"$f":"ROW()","v":54}]
[null,{"$f":"ROW()","v":55}]
[null,{"$f":"ROW()","v":56},null,null,null,null,null,{"$f":"IF(AND(ISBLANK(D53),ISBLANK(F53)),\"\",D53-F53)","v":33},"Én måde."]
[null,{"$f":"ROW()","v":57},null,null,null,null,null,{"$f":"IF(OR(NOT(ISBLANK(D53)),NOT(ISBLANK(F53))),D53-F53,\"\")","v":33},"En anden måde."]
[null,{"$f":"ROW()","v":58},null,"Sæt x for hjælp",null,null,null,{"$f":"IF(OR(D53 <> 0, F53 <> 0), D53-F53,\"\")","v":33},"En trejde måde."]
[null,{"$f":"ROW()","v":59}]
[null,{"$f":"ROW()","v":60}]
[null,{"$f":"ROW()","v":61}]
[null,{"$f":"ROW()","v":62}]
[null,{"$f":"ROW()","v":63},{"$f":"C47+1","v":4},"Hvis afsætning er under 400, skal prisen være 3."]
[null,{"$f":"ROW()","v":64},null,"Hvis afsætningen er mellem 400-600, skal prisen være 2."]
[null,{"$f":"ROW()","v":65},null,"Hvis afsætningen er over 600, skal prisen være 1."]
[null,{"$f":"ROW()","v":66}]
[null,{"$f":"ROW()","v":67},null,"Afsætning",null,"Pris"]
[null,{"$f":"ROW()","v":68},null,100,null,null,null,{"$f":"IF(D68 > 600, 1, IF(D68 >= 400, 2, IF(D68 > 0,3,\"\")))","v":3}]
[null,{"$f":"ROW()","v":69},null,null,null,null,null,{"$f":"IF(D68 > 0,  IF(D68 >= 400,  IF(D68 > 600,1,2),3),\"\")","v":3}]
[null,{"$f":"ROW()","v":70}]
[null,{"$f":"ROW()","v":71},null,"Sæt x for hjælp"]
[null,{"$f":"ROW()","v":72}]
[null,{"$f":"ROW()","v":73}]
[null,{"$f":"ROW()","v":74}]
[null,{"$f":"ROW()","v":75}]
[null,{"$f":"ROW()","v":76},{"$f":"C63+1","v":5},"Jeg skal returnere en tekst hvis et givent felt indeholder et tal indenfor et vist område."]
[null,{"$f":"ROW()","v":77}]
[null,{"$f":"ROW()","v":78},null,"Eksempel:"]
[null,{"$f":"ROW()","v":79},null,"I en celle skal returneres teksten FEJL I NR. hvis tallet i en anden celle ikke er mellem"]
[null,{"$f":"ROW()","v":80},null,"4 og 8 eller mellem 12 og 24"]
[null,{"$f":"ROW()","v":81}]
[null,{"$f":"ROW()","v":82},null,"Celle",null,"Tekst"]
[null,{"$f":"ROW()","v":83},null,9]
[null,{"$f":"ROW()","v":84}]
[null,{"$f":"ROW()","v":85}]
[null,{"$f":"ROW()","v":86},null,"Sæt x for hjælp",null,null,null,{"$f":"IF((D83>=4)*(D83<=8)+(D83>=12)*(D83<=24),\"\",\"FEJL I NR.\")","v":"FEJL I NR."}]
[null,{"$f":"ROW()","v":87}]
[null,{"$f":"ROW()","v":88}]
[null,{"$f":"ROW()","v":89}]
[null,{"$f":"ROW()","v":90}]
[null,{"$f":"ROW()","v":91},{"$f":"C76+1","v":6},"Jeg har to celler (en Ja og en Nej celle) i et Excelark. Brugeren skal indtaste et "]
[null,{"$f":"ROW()","v":92},null,"x i enten Ja eller Nej. Der er ingen restriktioner på felterne, så både mulige og"]
[null,{"$f":"ROW()","v":93},null,"umulige kombinationer kan optræde. Resultatet i en tredje celle skal afspejle"]
[null,{"$f":"ROW()","v":94},null,"indtastningen."]
[null,{"$f":"ROW()","v":95}]
[null,{"$f":"ROW()","v":96},null,"Ja: x  Nej:    Resultat: 1"]
[null,{"$f":"ROW()","v":97},null,"Ja: x  Nej: x  Resultat: ."]
[null,{"$f":"ROW()","v":98},null,"Ja:    Nej: x  Resultat: 0"]
[null,{"$f":"ROW()","v":99},null,"Ja:    Nej:    Resultat: ."]
[null,{"$f":"ROW()","v":100}]
[null,{"$f":"ROW()","v":101},null,"Kan man med en fler-ledet HVIS-sætning lavet dette?"]
[null,{"$f":"ROW()","v":102}]
[null,{"$f":"ROW()","v":103},null,"JA","NEJ","Resultat"]
[null,{"$f":"ROW()","v":104},null,"x",null,null,null,{"$f":"IF((D104=\"x\")*(E104<>\"x\"),1,IF((D104=\"x\")*(E104=\"x\")+(D104<>\"x\")*(E104<>\"x\"),\".\",0))","v":1}]
[null,{"$f":"ROW()","v":105},null,"x","x",null,null,"."]
[null,{"$f":"ROW()","v":106},null,null,"x",null,null,0]
[null,{"$f":"ROW()","v":107},null,null,null,null,null,{"$f":"IF((D107=\"x\")*(E107<>\"x\"),1,IF((D107=\"x\")*(E107=\"x\")+(D107<>\"x\")*(E107<>\"x\"),\".\",0))","v":"."}]
[null,{"$f":"ROW()","v":108}]
[null,{"$f":"ROW()","v":109}]
[null,{"$f":"ROW()","v":110},null,"Sæt x for hjælp"]
[null,{"$f":"ROW()","v":111}]
[null,{"$f":"ROW()","v":112}]
[null,{"$f":"ROW()","v":113}]
[null,{"$f":"ROW()","v":114},{"$f":"C91+1","v":7},"Jeg har en timeseddel, og skal have beregnet overtid, når ugen er gået."]
[null,{"$f":"ROW()","v":115},null,"Følgende skal være opfyldt:"]
[null,{"$f":"ROW()","v":116}]
[null,{"$f":"ROW()","v":117},null,"1) Antal timer alle ugens 5 dage skal være 7,5"]
[null,{"$f":"ROW()","v":118},null,"2) Antal normaltimer i en uge skal være 37,5"]
[null,{"$f":"ROW()","v":119},null,"Overtid skal beregnes for hver dag, når begge betingelser er opfyldt"]
[null,{"$f":"ROW()","v":120},null,"og meget gerne en total i slut."]
[null,{"$f":"ROW()","v":121}]
[null,{"$f":"ROW()","v":122},null,"Dag","Arbejdstid","Overtid",null,"Overtid"]
[null,{"$f":"ROW()","v":123},null,"Mandag",7.5,null,null,{"$f":"IF(AND(E123>7.5,$E$128>37.5),E123-7.5,0)","v":0}]
[null,{"$f":"ROW()","v":124},null,"Tirsdag",8,null,null,{"$f":"IF(AND(E124>7.5,$E$128>37.5),E124-7.5,0)","v":0.5}]
[null,{"$f":"ROW()","v":125},null,"Onsdag",8,null,null,{"$f":"IF(AND(E125>7.5,$E$128>37.5),E125-7.5,0)","v":0.5}]
[null,{"$f":"ROW()","v":126},null,"Torsdag",8,null,null,{"$f":"IF(AND(E126>7.5,$E$128>37.5),E126-7.5,0)","v":0.5}]
[null,{"$f":"ROW()","v":127},null,"Fredag",7.5,null,null,{"$f":"IF(AND(E127>7.5,$E$128>37.5),E127-7.5,0)","v":0}]
[null,{"$f":"ROW()","v":128},null,null,{"$f":"SUM(E123:E127)","v":39},null,null,{"$f":"SUM(H123:H127)","v":1.5}]
[null,{"$f":"ROW()","v":129}]
[null,{"$f":"ROW()","v":130},null,"Sæt x for hjælp"]
[null,{"$f":"ROW()","v":131}]
[null,{"$f":"ROW()","v":132}]
[null,{"$f":"ROW()","v":133}]
[null,{"$f":"ROW()","v":134}]
[null,{"$f":"ROW()","v":135}]
[null,{"$f":"ROW()","v":136}]
[null,{"$f":"ROW()","v":137},{"$f":"C114+1","v":8},{"$f":"\"Kan jeg bruge joker tegn som ? * ~ i formler? For eksempel: =HVIS(\"&mycell(D139)&\"=\"\"*K\"\";3;\"\"\"\")\"","v":"Kan jeg bruge joker tegn som ? * ~ i formler? For eksempel: =HVIS(D139=\"*K\";3;\"\")"}]
[null,{"$f":"ROW()","v":138}]
[null,{"$f":"ROW()","v":139},null," MH0601NK",null,null,null,null,{"$f":"IF(COUNTIF(D139,\"*K\"),3,\"\")","v":3}]
[null,{"$f":"ROW()","v":140},null,null,null,null,null,null,{"$f":"ISNUMBER(SEARCH(\"*K\",D139))*3","v":3}]
[null,{"$f":"ROW()","v":141}]
[null,{"$f":"ROW()","v":142}]
[null,{"$f":"ROW()","v":143},null,"Sæt x for hjælp"]
[null,{"$f":"ROW()","v":144}]
[null,{"$f":"ROW()","v":145}]
[null,{"$f":"ROW()","v":146}]
[null,{"$f":"ROW()","v":147}]
[null,{"$f":"ROW()","v":148},null,{"$f":"\"Situationen er, jeg har \"&mycell(D151)&\" som indeholder et procenttal\"","v":"Situationen er, jeg har D151 som indeholder et procenttal"}]
[null,{"$f":"ROW()","v":149}]
[null,{"$f":"ROW()","v":150}]
[null,{"$f":"ROW()","v":151},null,0.89]
[null,{"$f":"ROW()","v":152}]
[null,{"$f":"ROW()","v":153}]
[null,{"$f":"ROW()","v":154},null,{"$f":"\"Formeln i celle \"&mycell(F151)&\" skal kunne fortælle:\"","v":"Formeln i celle F151 skal kunne fortælle:"}]
[null,{"$f":"ROW()","v":155}]
[null,{"$f":"ROW()","v":156},null,{"$f":"\"Celle \"&mycell($D$151)&\" > 90% = 1000\"","v":"Celle D151 > 90% = 1000"},null,null,{"$f":"IF(D151<=90%,0,IF(D151>90%,IF(D151>100%,IF(D151>110%,2500,1500),1000)))","v":0}]
[null,{"$f":"ROW()","v":157},null,{"$f":"\"Celle \"&mycell($D$151)&\" > 100% = 1500\"","v":"Celle D151 > 100% = 1500"},null,null,{"$f":"IF(D151>90%,IF(D151>100%,IF(D151>110%,2500,1500),1000),0)","v":0}]
[null,{"$f":"ROW()","v":158},null,{"$f":"\"Celle \"&mycell($D$151)&\" > 110% = 2500\"","v":"Celle D151 > 110% = 2500"},null,null,{"$f":"LOOKUP(D151,{0;0.9;1;1.1},{0;1000;1500;2500})","v":0}]
[null,{"$f":"ROW()","v":159}]
[null,{"$f":"ROW()","v":160},null,"Sæt x for hjælp"]
[null,{"$f":"ROW()","v":161}]
[null,{"$f":"ROW()","v":162}]
[null,{"$f":"ROW()","v":163}]
[null,{"$f":"ROW()","v":164}]
[null,{"$f":"ROW()","v":165},{"$f":"C137+1","v":9},"Jeg skal bruge en funktion, der hvis klokken er mellem 00:01 og 12:00 viser \"formiddag\". "]
[null,{"$f":"ROW()","v":166},null,"Hvis klokken er mellem 12:01 og 00:00 skal den vise \"eftermiddag\"."]
[null,{"$f":"ROW()","v":167}]
[null,{"$f":"ROW()","v":168},null,"00:01:00",null,null,null,{"$f":"IF(MOD(D168,1)<0.5,\"formiddag\",\"eftermiddag\")","v":"formiddag"}]
[null,{"$f":"ROW()","v":169}]
[null,{"$f":"ROW()","v":170}]
[null,{"$f":"ROW()","v":171},null,"Sæt x for hjælp"]
[null,{"$f":"ROW()","v":172}]
[null,{"$f":"ROW()","v":173}]
[null,{"$f":"ROW()","v":174}]
[null,{"$f":"ROW()","v":175},{"$f":"C165+1","v":10},{"$f":"\"Jeg bruger følgende formel til udregning af timer i en vagtplan =(\"&mycell(E181)&\">\"&mycell(F181)&\"+\"&mycell(F181)&\"-\"&mycell(E181)&\")\"","v":"Jeg bruger følgende formel til udregning af timer i en vagtplan =(E181>F181+F181-E181)"}]
[null,{"$f":"ROW()","v":176},null,{"$f":"mycell(D181)&\"= Ugedag, \"&mycell(E181) &\"= Starttid, \"&mycell(F181)&\"= Sluttid og \"&mycell(G181)&\" indeholder ovenstående formel.\"","v":"D181= Ugedag, E181= Starttid, F181= Sluttid og G181 indeholder ovenstående formel."}]
[null,{"$f":"ROW()","v":177},null,{"$f":"\"Jeg kunne godt bruge en formel, som hvis der står lørdag eller søndag i \"&mycell(D181)&\" ganger\"","v":"Jeg kunne godt bruge en formel, som hvis der står lørdag eller søndag i D181 ganger"}]
[null,{"$f":"ROW()","v":178},null,{"$f":"\"resultatet i \"&mycell(G181)&\" (antal timer) med 1,75. Indtast formlen i celle \"&mycell(H181)&\".\"","v":"resultatet i G181 (antal timer) med 1,75. Indtast formlen i celle H181."}]
[null,{"$f":"ROW()","v":179}]
[null,{"$f":"ROW()","v":180},null,"Ugedag","Starttid","Sluttid","Antal timer","Korr. # timer"]
[null,{"$f":"ROW()","v":181},null,"Søndag","08:00:00","16:00:00",{"$f":"(E181>F181)+F181-E181","v":"08:00:00"}]
[null,{"$f":"ROW()","v":182}]
[null,{"$f":"ROW()","v":183}]
[null,{"$f":"ROW()","v":184},null,null,null,null,null,{"$f":"OR(D181={\"Lørdag\",\"Søndag\"})*G181*1.75+AND(D181<>{\"Lørdag\",\"Søndag\"})*G181","v":"14:00:00"}]
[null,{"$f":"ROW()","v":185}]
[null,{"$f":"ROW()","v":186}]
[null,{"$f":"ROW()","v":187},null,"Sæt x for hjælp"]
[null,{"$f":"ROW()","v":188}]
[null,{"$f":"ROW()","v":189}]
[null,{"$f":"ROW()","v":190}]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"CHAR(COLUMN()+64)","v":"C"},"D","E","F","G","H"]
[null,{"$f":"ROW()","v":198},{"$f":"C175+1","v":11},"Hvis jeg f.eks. har 20 pakker, i hver kasse kan være 17 pakker."]
[null,{"$f":"ROW()","v":199},null,"de stidste \"løse\" skal være i en kasse for sig."]
[null,{"$f":"ROW()","v":200}]
[null,{"$f":"ROW()","v":201},null,"Kan man få Exccel til at lave beregningen, af fordelingen af antalet af hele "]
[null,{"$f":"ROW()","v":202},null,"kasser og hvor mange løse der evt. skal være i den sidste kasse."]
[null,{"$f":"ROW()","v":203}]
[null,{"$f":"ROW()","v":204},null,null,"Teksten skal være "]
[null,{"$f":"ROW()","v":205},null,"1 pakke","1 kasse med 1 løs"]
[null,{"$f":"ROW()","v":206},null,"2 pakker","1 kasse med 2 løse"]
[null,{"$f":"ROW()","v":207},null,"18 pakker","1 kasse med 17 og 1 kasse med 1 løs"]
[null,{"$f":"ROW()","v":208},null,"34 pakker","2 kasser med 17"]
[null,{"$f":"ROW()","v":209},null,"40 pakker","2 kasser med 17 og 1 kasse med 6 løse"]
[null,{"$f":"ROW()","v":210}]
[null,{"$f":"ROW()","v":211}]
[null,{"$f":"ROW()","v":212},null,"Antal pakker"]
[null,{"$f":"ROW()","v":213}]
[null,{"$f":"ROW()","v":214}]
[null,{"$f":"ROW()","v":215}]
[null,{"$f":"ROW()","v":216},null,"Sæt x for hjælp"]
[null,{"$f":"ROW()","v":217}]
[null,{"$f":"ROW()","v":218}]
[null,{"$f":"ROW()","v":219},null,null,null,{"$f":"IF(D213=\"\",\"\",IF(D213<=17,\"1 kasse med \" &D213&IF(D213=1,\" løs\",\" løse\"),INT(D213/17)&IF(INT(D213/17)>1,\" kasser med 17\",\" kasse med 17 \")&IF(MOD(D213,17)=0,\"\",\" og 1 kasse med \")&IF(MOD(D213,17)=0,\"\",MOD(D213,17))&IF(MOD(D213,17)=0,\"\",IF(MOD(D213,17)=1,\" løs\",\" løse\"))))","v":""}]
[null,{"$f":"ROW()","v":220}]
[null,{"$f":"ROW()","v":221}]
[null,{"$f":"ROW()","v":222}]
[null,{"$f":"ROW()","v":223},null,"Antal pakker","Tekst"]
[null,{"$f":"ROW()","v":224},null,1,{"$f":"IF(D224=\"\",\"\",IF(D224<=17,\"1 kasse med \" &D224&IF(D224=1,\" løs\",\" løse\"),INT(D224/17)&IF(INT(D224/17)>1,\" kasser med 17\",\" kasse med 17 \")&IF(MOD(D224,17)=0,\"\",\" og 1 kasse med \")&IF(MOD(D224,17)=0,\"\",MOD(D224,17))&IF(MOD(D224,17)=0,\"\",IF(MOD(D224,17)=1,\" løs\",\" løse\"))))","v":"1 kasse med 1 løs"}]
[null,{"$f":"ROW()","v":225},null,2,{"$f":"IF(D225=\"\",\"\",IF(D225<=17,\"1 kasse med \" &D225&IF(D225=1,\" løs\",\" løse\"),INT(D225/17)&IF(INT(D225/17)>1,\" kasser med 17\",\" kasse med 17 \")&IF(MOD(D225,17)=0,\"\",\" og 1 kasse med \")&IF(MOD(D225,17)=0,\"\",MOD(D225,17))&IF(MOD(D225,17)=0,\"\",IF(MOD(D225,17)=1,\" løs\",\" løse\"))))","v":"1 kasse med 2 løse"}]
[null,{"$f":"ROW()","v":226},null,3,"1 kasse med 3 løse"]
[null,{"$f":"ROW()","v":227},null,4,"1 kasse med 4 løse"]
[null,{"$f":"ROW()","v":228},null,5,"1 kasse med 5 løse"]
[null,{"$f":"ROW()","v":229},null,6,"1 kasse med 6 løse"]
[null,{"$f":"ROW()","v":230},null,7,"1 kasse med 7 løse"]
[null,{"$f":"ROW()","v":231},null,8,"1 kasse med 8 løse"]
[null,{"$f":"ROW()","v":232},null,9,"1 kasse med 9 løse"]
[null,{"$f":"ROW()","v":233},null,10,"1 kasse med 10 løse"]
[null,{"$f":"ROW()","v":234},null,11,"1 kasse med 11 løse"]
[null,{"$f":"ROW()","v":235},null,12,"1 kasse med 12 løse"]
[null,{"$f":"ROW()","v":236},null,13,"1 kasse med 13 løse"]
[null,{"$f":"ROW()","v":237},null,14,"1 kasse med 14 løse"]
[null,{"$f":"ROW()","v":238},null,15,"1 kasse med 15 løse"]
[null,{"$f":"ROW()","v":239},null,16,"1 kasse med 16 løse"]
[null,{"$f":"ROW()","v":240},null,17,"1 kasse med 17 løse"]
[null,{"$f":"ROW()","v":241},null,18,"1 kasse med 17  og 1 kasse med 1 løs"]
[null,{"$f":"ROW()","v":242},null,19,"1 kasse med 17  og 1 kasse med 2 løse"]
[null,{"$f":"ROW()","v":243},null,20,"1 kasse med 17  og 1 kasse med 3 løse"]
[null,{"$f":"ROW()","v":244},null,21,"1 kasse med 17  og 1 kasse med 4 løse"]
[null,{"$f":"ROW()","v":245},null,22,"1 kasse med 17  og 1 kasse med 5 løse"]
[null,{"$f":"ROW()","v":246},null,23,"1 kasse med 17  og 1 kasse med 6 løse"]
[null,{"$f":"ROW()","v":247},null,24,"1 kasse med 17  og 1 kasse med 7 løse"]
[null,{"$f":"ROW()","v":248},null,25,"1 kasse med 17  og 1 kasse med 8 løse"]
[null,{"$f":"ROW()","v":249},null,26,"1 kasse med 17  og 1 kasse med 9 løse"]
[null,{"$f":"ROW()","v":250},null,27,"1 kasse med 17  og 1 kasse med 10 løse"]
[null,{"$f":"ROW()","v":251},null,28,"1 kasse med 17  og 1 kasse med 11 løse"]
[null,{"$f":"ROW()","v":252},null,29,"1 kasse med 17  og 1 kasse med 12 løse"]
[null,{"$f":"ROW()","v":253},null,30,"1 kasse med 17  og 1 kasse med 13 løse"]
[null,{"$f":"ROW()","v":254},null,31,"1 kasse med 17  og 1 kasse med 14 løse"]
[null,{"$f":"ROW()","v":255},null,32,"1 kasse med 17  og 1 kasse med 15 løse"]
[null,{"$f":"ROW()","v":256},null,33,"1 kasse med 17  og 1 kasse med 16 løse"]
[null,{"$f":"ROW()","v":257},null,34,"2 kasser med 17"]
[null,{"$f":"ROW()","v":258},null,35,"2 kasser med 17 og 1 kasse med 1 løs"]
[null,{"$f":"ROW()","v":259},null,36,"2 kasser med 17 og 1 kasse med 2 løse"]
[null,{"$f":"ROW()","v":260},null,37,"2 kasser med 17 og 1 kasse med 3 løse"]
[null,{"$f":"ROW()","v":261},null,38,"2 kasser med 17 og 1 kasse med 4 løse"]
[null,{"$f":"ROW()","v":262},null,39,"2 kasser med 17 og 1 kasse med 5 løse"]
[null,{"$f":"ROW()","v":263},null,40,"2 kasser med 17 og 1 kasse med 6 løse"]
[null,{"$f":"ROW()","v":264},null,41,"2 kasser med 17 og 1 kasse med 7 løse"]
[null,{"$f":"ROW()","v":265},null,42,"2 kasser med 17 og 1 kasse med 8 løse"]
[null,{"$f":"ROW()","v":266},null,43,"2 kasser med 17 og 1 kasse med 9 løse"]
[null,{"$f":"ROW()","v":267},null,44,"2 kasser med 17 og 1 kasse med 10 løse"]
[null,{"$f":"ROW()","v":268},null,45,"2 kasser med 17 og 1 kasse med 11 løse"]
[null,{"$f":"ROW()","v":269},null,46,"2 kasser med 17 og 1 kasse med 12 løse"]
[null,{"$f":"ROW()","v":270},null,47,"2 kasser med 17 og 1 kasse med 13 løse"]
[null,{"$f":"ROW()","v":271},null,48,"2 kasser med 17 og 1 kasse med 14 løse"]
[null,{"$f":"ROW()","v":272},null,49,"2 kasser med 17 og 1 kasse med 15 løse"]
[null,{"$f":"ROW()","v":273},null,50,"2 kasser med 17 og 1 kasse med 16 løse"]
[null,{"$f":"ROW()","v":274},null,51,"3 kasser med 17"]

{"sheet":"Procentregning","index":5,"n_rows":255,"n_cols":21,"rows_kept":255,"cut":false,"hidden":false,"merged":[[53,6,53,7],[211,18,211,19],[236,17,236,19],[83,16,83,19],[80,20,80,23],[82,20,82,23],[84,20,84,23],[86,20,86,23]]}
[]
[null,"Vis brøkdele/procenter",null,null,null,"Hele arket her er mest for sjov."]
[]
[]
[]
[null,"a","b"]
[null,1,5,null,{"$f":"\"Prøv at eksperimentere med forskellige tal i celle \"&mycell(C7)&\".\"","v":"Prøv at eksperimentere med forskellige tal i celle C7."}]
[]
[null,{"$f":"B7&\"/\"&C7&\" =  \"&TEXT(B7/C7,\"#,00%\")","v":"1/5 =  20,00%"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Formler"]
[null,null,null,null,null,null,null,null,null,null,null,null,"a","(b-a)"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B7","v":1},{"$f":"ABS(B7-C7)","v":4}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"a/b er den blå del af cirklen. (b - a)/b er den røde del."]
[]
[]
[]
[]
[]
[]
[null,null,"Procent-beregner"]
[]
[null,null,"Procentberegninger falder i én af tre kategorier, typisk"]
[null,null,"formuleret som noget i retning af følgende:"]
[]
[null,null,"A","Hvad er x procent af y"]
[null,null,"B","x er hvilken procent af y"]
[null,null,"C","x er y procent af hvilket tal"]
[]
[null,null,{"$f":"\"Vælg celle \"&mycell(C49)&\" og vælg type (A, B eller C), indtast tal i\"","v":"Vælg celle C49 og vælg type (A, B eller C), indtast tal i"}]
[null,null,{"$f":"\"gule celler og se resultatet i række \"&ROW(54:54)&\".\"","v":"gule celler og se resultatet i række 54."}]
[]
[null,null,"Type"]
[null,null,"A"]
[]
[null,null,25,null,200]
[]
[]
[null,null,{"$f":"IF(C49=\"A\",\"Hvad er \"&C51&\" procent af \"&E51,IF(C49=\"B\",C51&\" er hvilken procent af \"&E51,IF(C49=\"C\",C51&\" er \"&E51&\" procent af \",\"\")))","v":"Hvad er 25 procent af 200"},null,null,null,{"$f":"IF(E51=0,\"\",IF(C49=\"A\",C51%*E51,IF(C49=\"B\",C51*100/E51,IF(C49=\"C\",C51*100/E51))))","v":50}]
[]
[null,null,"Hvis du har lyst, så prøv, uden først at kigge, at lave formler der"]
[null,null,{"$f":"\"genererer samme resultater som formlerne i \"&mycell(C54)&\" og \"&mycell(G54)&\".\"","v":"genererer samme resultater som formlerne i C54 og G54."}]
[]
[]
[]
[]
[]
[null,{"$f":"\"Undersøg i detaljer hvordan eksemplet fra række \"&ROW(73:73)&\" til række \"&ROW(99:99)&\" er opbygget, hvis\"","v":"Undersøg i detaljer hvordan eksemplet fra række 73 til række 99 er opbygget, hvis"}]
[null,"du ønsker en lektion i at kombinere tekst og formler. Læg mærke til at eksemplet"]
[null,"stadigvæk viser det korrekte (håber jeg), hvis du ændrer tallene i de gule celler, "]
[null,{"$f":"\"uanset om tallet i \"&mycell(F79)&\" er større end tallet i \"&mycell(H79)&\" eller omvendt.\"","v":"uanset om tallet i F79 er større end tallet i H79 eller omvendt."}]
[null,"Indrømmet - det er ekstremt det her, men faktisk har jeg haft en opgave i praksis,"]
[null,"(varmeregnskab), hvor der var brug for den her viste teknik, idet der automatisk skulle"]
[null,"skrives en meddelelse til forbrugerne, hvor teksten var afhængig af, om deres aconto-"]
[null,"betaling var større eller mindre en det der faktisk skulle betales."]
[]
[]
[]
[]
[null,null,"Percentage change between values"]
[]
[null,null,null,null,null,2012,2013,2014]
[]
[null,null,"Revenue",null,null,10116,7196,6704]
[]
[null,null,{"$f":"\"What is the percentage change between the revenue in \"&F77&\" and \"&H77&\"?\"","v":"What is the percentage change between the revenue in 2012 and 2014?"},null,null,null,null,null,null,null,null,null,"original_value",null,null,null,null,null,null,null,{"$f":"F79","v":10116}]
[null,null,{"$f":"IF(H79<F79,\"If the revenue had gone from \"&F79&\" to \"&F79/2&\" then it had decreased by 50%.\",\"If the revenue had gone from \"&F79&\" to \"&F79*2&\" then it had increased by 50%.\")","v":"If the revenue had gone from 10116 to 5058 then it had decreased by 50%."}]
[null,null,{"$f":"IF(H79<F79,\"That is if the revenue is halved, it is decreased by 50%. The revenue\", \"That is if the revenue is doubled, it is increased by 100%. The revenue\")","v":"That is if the revenue is halved, it is decreased by 50%. The revenue"},null,null,null,null,null,null,null,null,null,"new_value",null,null,null,null,null,null,null,{"$f":"H79","v":6704}]
[null,null,{"$f":"IF(H79<F79,\"decreased from \"&F79&\" to \"&H79&\". Since \"&H79&\" is more than half way between\",\"increased from \"&F79&\" to \"&H79&\". \"&H79&\" is less than double the Revenue in\")","v":"decreased from 10116 to 6704. Since 6704 is more than half way between"}]
[null,null,{"$f":"IF(H79>F79,F77&\". \",F79&\" and \"&F79/2&\" the percent decrease is less than 50%.\")","v":"10116 and 5058 the percent decrease is less than 50%."},null,null,null,null,null,null,null,null,null,"Percentage change",null,null,null,null,null,null,null,{"$f":"(new_value-original_value)/original_value","v":-0.33728746540134441}]
[null,null,"Now let's get the actual value."]
[null,null,{"$f":"F79&\" times what number will give \"&H79&\"?\"","v":"10116 times what number will give 6704?"},null,null,null,null,null,null,null,null,null,"Alternative formula",null,null,null,null,null,null,null,{"$f":"(new_value/original_value) - 1","v":-0.33728746540134436}]
[]
[null,null,{"$f":"F79&\" * x = \"&H79","v":"10116 * x = 6704"}]
[null,null,{"$f":"\"x = \"&H79&\" / \"&F79&\" = \"&TEXT(H79/F79,\"0,0000\")","v":"x = 6704 / 10116 = 0,6627"}]
[]
[null,null,{"$f":"IF(H79<F79,\"That is we get the revenue in \"&H77&\" by multiplying the revenue in \"&F77&\" by \",\"That is we get the revenue in \"&H77&\" by multiplying the revenue in \"&F77&\" by \")","v":"That is we get the revenue in 2014 by multiplying the revenue in 2012 by "}]
[null,null,{"$f":"TEXT(H79/F79,\"0,0000\")&\" meaning that the revenue in \"&H77&\" is \"&TEXT(H79/F79,\"0,00%\")&\" of the revenue in \"&F77&\".\"","v":"0,6627 meaning that the revenue in 2014 is 66,27% of the revenue in 2012."}]
[]
[null,null,"You can use the following formula to calculate the percentage change:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Percentage change if original value and"]
[null,null,"new value have opposite sign"]
[]
[]
[null,null,"According to the Company X annual report 2014 net profit/los for the years"]
[null,null,"were as follows: (DKKm)"]
[]
[null,null,null,null,null,2012,2013,2014]
[]
[null,null,"Net profit/loss for the year",null,null,326,-935,-1931]
[]
[null,null,"What is the % - change between the net profit/loss in 2012 and in 2014?"]
[]
[null,null,"The actual change between 2012 and 2014 means something, but dividing "]
[null,null,"it by a number of the opposite sign does not convey any meaningful "]
[null,null,"information."]
[]
[null,null,"Net Income percent change is the change from the same period from a year"]
[null,null,"ago. Percent change is not provided if either the latest period or the year ago "]
[null,null,"period contains a net loss. If a company posts a profit "]
[null,null,"in the latest period against a loss in the year-ago period, the percent change"]
[null,null,"is represented as \"P\". Similarly, if a company posts a loss in the latest"]
[null,null,"period against a profit in the year-ago period, the percent change is "]
[null,null,"represented as a \"L\"."]
[]
[]
[]
[]
[]
[null,"Hvis du formindsker et beløb med en bestemt procent og du"]
[null,"herefter forøger det formindskede beløb med samme procent"]
[null,"så kommer du ikke tilbage til der, hvor du startede."]
[]
[null,"Prøv at indtaste forskellige tal i de gule celler."]
[]
[null,"Startbeløb",null,null,"A",100]
[null,"Procentvis formindskelse",null,null,"P",0.3]
[null,"Formindsket beløb",null,null,"A'",{"$f":"F143*(1-F144)","v":70}]
[]
[null,{"$f":"\"Reuktion = \"&F143&\" - \"&F145&\" = \"&F143-F145","v":"Reuktion = 100 - 70 = 30"}]
[]
[null,"Formindsket beløb",null,null,"A'",{"$f":"F145","v":70}]
[null,"Procentvis forøgelse",null,null,"P",{"$f":"F144","v":0.3}]
[null,"Forøget beløb",null,null,"A''",{"$f":"F149*(1+F150)","v":91}]
[]
[null,{"$f":"\"Forøgelse = \"&F151&\" - \"&F149&\" = \"&F151-F149","v":"Forøgelse = 91 - 70 = 21"}]
[]
[]
[null,"Matematisk"]
[null,"A\" = A' *(1-P)*(1+P)",null,null,"A'",{"$f":"F145","v":70}]
[null,"    = A' *(1 - P^2)",null,null,"P",{"$f":"F144","v":0.3}]
[null,null,null,null,"A\"",{"$f":"F143*(1-F144^2)","v":91},{"$f":"_xlfn.FORMULATEXT(F159)","v":"=F143*(1-F144^2)"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Vis antal hele procenter"]
[null,null,null,null,null,null,null,null,null,null,null,"Indtast procent (helt tal)",null,null,null,null,null,null,37]
[null,"Billede",null,null,null,null,null,null,null,null,null,{"$f":"COLUMN(A:J)","v":1},2,3,4,5,6,7,8,9,10]
[null,null,null,null,null,null,null,null,null,null,{"$f":"ROW(1:10)","v":1},{"$f":"L$170+$K171-1+$U$170*($K171-1)-(ROW(1:1)-1)","v":1},{"$f":"M$170+$K171-1+$U$170*($K171-1)-(ROW(1:1)-1)","v":2},{"$f":"N$170+$K171-1+$U$170*($K171-1)-(ROW(1:1)-1)","v":3},{"$f":"O$170+$K171-1+$U$170*($K171-1)-(ROW(1:1)-1)","v":4},{"$f":"P$170+$K171-1+$U$170*($K171-1)-(ROW(1:1)-1)","v":5},{"$f":"Q$170+$K171-1+$U$170*($K171-1)-(ROW(1:1)-1)","v":6},{"$f":"R$170+$K171-1+$U$170*($K171-1)-(ROW(1:1)-1)","v":7},{"$f":"S$170+$K171-1+$U$170*($K171-1)-(ROW(1:1)-1)","v":8},{"$f":"T$170+$K171-1+$U$170*($K171-1)-(ROW(1:1)-1)","v":9},{"$f":"U$170+$K171-1+$U$170*($K171-1)-(ROW(1:1)-1)","v":10}]
[null,null,null,null,null,null,null,null,null,null,2,{"$f":"L$170+$K172-1+$U$170*($K172-1)-(ROW(2:2)-1)","v":11},{"$f":"M$170+$K172-1+$U$170*($K172-1)-(ROW(2:2)-1)","v":12},{"$f":"N$170+$K172-1+$U$170*($K172-1)-(ROW(2:2)-1)","v":13},{"$f":"O$170+$K172-1+$U$170*($K172-1)-(ROW(2:2)-1)","v":14},{"$f":"P$170+$K172-1+$U$170*($K172-1)-(ROW(2:2)-1)","v":15},{"$f":"Q$170+$K172-1+$U$170*($K172-1)-(ROW(2:2)-1)","v":16},{"$f":"R$170+$K172-1+$U$170*($K172-1)-(ROW(2:2)-1)","v":17},{"$f":"S$170+$K172-1+$U$170*($K172-1)-(ROW(2:2)-1)","v":18},{"$f":"T$170+$K172-1+$U$170*($K172-1)-(ROW(2:2)-1)","v":19},{"$f":"U$170+$K172-1+$U$170*($K172-1)-(ROW(2:2)-1)","v":20}]
[null,null,null,null,null,null,null,null,null,null,3,{"$f":"L$170+$K173-1+$U$170*($K173-1)-(ROW(3:3)-1)","v":21},{"$f":"M$170+$K173-1+$U$170*($K173-1)-(ROW(3:3)-1)","v":22},{"$f":"N$170+$K173-1+$U$170*($K173-1)-(ROW(3:3)-1)","v":23},{"$f":"O$170+$K173-1+$U$170*($K173-1)-(ROW(3:3)-1)","v":24},{"$f":"P$170+$K173-1+$U$170*($K173-1)-(ROW(3:3)-1)","v":25},{"$f":"Q$170+$K173-1+$U$170*($K173-1)-(ROW(3:3)-1)","v":26},{"$f":"R$170+$K173-1+$U$170*($K173-1)-(ROW(3:3)-1)","v":27},{"$f":"S$170+$K173-1+$U$170*($K173-1)-(ROW(3:3)-1)","v":28},{"$f":"T$170+$K173-1+$U$170*($K173-1)-(ROW(3:3)-1)","v":29},{"$f":"U$170+$K173-1+$U$170*($K173-1)-(ROW(3:3)-1)","v":30}]
[null,null,null,null,null,null,null,null,null,null,4,{"$f":"L$170+$K174-1+$U$170*($K174-1)-(ROW(4:4)-1)","v":31},{"$f":"M$170+$K174-1+$U$170*($K174-1)-(ROW(4:4)-1)","v":32},{"$f":"N$170+$K174-1+$U$170*($K174-1)-(ROW(4:4)-1)","v":33},{"$f":"O$170+$K174-1+$U$170*($K174-1)-(ROW(4:4)-1)","v":34},{"$f":"P$170+$K174-1+$U$170*($K174-1)-(ROW(4:4)-1)","v":35},{"$f":"Q$170+$K174-1+$U$170*($K174-1)-(ROW(4:4)-1)","v":36},{"$f":"R$170+$K174-1+$U$170*($K174-1)-(ROW(4:4)-1)","v":37},{"$f":"S$170+$K174-1+$U$170*($K174-1)-(ROW(4:4)-1)","v":38},{"$f":"T$170+$K174-1+$U$170*($K174-1)-(ROW(4:4)-1)","v":39},{"$f":"U$170+$K174-1+$U$170*($K174-1)-(ROW(4:4)-1)","v":40}]
[null,null,null,null,null,null,null,null,null,null,5,{"$f":"L$170+$K175-1+$U$170*($K175-1)-(ROW(5:5)-1)","v":41},{"$f":"M$170+$K175-1+$U$170*($K175-1)-(ROW(5:5)-1)","v":42},{"$f":"N$170+$K175-1+$U$170*($K175-1)-(ROW(5:5)-1)","v":43},{"$f":"O$170+$K175-1+$U$170*($K175-1)-(ROW(5:5)-1)","v":44},{"$f":"P$170+$K175-1+$U$170*($K175-1)-(ROW(5:5)-1)","v":45},{"$f":"Q$170+$K175-1+$U$170*($K175-1)-(ROW(5:5)-1)","v":46},{"$f":"R$170+$K175-1+$U$170*($K175-1)-(ROW(5:5)-1)","v":47},{"$f":"S$170+$K175-1+$U$170*($K175-1)-(ROW(5:5)-1)","v":48},{"$f":"T$170+$K175-1+$U$170*($K175-1)-(ROW(5:5)-1)","v":49},{"$f":"U$170+$K175-1+$U$170*($K175-1)-(ROW(5:5)-1)","v":50}]
[null,null,null,null,null,null,null,null,null,null,6,{"$f":"L$170+$K176-1+$U$170*($K176-1)-(ROW(6:6)-1)","v":51},{"$f":"M$170+$K176-1+$U$170*($K176-1)-(ROW(6:6)-1)","v":52},{"$f":"N$170+$K176-1+$U$170*($K176-1)-(ROW(6:6)-1)","v":53},{"$f":"O$170+$K176-1+$U$170*($K176-1)-(ROW(6:6)-1)","v":54},{"$f":"P$170+$K176-1+$U$170*($K176-1)-(ROW(6:6)-1)","v":55},{"$f":"Q$170+$K176-1+$U$170*($K176-1)-(ROW(6:6)-1)","v":56},{"$f":"R$170+$K176-1+$U$170*($K176-1)-(ROW(6:6)-1)","v":57},{"$f":"S$170+$K176-1+$U$170*($K176-1)-(ROW(6:6)-1)","v":58},{"$f":"T$170+$K176-1+$U$170*($K176-1)-(ROW(6:6)-1)","v":59},{"$f":"U$170+$K176-1+$U$170*($K176-1)-(ROW(6:6)-1)","v":60}]
[null,null,null,null,null,null,null,null,null,null,7,{"$f":"L$170+$K177-1+$U$170*($K177-1)-(ROW(7:7)-1)","v":61},{"$f":"M$170+$K177-1+$U$170*($K177-1)-(ROW(7:7)-1)","v":62},{"$f":"N$170+$K177-1+$U$170*($K177-1)-(ROW(7:7)-1)","v":63},{"$f":"O$170+$K177-1+$U$170*($K177-1)-(ROW(7:7)-1)","v":64},{"$f":"P$170+$K177-1+$U$170*($K177-1)-(ROW(7:7)-1)","v":65},{"$f":"Q$170+$K177-1+$U$170*($K177-1)-(ROW(7:7)-1)","v":66},{"$f":"R$170+$K177-1+$U$170*($K177-1)-(ROW(7:7)-1)","v":67},{"$f":"S$170+$K177-1+$U$170*($K177-1)-(ROW(7:7)-1)","v":68},{"$f":"T$170+$K177-1+$U$170*($K177-1)-(ROW(7:7)-1)","v":69},{"$f":"U$170+$K177-1+$U$170*($K177-1)-(ROW(7:7)-1)","v":70}]
[null,null,null,null,null,null,null,null,null,null,8,{"$f":"L$170+$K178-1+$U$170*($K178-1)-(ROW(8:8)-1)","v":71},{"$f":"M$170+$K178-1+$U$170*($K178-1)-(ROW(8:8)-1)","v":72},{"$f":"N$170+$K178-1+$U$170*($K178-1)-(ROW(8:8)-1)","v":73},{"$f":"O$170+$K178-1+$U$170*($K178-1)-(ROW(8:8)-1)","v":74},{"$f":"P$170+$K178-1+$U$170*($K178-1)-(ROW(8:8)-1)","v":75},{"$f":"Q$170+$K178-1+$U$170*($K178-1)-(ROW(8:8)-1)","v":76},{"$f":"R$170+$K178-1+$U$170*($K178-1)-(ROW(8:8)-1)","v":77},{"$f":"S$170+$K178-1+$U$170*($K178-1)-(ROW(8:8)-1)","v":78},{"$f":"T$170+$K178-1+$U$170*($K178-1)-(ROW(8:8)-1)","v":79},{"$f":"U$170+$K178-1+$U$170*($K178-1)-(ROW(8:8)-1)","v":80}]
[null,null,null,null,null,null,null,null,null,null,9,{"$f":"L$170+$K179-1+$U$170*($K179-1)-(ROW(9:9)-1)","v":81},{"$f":"M$170+$K179-1+$U$170*($K179-1)-(ROW(9:9)-1)","v":82},{"$f":"N$170+$K179-1+$U$170*($K179-1)-(ROW(9:9)-1)","v":83},{"$f":"O$170+$K179-1+$U$170*($K179-1)-(ROW(9:9)-1)","v":84},{"$f":"P$170+$K179-1+$U$170*($K179-1)-(ROW(9:9)-1)","v":85},{"$f":"Q$170+$K179-1+$U$170*($K179-1)-(ROW(9:9)-1)","v":86},{"$f":"R$170+$K179-1+$U$170*($K179-1)-(ROW(9:9)-1)","v":87},{"$f":"S$170+$K179-1+$U$170*($K179-1)-(ROW(9:9)-1)","v":88},{"$f":"T$170+$K179-1+$U$170*($K179-1)-(ROW(9:9)-1)","v":89},{"$f":"U$170+$K179-1+$U$170*($K179-1)-(ROW(9:9)-1)","v":90}]
[null,null,null,null,null,null,null,null,null,null,10,{"$f":"L$170+$K180-1+$U$170*($K180-1)-(ROW(10:10)-1)","v":91},{"$f":"M$170+$K180-1+$U$170*($K180-1)-(ROW(10:10)-1)","v":92},{"$f":"N$170+$K180-1+$U$170*($K180-1)-(ROW(10:10)-1)","v":93},{"$f":"O$170+$K180-1+$U$170*($K180-1)-(ROW(10:10)-1)","v":94},{"$f":"P$170+$K180-1+$U$170*($K180-1)-(ROW(10:10)-1)","v":95},{"$f":"Q$170+$K180-1+$U$170*($K180-1)-(ROW(10:10)-1)","v":96},{"$f":"R$170+$K180-1+$U$170*($K180-1)-(ROW(10:10)-1)","v":97},{"$f":"S$170+$K180-1+$U$170*($K180-1)-(ROW(10:10)-1)","v":98},{"$f":"T$170+$K180-1+$U$170*($K180-1)-(ROW(10:10)-1)","v":99},{"$f":"U$170+$K180-1+$U$170*($K180-1)-(ROW(10:10)-1)","v":100}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Læg mærke til, at kvadratet indeholder "]
[null,"Jeg har lavet ovenstående som et billede ",null,null,null,null,null,null,null,null,null,"alle tal fra 1 til 100. Pånær et enkelt kva-"]
[null,"(med link) fordi kolonnerne B:K har en",null,null,null,null,null,null,null,null,null,"drat er de gjort usynlige ved hjælp af"]
[null,"større bredde end kolonne L:U.",null,null,null,null,null,null,null,null,null,"formatering."]
[]
[null,null,null,null,null,null,null,null,null,null,null,"For at lave kvadratiske celler, gør følgende:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"1.","Peg med musen på kolonneoverskriften"]
[null,null,null,null,null,null,null,null,null,null,null,null,"og sæt kolonnevidden så bred som du"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ønsker den."]
[null,null,null,null,null,null,null,null,null,null,null,"2.","Bemærk og husk pixel-tallet og kolonne-"]
[null,null,null,null,null,null,null,null,null,null,null,null,"bredden."]
[null,null,null,null,null,null,null,null,null,null,null,"3.","Peg med musen på rækkeoverskriften"]
[null,null,null,null,null,null,null,null,null,null,null,null,"og sæt rækkehøjden til samme antal"]
[null,null,null,null,null,null,null,null,null,null,null,null,"pixels som du aflæste for kolonnen."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Husk rækkehøjden."]
[null,null,null,null,null,null,null,null,null,null,null,"4.","Vælg nu det område, hvor du vil have "]
[null,null,null,null,null,null,null,null,null,null,null,null,"kvadrater. Sæt kolonnebredden og"]
[null,null,null,null,null,null,null,null,null,null,null,null,"rækkehøjden som aflæst under 2. og 3."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Hvis du har adgang til SEQUENCE/SEKVENS,"]
[null,null,null,null,null,null,null,null,null,null,null,"så kan du meget let udarbejde en tabel med "]
[null,null,null,null,null,null,null,null,null,null,null,"fra 1 til 100, meget letere end den formel "]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"der findes i \"&mycell(L171)&\" nemlig:\"","v":"der findes i L171 nemlig:"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.FORMULATEXT(L171)","v":"=L$170+$K171-1+$U$170*($K171-1)-(ROW(1:1)-1)"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Med SEKVENS-funktionen kan du bruge:"]
[null,null,null,null,null,null,null,null,null,null,null,"=SEQUENE(10;10) eller dansk =SEKVENS(10;10)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Indtast procent (helt tal)",null,null,null,null,null,null,55]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MOD(ROW(A1),2)=1,_xlfn.SEQUENCE(,10,100-(ROW(A1)-1)*10-9,1),_xlfn.SEQUENCE(,10,100-(ROW(A1)-1)*10,-1))","v":91},92,93,94,95,96,97,98,99,100]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MOD(ROW(A2),2)=1,_xlfn.SEQUENCE(,10,100-(ROW(A2)-1)*10-9,1),_xlfn.SEQUENCE(,10,100-(ROW(A2)-1)*10,-1))","v":90},89,88,87,86,85,84,83,82,81]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MOD(ROW(A3),2)=1,_xlfn.SEQUENCE(,10,100-(ROW(A3)-1)*10-9,1),_xlfn.SEQUENCE(,10,100-(ROW(A3)-1)*10,-1))","v":71},72,73,74,75,76,77,78,79,80]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MOD(ROW(A4),2)=1,_xlfn.SEQUENCE(,10,100-(ROW(A4)-1)*10-9,1),_xlfn.SEQUENCE(,10,100-(ROW(A4)-1)*10,-1))","v":70},69,68,67,66,65,64,63,62,61]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MOD(ROW(A5),2)=1,_xlfn.SEQUENCE(,10,100-(ROW(A5)-1)*10-9,1),_xlfn.SEQUENCE(,10,100-(ROW(A5)-1)*10,-1))","v":51},52,53,54,55,56,57,58,59,60]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MOD(ROW(A6),2)=1,_xlfn.SEQUENCE(,10,100-(ROW(A6)-1)*10-9,1),_xlfn.SEQUENCE(,10,100-(ROW(A6)-1)*10,-1))","v":50},49,48,47,46,45,44,43,42,41]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MOD(ROW(A7),2)=1,_xlfn.SEQUENCE(,10,100-(ROW(A7)-1)*10-9,1),_xlfn.SEQUENCE(,10,100-(ROW(A7)-1)*10,-1))","v":31},32,33,34,35,36,37,38,39,40]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MOD(ROW(A8),2)=1,_xlfn.SEQUENCE(,10,100-(ROW(A8)-1)*10-9,1),_xlfn.SEQUENCE(,10,100-(ROW(A8)-1)*10,-1))","v":30},29,28,27,26,25,24,23,22,21]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MOD(ROW(A9),2)=1,_xlfn.SEQUENCE(,10,100-(ROW(A9)-1)*10-9,1),_xlfn.SEQUENCE(,10,100-(ROW(A9)-1)*10,-1))","v":11},12,13,14,15,16,17,18,19,20]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MOD(ROW(A10),2)=1,_xlfn.SEQUENCE(,10,100-(ROW(A10)-1)*10-9,1),_xlfn.SEQUENCE(,10,100-(ROW(A10)-1)*10,-1))","v":10},9,8,7,6,5,4,3,2,1]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Som nævnt  - det her er mest for sjov."]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Ovennævnte viser hele procenter ud-"]
[null,null,null,null,null,null,null,null,null,null,null,"fyldt fra nederste højre hjørne mod"]
[null,null,null,null,null,null,null,null,null,null,null,"venstre og derefter opad én celle "]
[null,null,null,null,null,null,null,null,null,null,null,"længst til højre."]
[null,null,null,null,null,null,null,null,null,null,null,"Hvis du skulle ønske at lave noget tilsva-"]
[null,null,null,null,null,null,null,null,null,null,null,"rende, hvor det er muligt at vise for ek-"]
[null,null,null,null,null,null,null,null,null,null,null,"sempel 25,5 %, så kan det gøres med et"]
[null,null,null,null,null,null,null,null,null,null,null,"diagram som herunder."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Indtast procenttal",null,null,null,null,null,0.55500000000000005]
[]
[]
[]
[null,null,null,null,null,null,0,{"$f":"R237*100","v":55.500000000000007}]
[null,null,null,null,null,null,10,{"$f":"MAX(IF($H$241>G242,10,$H$241-G241),0)","v":10},10]
[null,null,null,null,null,null,20,10,10]
[null,null,null,null,null,null,30,10,10]
[null,null,null,null,null,null,40,10,10]
[null,null,null,null,null,null,50,10,10]
[null,null,null,null,null,null,60,5.5000000000000071,10]
[null,null,null,null,null,null,70,0,10]
[null,null,null,null,null,null,80,0,10]
[null,null,null,null,null,null,90,0,10]
[null,null,null,null,null,null,100,0,10]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Diagrammet herover viser procenttal fra"]
[null,null,null,null,null,null,null,null,null,null,null,"nederste højre hjørne og derefter opad"]
[null,null,null,null,null,null,null,null,null,null,null,"én celle længst til venstre."]

{"sheet":"Lommeregner","index":6,"n_rows":44,"n_cols":10,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Lommeregner"]
[]
[null,null,null,null,null,null,null,null,null,"+"]
[null,null,2,{"$f":"IF(J19=1,\"+\",IF(J19=2,\"-\",IF(J19=3,\"*\",IF(J19=4,\"/\",IF(J19=5,\"^\",IF(J19=6,\"=\",IF(J19=7,\">\",IF(J19=8,\">=\",IF(J19=9,\"<\",IF(J19=10,\"<=\",IF(J19=11,\"<>\",\"\")))))))))))","v":"/"},2,{"$f":"mEvaluate","v":1},null,null,null,"-"]
[null,null,null,null,null,null,null,null,null,"*"]
[null,null,null,null,null,null,null,null,null,"/"]
[null,"VBA Function Eval (jvf. nedenfor)",null,null,null,{"$f":"eval(Ref)","v":1},null,null,null,"^"]
[null,null,null,null,null,null,null,null,null,"="]
[null,"Det her har ingen praktisk relevans - det er kun for sjov.",null,null,null,null,null,null,null,">"]
[null,{"$f":"\"Formlen i cell \"&mycell(F6)&\" =mEvaluate, der er oprettet som en navngiven\"","v":"Formlen i cell F6 =mEvaluate, der er oprettet som en navngiven"},null,null,null,null,null,null,null,">="]
[null,"formel under Name Manager/Navnestyring gør brug af en af de",null,null,null,null,null,null,null,"<"]
[null,"gamle Excel 4.0 makroer (XLM makroer introduceret i 1992).",null,null,null,null,null,null,null,"<="]
[null,null,null,null,null,null,null,null,null,"<>"]
[null,"I valgboksen (i celle D6) kan du vælge mellem forskellige"]
[null,"operatorer (se J5:J15)."]
[]
[null,null,null,null,null,null,null,null,"Format Control, cell link",4]
[]
[]
[null,"Hvis du gerne vil undgå at bruge en af de gamle XLM makroer kan du i stedet for bruge følgende"]
[null,"kode."]
[]
[null,"Function Eval(Ref As String)"]
[null,"Application.Volatile"]
[null,"Eval = Evaluate(Ref)"]
[null,"End Function"]
[]
[]
[]
[]
[]
[null,"Lommeregner"]
[null,null,null,null,null,"Resultat"]
[null,5,"+",3,null,{"$f":"CHOOSE(MATCH(\"~\"&C36,{\"*\",\"+\",\"-\",\"/\"},0),B36*D36,B36+D36,B36-D36,B36/D36)","v":8}]
[null,null,null,null,null,{"$f":"CHOOSE(MIN(3,CODE(C36)-41)+MAX(0,CODE(C36)-46),B36*D36,B36+D36,B36-D36,B36/D36)","v":8},null,"*",{"$f":"CODE(H37)","v":42},{"$f":"MIN(3,CODE(H37)-41)+MAX(0,CODE(H37)-46)","v":1}]
[null,null,null,null,null,null,null,"+",{"$f":"CODE(H38)","v":43},{"$f":"MIN(3,CODE(H38)-41)+MAX(0,CODE(H38)-46)","v":2}]
[null,null,null,null,null,null,null,"-",{"$f":"CODE(H39)","v":45},{"$f":"MIN(3,CODE(H39)-41)+MAX(0,CODE(H39)-46)","v":3}]
[null,null,null,null,null,null,null,"/",{"$f":"CODE(H40)","v":47},{"$f":"MIN(3,CODE(H40)-41)+MAX(0,CODE(H40)-46)","v":4}]
[]
[]
[]
[null,5,"Division",4,null,{"$f":"CHOOSE(MATCH(\"~\"&INDEX({\"+\";\"-\";\"*\";\"/\"},MATCH(C44,{\"Plus\";\"Minus\";\"Gange\";\"Division\"},0)),{\"*\",\"+\",\"-\",\"/\"},0),B44*D44,B44+D44,B44-D44,B44/D44)","v":1.25}]

{"sheet":"ABC_analyse","index":7,"n_rows":104,"n_cols":10,"rows_kept":104,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ABC-analyse af kunder",null,null,null,"Hvis du ikke lige er helt med på, hvad ABC-analyse er, så kan du søge på nettet"]
[null,null,null,null,null,"og finde en masse om emnet."]
[]
[null,"Klassinddeling - Omsætning",null,null,null,"ABC-analyse efter omsætning"]
[]
[null,"A","Over",150000,null,null,"Antal kunder","%","Omsætning ","%"]
[null,"B","Til",{"$f":"D7-0.01","v":149999.99},null,"A",{"$f":"COUNTIF($D$26:$D$104,F8)","v":11},{"$f":"G8/$G$11","v":0.13924050632911392},{"$f":"SUMIF($D$26:$D$104,F8,$C$26:$C$104)","v":4931425.4400000004},{"$f":"I8/$I$11","v":0.72110151983578474}]
[null,null,"Fra",10000,null,"B",{"$f":"COUNTIF($D$26:$D$104,F9)","v":38},{"$f":"G9/$G$11","v":0.48101265822784811},{"$f":"SUMIF($D$26:$D$104,F9,$C$26:$C$104)","v":1756366.69},{"$f":"I9/$I$11","v":0.25682608506556809}]
[null,"C","Til",{"$f":"D9-0.01","v":9999.99},null,"C",{"$f":"COUNTIF($D$26:$D$104,F10)","v":30},{"$f":"G10/$G$11","v":0.379746835443038},{"$f":"SUMIF($D$26:$D$104,F10,$C$26:$C$104)","v":150947.35999999999},{"$f":"I10/$I$11","v":2.207239509864704E-2}]
[null,null,null,null,null,"I alt",{"$f":"SUM(G8:G10)","v":79},{"$f":"G11/$G$11","v":1},{"$f":"SUM(I8:I10)","v":6838739.4900000012},{"$f":"I11/$I$11","v":1}]
[null,"Klasseinddeling - Dækningsbidrag"]
[null,null,null,null,null,"ABC-analyse efter dækningsbidrag"]
[null,"A","Over",75000]
[null,"B","Til",{"$f":"D14-0.01","v":74999.990000000005},null,null,"Antal kunder","%","DB","%"]
[null,null,"Fra",5000,null,"A",{"$f":"COUNTIF($F$26:$F$104,F16)","v":10},{"$f":"G16/$G$19","v":0.12658227848101267},{"$f":"SUMIF($F$26:$F$104,F16,$E$26:$E$104)","v":1672707.44},{"$f":"I16/$I$19","v":0.72331489308729546}]
[null,"C","Til",{"$f":"D16-0.01","v":4999.99},null,"B",{"$f":"COUNTIF($F$26:$F$104,F17)","v":29},{"$f":"G17/$G$19","v":0.36708860759493672},{"$f":"SUMIF($F$26:$F$104,F17,$E$26:$E$104)","v":547229.8899999999},{"$f":"I17/$I$19","v":0.23663404604664304}]
[null,null,null,null,null,"C",{"$f":"COUNTIF($F$26:$F$104,F18)","v":40},{"$f":"G18/$G$19","v":0.50632911392405067},{"$f":"SUMIF($F$26:$F$104,F18,$E$26:$E$104)","v":92620.390000000029},{"$f":"I18/$I$19","v":4.0051060866061333E-2}]
[null,null,null,null,null,"I alt",{"$f":"SUM(G16:G18)","v":79},{"$f":"G19/$G$11","v":1},{"$f":"SUM(I16:I18)","v":2312557.7200000002},{"$f":"I19/$I$19","v":1}]
[]
[]
[null,null,null,null,null,null,null,"Opgaven er som følger:"]
[null,null,null,null,null,null,null,"Indsæt et \"A\", \"B\" eller \"C\" i kolonnerne \"Omsætningskategori\""]
[null,"Kundenavn","Omsætning","Omsætnings-","Dæknings-","DB","Afvigelse","og \"DB-kategori baseret på de klasseinddelingsprincipper der er"]
[null,null,null,"kategori","bidrag","kategori",null,"anført i opstllingen øverst til venstre. Kolonnen \"Afvigelse\" skal "]
[null,null,126545,{"$f":"IF(C26>=$D$7,\"A\",IF(C26>=$D$9,\"B\",IF(C26>=0,\"C\",\"\")))","v":"B"},24401.75,{"$f":"IF(E26>=$D$14,\"A\",IF(E26>=$D$16,\"B\",IF(E26>=0,\"C\",\"\")))","v":"B"},{"$f":"IF(D26<>F26,\"Ja\",\"\")","v":""},"indeholde et \"JA\" hvis der for en given kunde er forskel mellem"]
[null,null,59554.14,{"$f":"IF(C27>=$D$7,\"A\",IF(C27>=$D$9,\"B\",IF(C27>=0,\"C\",\"\")))","v":"B"},20896.189999999999,{"$f":"IF(E27>=$D$14,\"A\",IF(E27>=$D$16,\"B\",IF(E27>=0,\"C\",\"\")))","v":"B"},{"$f":"IF(D27<>F27,\"Ja\",\"\")","v":""},"\"Omsætningskategori\" og \"DB-kategori\". Brug betinget forma-"]
[null,null,13068,"B",4585.26,"C","Ja","tering til at give \"A\", \"B\" og \"C\" forskellig farve."]
[null,null,87120,"B",1568.42,"C","Ja"]
[null,null,164209.22,"A",27617.27,"B","Ja","Herefter skal skemaet oven for (i kolonne G:K) færdiggøres. Alt"]
[null,null,11386.58,"B",3995.29,"C","Ja","skal ske ved hjælp af formler/funktioner."]
[null,null,5955.74,"C",2089.73,"C",""]
[null,null,85971.11,"B",30165.3,"B","","Endelig skal du lave et søjlediagram der viser omsætning og DB"]
[null,null,1346,"C",472.28,"C","","i procent for henholdsvis A-, B- og C-kunder."]
[null,null,57378.32,"B",20132.740000000002,"B",""]
[null,null,4975.6400000000003,"C",1745.84,"C",""]
[null,null,848902.73,"A",297860.61,"A",""]
[null,null,8600.92,"C",3017.87,"C",""]
[null,null,110219.87,"B",30673.64,"B",""]
[null,null,332278.95,"A",116589.1,"A",""]
[null,null,9786.84,"C",3433.98,"C",""]
[null,null,32395.57,"B",11366.87,"B",""]
[null,null,102429.16,"B",35940.06,"B",""]
[null,null,415426.28,"A",145763.60999999999,"A",""]
[null,null,293799.13,"A",103087.41,"A",""]
[null,null,11883.51,"B",4169.6499999999996,"C","Ja"]
[null,null,134659.21,"B",47248.84,"B",""]
[null,null,531320.92000000004,"A",186428.39,"A",""]
[null,null,22869,"B",8024.21,"B",""]
[null,null,7599.04,"C",2666.33,"C",""]
[null,null,27225,"B",9552.6299999999992,"B",""]
[null,null,544.5,"C",191.05,"C",""]
[null,null,1633.5,"C",573.16,"C",""]
[null,null,11979,"B",4203.16,"C","Ja"]
[null,null,4900.5,"C",1719.47,"C",""]
[null,null,354795.11,"A",124489.51,"A",""]
[null,null,354736.31,"A",124468.88,"A",""]
[null,null,7599.04,"C",2666.33,"C",""]
[null,null,14796.24,"B",5191.66,"B",""]
[null,null,15872.18,"B",5569.18,"B",""]
[null,null,7599.04,"C",2666.33,"C",""]
[null,null,27626.84,"B",9693.6299999999992,"B",""]
[null,null,82652.92,"B",29001.03,"B",""]
[null,null,87636.19,"B",30749.54,"B",""]
[null,null,7599.04,"C",2666.33,"C",""]
[null,null,303819.02,"A",106603.17,"A",""]
[null,null,1065817.3700000001,"A",373971.01,"A",""]
[null,null,10778.92,"B",3782.08,"C","Ja"]
[null,null,13465.49,"B",4724.7299999999996,"C","Ja"]
[null,null,7599.04,"C",2666.33,"C",""]
[null,null,36531.589999999997,"B",12818.1,"B",""]
[null,null,266320.40000000002,"A",93445.75,"A",""]
[null,null,811.31,"C",284.67,"C",""]
[null,null,7599.04,"C",2666.33,"C",""]
[null,null,8599.83,"C",3017.49,"C",""]
[null,null,625.09,"C",219.33,"C",""]
[null,null,2574.4,"C",903.3,"C",""]
[null,null,8597.66,"C",3016.72,"C",""]
[null,null,4975.6400000000003,"C",1745.84,"C",""]
[null,null,86007.039999999994,"B",30177.91,"B",""]
[null,null,52485.440000000002,"B",18415.95,"B",""]
[null,null,74.05,"C",25.98,"C",""]
[null,null,9618.0499999999993,"C",3374.75,"C",""]
[null,null,11790.6,"B",4137.05,"C","Ja"]
[null,null,89658.46,"B",31459.11,"B",""]
[null,null,5458.07,"C",1915.11,"C",""]
[null,null,8398.3700000000008,"C",2946.8,"C",""]
[null,null,967.03,"C",339.31,"C",""]
[null,null,10516.47,"B",3689.99,"C","Ja"]
[null,null,39.200000000000003,"C",13.76,"C",""]
[null,null,1346,{"$f":"IF(C91>=$D$7,\"A\",IF(C91>=$D$9,\"B\",IF(C91>=0,\"C\",\"\")))","v":"C"},472.28,{"$f":"IF(E91>=$D$14,\"A\",IF(E91>=$D$16,\"B\",IF(E91>=0,\"C\",\"\")))","v":"C"},{"$f":"IF(D91<>F91,\"Ja\",\"\")","v":""}]
[null,null,5458.07,"C",1915.11,"C",""]
[null,null,9570.1299999999992,"C",3357.94,"C",""]
[null,null,13682.2,"B",4800.7700000000004,"C","Ja"]
[null,null,17794.259999999998,"B",6243.6,"B",""]
[null,null,21906.32,"B",7686.43,"B",""]
[null,null,26018.39,"B",9129.26,"B",""]
[null,null,30130.45,"B",10572.09,"B",""]
[null,null,34242.519999999997,"B",12014.92,"B",""]
[null,null,38354.58,"B",13457.75,"B",""]
[null,null,42466.64,"B",14900.58,"B",""]
[null,null,46578.71,"B",16343.41,"B",""]
[null,null,50690.77,"B",17786.240000000002,"B",""]
[null,null,496.58,"C",174.24,"C",""]