Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Simple excel formula.... what am I doin wrong????

  • 12-04-2010 10:21AM
    #1
    hamsterboy
    Registered Users, Registered Users 2 Posts: 1,536 ✭✭✭


    Hi All
    Simple question.
    What the fcuk is wrong with this formula
    =IF(E17>G17 AND E17>I17,1,0)
    Its a simple check to see if E17 is larger than the other two values.
    Drivin me MAD!!!

    Cheers

    HB


Comments

  • #2
    Diddy Kong
    Registered Users, Registered Users 2 Posts: 937 ✭✭✭Diddy Kong


    You need to move the AND function, like: =IF(AND(E17>G17, E17>I17),1,0)

    More information here.


  • #3
    KAGY
    Registered Users, Registered Users 2 Posts: 1,077 ✭✭✭KAGY


    Diddy Kong wrote: »
    You need to move the AND function, like: =IF(AND(E17>G17, E17>I17),1,0)

    More information here.

    Yep, all function in excel, including boolean operators need their variables in brackets and separated by commas.

    In this case here you don't even need the if statement,
    =AND(E17>G17, E17>I17)
    will return TRUE or FALSE (you can even use this cell in a calculation where TRUE is taken as 1 and FALSE as 0)


Advertisement