![]() |
#1
|
|||
|
|||
![]()
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! |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
AkrA | Word | 1 | 07-28-2022 02:54 PM |