Author's photo
Account deleted
Excel

Wie arbeitet man im Excel mit der Funktion WENN?

1 answer
avatar
Account deleted
Die Funktion WENN (auf Englisch IF) in Excel gibt einen Wert zurück, wenn eine Bedingung erfüllt ist, und ein anderen Wert, wenn die Bedingung nicht erfüllt ist.

Syntax der Funktion WENN ist WENN(logical_test, value_if_true, [value_if_false])

logical_test = Die zu prüfende Bedingung. Diese Bedingung kann sowohl ein Text, eine Zahl oder eine Formel sein.

value_if_true = Der Wert, der zurückgegeben werden soll, wenn das Ergebnis der Prüfung WAHR ist.

[value_if_false] = Der Wert, der zurückgegeben werden soll, wenn das Ergebnis der Prüfung FALSCH ist.
Send your question Send your question
Study question

Ask your question right now

Add question or Search for Excel tutors
Related questions
meet'n'learn logo meet’n’learn

Tutors of Microsoft Office

Are you looking for Microsoft Office tutoring? Find the right Microsoft Office tutor for online or in-person tutoring near you.

Marcus K.

Marcus K.

From 18 €/hr

Nad P.

Nad P.
Oliver B.

Oliver B.
Christoph G.

Christoph G.
Michael M.

Michael M.
Search for a tutor

We use cookies on the website

cookie

We access the information stored on your device for this website to function properly. This includes, for example, cookies or local browser cache. We use this to store the data necessary for the functioning of the website, data used for analytical purposes, or data stored by third parties.

If this information is essential for the operation of this website, we store it automatically. For everything else, we need your consent, which you can choose to give below. Your consent is valid for 12 months. Should you refuse, we will ask you for consent again in 6 months, but you are free to change your mind at any time. For more information, please see our GDPR and Terms of Use.

This data is necessary for the proper functioning of the website and cannot be deactivated. For example, it is esential for fast navigation on the website, the correct loading of images and icons, or the login functionality.
The data is used for anonymous evaluation of traffic and user behaviour. It enables us to optimise and improve content for a better user experience.
This data is stored by partner services. In particular, this is the push notification option in the browser allowing us to proactively notify you, for instance, of a new message.