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!