Forum Discussion
Autosom en meerdere cellen
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
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