+ Reply to Thread
Results 1 to 2 of 2

Syntax error IF-OR-funktion

  1. 01-18-2021, 08:12 AM #1
    Nobinx
    Nobinx is offline
    Registered User
    Join Date
    01-18-2021
    Location
    Germany
    MS-Off Ver
    Exel 2013, Version 15.0.5301.1000
    Posts
    1

    Syntax error IF-OR-funktion

    Hello,

    can anyone tell me, why my formula dosn't work?

    Excel dosn't understand my ="yes"

    =IF(OR('T1'!K1="yes";'T1'!L1="yes");"";'T2'!J1)



    Many thanks!
    Reply With QuoteRegister To Reply
  2. 01-18-2021, 08:16 AM #2
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: Syntax error IF-OR-funktion

    1. Are calculation options set to automatic?

    2. Did you mean T2? =IF(OR('T1'!K1="yes";'T1'!L1="yes");"";'T2'!J1)

    3. There is nothing wrong with your formula.
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    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. [SOLVED] Compile error syntax error - spellnumber microsoft code
    By sunboy in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-13-2022, 02:53 AM
  2. [SOLVED] Runtime Error '3075': Syntax error in the string in the query expression [SQL]
    By leegrj in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-28-2020, 04:11 PM
  3. Need Help with VBA Code- cannot run Compile Error/Syntax error - sheet number mismatch
    By nkhiangte in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-28-2019, 04:55 AM
  4. Excel macro (compile error. syntax error.) error
    By salar_younis in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-06-2014, 06:11 AM
  5. [SOLVED] first timer using VB to cut and paste macro - getting compile error syntax error
    By jopedder in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-24-2013, 11:45 AM
  6. Receiving following error “Complie error : syntax error” Help
    By masond3 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-02-2012, 10:19 AM
  7. Syntax Error and Compile Error: Expected Line Number or Label...
    By AnthonyWB in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-31-2011, 09:59 AM

Tags for this Thread

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