+ Reply to Thread
Results 1 to 5 of 5

combining WENN function 3 times

  1. 03-20-2020, 09:54 AM #1
    slobr
    slobr is offline
    Registered User
    Join Date
    03-20-2020
    Location
    zürich
    MS-Off Ver
    MS office
    Posts
    2

    combining WENN function 3 times

    Hello folks

    im trying to fix this by my own for a few days know but im running out of ideas. The following is the Problem:

    Unbenannt.jpg

    Date of beginning is set by user.
    Via drop down he can add the operational time.
    C2 by the end should display 3 different soultions.

    1. Exact date when a number is choosen
    2. just a String "-" when the - gets choosen
    or
    3. the starting date with the year 9999


    I was able to combine soultion 1. and 3. so far. But including condition 2 is what i cant figure out.

    Here is my function so far:

    =DATUM(JAHR(A2)+WENN(B2="unlimited";9999-JAHR(A2);B2);MONAT(A2);TAG(A2))

    This works out well so far.

    Looking forward to your ideas.
    Reply With QuoteRegister To Reply
  2. 03-20-2020, 10:12 AM #2
    Kaper
    Kaper is offline
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,620

    Re: combining WENN function 3 times

    Try:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    PS. Please note that most users here use English version of Excel, so if you attach a file (see yellow box above the posts) we will be able to open it and read the formula in locally installed version of excel (you may say - translated :-))

    or … you can use the other sub-forum https://www.excelforum.com/non-english-excel/
    Best Regards,

    Kaper
    Reply With QuoteRegister To Reply
  3. 03-20-2020, 10:16 AM #3
    Kaper
    Kaper is offline
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,620

    Re: combining WENN function 3 times

    I might misunderstood you so try also:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 03-20-2020, 10:32 AM #4
    MarvinP
    MarvinP is offline
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: combining WENN function 3 times

    Hi slobr and welcome to the forum,

    I'm not good with German but see the attached where I've used the Switch() function to change your "-" to zero and "unlimited" to 1000. Then your formula works because it knows how to deal with numbers instead of text.
    Here is the formula:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    Switch to Fix Dropdown Text to Number.xlsx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.
    Reply With QuoteRegister To Reply
  5. 03-20-2020, 10:37 AM #5
    slobr
    slobr is offline
    Registered User
    Join Date
    03-20-2020
    Location
    zürich
    MS-Off Ver
    MS office
    Posts
    2

    Re: combining WENN function 3 times

    That one does it thanks for the quick help !
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Combining two times
    By rutilusss in forum Excel General
    Replies: 8
    Last Post: 02-28-2020, 09:23 PM
  2. HELP... Combining 2 tables into 1, repeat individual ocurrances n times
    By kiwinho in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-22-2018, 10:01 AM
  3. Wenn Zelle Spalte hat Inhalt bitte nimm die nächste Spalte
    By Apholis in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-08-2016, 04:45 AM
  4. Wenn Zelle Spalte hat Inhalt bitte nimm die nächste Spalte
    By Apholis in forum Non English Excel
    Replies: 1
    Last Post: 09-08-2016, 04:32 AM
  5. Excel wenn and funkction
    By excelok123 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-22-2015, 06:28 PM
  6. Display the Date correctly - Datum per WENN funktion umformatieren
    By Struktogramm in forum Excel General
    Replies: 0
    Last Post: 06-12-2014, 01:51 PM
  7. Combining Times
    By kingsolo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-01-2011, 01:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1