Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Word Funktion in PDF mitnehmen AkrA Word 1 07-28-2022 02:54 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:08 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft