+ Reply to Thread
Results 1 to 3 of 3

Help with IF AND OR function please

  1. #1
    Registered User
    Join Date
    11-20-2012
    Location
    Sheffield, UK
    MS-Off Ver
    Excel 2003
    Posts
    5

    Help with IF AND OR function please

    Hi
    I'm trying to write a formula using IF AND and OR. It needs to calculate:

    if b>0
    or a>0 and ((c+d)>786
    then do ((c+d)*0.065)
    or return a Zero

    so far, I have got this, but Excel helpfully tells me I am missing a bracket, but not where - can anyone please help before I lose it completely!! Thanks, Nim

    IF(OR(AND(B>0),AND(A>0,((C+D)>786),((C+D)*0.065),0)

  2. #2
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Help with IF AND OR function please

    =if(or(b>0,and(a>0,(c+d)>786)),(c+d)*0.065,0)
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Help with IF AND OR function please

    Would you pls give a try to this?

    =IF(OR(AND(B2>0,A2>0),AND((C2+D2)>786)),((C2+D2)*0.065),0)
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. index function error using match function to get data from a cell in an array
    By mabildgaard in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-17-2013, 02:21 AM
  2. [SOLVED] Using Offset function as the array in the PercentRank function is giving wrong result
    By Bobneil in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-06-2013, 09:29 PM
  3. Replies: 1
    Last Post: 03-21-2012, 11:22 AM
  4. Replies: 2
    Last Post: 03-20-2009, 01:29 PM
  5. Excel - User Defined Function Error: This function takes no argume
    By BruceInCalgary in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2006, 04:05 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1