Skip to main content

Formula - whats wrong?

  • October 1, 2017
  • 1 reply
  • 17 views
T

It’s my first time with formulas. Can you see whats wrong with this one?

IF(medlemskode = 78878, IF(medlemskode = 121381, IF(medlemskode = 121380, “ordinært medlem”, “støttemedlem”, “studentmedlem”)

    This topic has been closed for replies.

    1 reply

    C
    • Christoff
    • Known Participant
    • October 1, 2017

    An IF statement follows this logic:
    If the value is true, then you want whatever you specify after the first comma.
    If the value is false, then you want whatever you specify after the second comma.

    Technically:
    IF(logical, value1, value2) returns value1 if the logical argument is true, otherwise it returns value2.

    I think you want this:
    IF(medlemskode=78878,“ordinært medlem”, IF(medlemskode=121381,“støttemedlem”, IF(medlemskode=121380,“studentmedlem”,“ukjent”)))

    You must determine what happens if medlemskode does not equal 78878, 121381 or 121380. In my formula, you get “ukjent”.

    Also, remember that the number of opening parentheses “(” must match the number of closing parentheses “)”.

      Terms & ConditionsAccessibility statement