#1
|
|||
|
|||
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! |
#2
|
||||
|
||||
Please post a sample sheet ( no pics please). Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
please see line Q8
after every ", " i need a new line. !thank you for watching this |
#4
|
||||
|
||||
Something like
Code:
=IF(LEFT(H8;2)="99";A8&", Switch "&N8&CHAR(10)&", Port "&O8&"";"")
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#5
|
|||
|
|||
Thanks meny time, yes that's exactly how I need this.
please you know, any good online course, so that i can learn more about excel. Thank you where mutch |
#6
|
||||
|
||||
Quote:
You're welcome. I don't know about online courses as users' interests can be very diverse. e.g. I know nothing of VBA or financial functions, but have some experience with other functions and PQ. I always encourage new learners to participate in XL forums (answering threads and learning from other users); there are very good ones out there where there is lots of activity. The present one has more MsWord activity than XL AFAIK.
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word Funktion in PDF mitnehmen | AkrA | Word | 1 | 07-28-2022 02:54 PM |