Autosom en meerdere cellen

%3CLINGO-SUB%20id%3D%22lingo-sub-2929027%22%20slang%3D%22en-US%22%3EAutosom%20en%20meerdere%20cellen%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2929027%22%20slang%3D%22en-US%22%3E%3CP%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3Eik%20zoek%20een%20formule%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3Eje%20maakt%20een%20optelsom%20van%202%20cellen%2C%20(10%20%2B%2020)%20uitkomst%20(autosom)%20(30)%20komt%20in%20een%20%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3CBR%20%2F%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3Ederde%20cel%20moet%20som%20blijven%20staan%20%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3CBR%20%2F%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3E%3CFONT%3Eals%20ik%20cel%201%20of%202%20naar%20ander%20getal%20(20%20%2B%2020)%2C%20kan%20er%20dan%20een%20cel%20automatisch%20gemaakt%20worden%20met%20die%20som%20zonder%20dat%20derde%20cel%20vierde%20(20%2B20)%20(30)%20(40)%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2929027%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2930182%22%20slang%3D%22en-US%22%3ERe%3A%20Autosom%20en%20meerdere%20cellen%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2930182%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1207559%22%20target%3D%22_blank%22%3E%40Joannes67%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDe%20tekst%20is%20met%20software%20vertaald%2C%20de%20gebruiker%20kan%20deze%20taal%20niet%20spreken.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMet%20uw%20toestemming%20is%20het%20niet%20mogelijk%20om%20uw%20verzoek%20in%20behandeling%20te%20nemen%2C%20helaas%20helpt%20de%20onnauwkeurige%20vertaling%20mij%20ook%20niet.%20Kunt%20u%20nader%20toelichten%20wat%20u%20graag%20zou%20willen%20doen%3F%3C%2FP%3E%3CP%3EAls%20het%20niet%20eenvoudig%20uit%20te%20leggen%20is%2C%20voeg%20dan%20een%20bestand%20met%20de%20probleemstelling%20toe%20(zonder%20gevoelige%20gegevens).%3C%2FP%3E%3CP%3EHet%20kennen%20van%20de%20Excel-versie%20en%20het%20besturingssysteem%20zou%20voordelig%20zijn%20voor%20JOU.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EZoals%20ik%20het%20begrijp%2C%20ongeacht%20welke%20getallen%20er%20tussen%20cel%201%20en%202%20staan%2C%20je%20wilt%20dat%20het%20alleen%20cellen%201%20en%202%20telt.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EZo%20ja%2C%20dan%3A%3C%2FP%3E%3CP%3EAls%20cel%20A1%20%3D%2010%3C%2FP%3E%3CP%3Een%20cel%20B1%20%3D%2020%3C%2FP%3E%3CP%3Eplaats%20deze%20vereenvoudiging%20in%20cel%20C1%3C%2FP%3E%3CP%3E%3D%20A1%20%2B%20B1%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-------------------------------------------%3C%2FP%3E%3CP%3EWith%20your%20permission%2C%20it%20is%20not%20possible%20to%20pursue%20your%20request%2C%20unfortunately%20the%20imprecise%20translation%20does%20not%20help%20me%20either.%20Could%20you%20please%20explain%20in%20more%20detail%20what%20you%20would%20like%20to%20do%3F%3C%2FP%3E%3CP%3EIf%20it%20is%20not%20easy%20to%20explain%2C%20please%20include%20a%20file%20with%20the%20problem%20statement%20(without%20sensitive%20data).%3C%2FP%3E%3CP%3EKnowing%20the%20Excel%20version%20and%20the%20operating%20system%20would%20be%20advantageous%20for%20YOU.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20I%20understand%20it%2C%20no%20matter%20what%20numbers%20are%20between%20cell%201%20and%202%2C%20you%20want%20it%20to%20only%20count%20cells%201%20and%202.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20so%2C%20then%3A%3C%2FP%3E%3CP%3EIf%20cell%20A1%20%3D%2010%3C%2FP%3E%3CP%3Eand%20cell%20B1%20%3D%2020%3C%2FP%3E%3CP%3Einsert%20this%20simplification%20in%20cell%20C1%3C%2FP%3E%3CP%3E%3D%20A1%20%2B%20B1%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

ik zoek een formule

je maakt een optelsom van 2 cellen, (10 + 20) uitkomst (autosom) (30) komt in een
derde cel moet som blijven staan
als ik cel 1 of 2 naar ander getal (20 + 20), kan er dan een cel automatisch gemaakt worden met die som zonder dat derde cel vierde (20+20) (30) (40)

3 Replies

@Joannes67 

De tekst is met software vertaald, de gebruiker kan deze taal niet spreken.

 

Met uw toestemming is het niet mogelijk om uw verzoek in behandeling te nemen, helaas helpt de onnauwkeurige vertaling mij ook niet. Kunt u nader toelichten wat u graag zou willen doen?

Als het niet eenvoudig uit te leggen is, voeg dan een bestand met de probleemstelling toe (zonder gevoelige gegevens).

Het kennen van de Excel-versie en het besturingssysteem zou voordelig zijn voor JOU.

 

Zoals ik het begrijp, ongeacht welke getallen er tussen cel 1 en 2 staan, je wilt dat het alleen cellen 1 en 2 telt.

 

Zo ja, dan:

Als cel A1 = 10

en cel B1 = 20

plaats deze vereenvoudiging in cel C1

= A1 + B1

 

-------------------------------------------

With your permission, it is not possible to pursue your request, unfortunately the imprecise translation does not help me either. Could you please explain in more detail what you would like to do?

If it is not easy to explain, please include a file with the problem statement (without sensitive data).

Knowing the Excel version and the operating system would be advantageous for YOU.

 

As I understand it, no matter what numbers are between cell 1 and 2, you want it to only count cells 1 and 2.

 

If so, then:

If cell A1 = 10

and cell B1 = 20

insert this simplification in cell C1

= A1 + B1

 

 

 

@NikolinoDE

ok ik probeer het uit te leggen met cellen:

cel A1 = 10

cel B1 = 20

cel C1  = som(A1 + B1)     = 10+20 = 30 -> cel C1 = 30

dat is makkelijk, maar ik zoek dit,

als ik alleen cel A1 = 20 of , ..... verander dan wordt ik cel C1 = 20 + 20 = 40 cel C1 = 40 maar die 30 moeten blijven van som ervoor en de som in cel D4 moet de nieuwe zijn som van  som (A1 + B1)

dus als ik een nieuw nummer in cel A1 plaats, resulteert de volgende som in een nieuwe cel, maar verandert de cel ervoor, ik hoop dat je het nu begrijpt,

Jan

 

@Joannes67 

As I wrote before, knowing the Excel version and the operating system would be an advantage for you ... unfortunately I cannot find anything like that in your message.

 

As far as I could discover the file was made with Excel 2006 and of course with Mac as the operating system.

For your task (as far as I understand from your assignment and translation) you would need VBA or maybe the LET function , but unfortunately I cannot tell you whether it works with LET or is available in Mac (also did not research), since my knowledge of Mac matters is very limited (to put it mildly).

 

With the simple IF function I created C1 and D1 for you, as far as it was understandable for me from the task. Sample file is included.

 

Maybe a Mac specialist will contact you and can then help you.

 

Until then, I wish you much fun with Excel.

 

Thank you for your patience and understanding

 

NikolinoDE