View Single Post
 
Old 02-02-2024, 02:00 PM
Mauri Mauri is offline Windows 10 Office 2016
Novice
 
Join Date: May 2023
Posts: 11
Mauri is on a distinguished road
Default Anfänger - Funktion Wenn und Zeilenumbruch

Hello everyone
I am a beginner in Excel, please don't stone me, I would very much like to include this formula for my document.
The task is "simple", but it won't work.

=WENN(H8="99*"&A8&&ZEICHEN(10)&;"Switch "&N8&&ZEICHEN(10)&", Port "&O8&""

My view of the formula:The data is merged from the following fields into one field with a respective line break.
This data is taken from the fields A8 N8 and O8. However, the data is only compiled if there is a number in field
H8 that starts with 99.


When I use this example, the data is compiled, but it is not checked whether this initial 99 number is present.
And everything is written down in one line, but I would like to have a line break.


=WENN(H8="99"&A8&", Switch "&N8&", Port "&O8&""


Wenn ich diese Formel erstelle, kommt "FALSCH"
=WENN(H8="99*"&A8&&ZEICHEN(10)&;"Switch "&N8&&ZEICHEN(10)&", Port "&O8&""

I would be very grateful for your support. Thank you very much!
Reply With Quote