Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel "IF" operation help!!

  • 01-09-2011 1:16pm
    #1
    jaybeeveedub
    Registered Users, Registered Users 2 Posts: 275 ✭✭


    My visual basic is pretty rusty and I am struggling to generate an IF test...

    What I want to do is fairly straightforward..... I have two columns which I want if to test but I cant seem to nest two tests within the logical test....

    here's what I want to do.... one column is no. purchased (1 or 2) second column is discount (yes or no)... what I had tried was...

    =IF(G2>1 AND H2=yes,"400",IF(G2>1 AND H2<>yes"440",IF etc...

    however even if I reduce it to

    =IF(G2>1 AND H2=yes,"400,"440") I am still getting an error....

    Is it possible to have a logical test comprising two separate tests? and if so how should it be parsed!!


Comments

  • #2
    Mack_Attack
    Registered Users, Registered Users 2 Posts: 49 ✭Mack_Attack


    To combine the two IF statements you mentioned, try the following:

    =IF(AND(A2>1,B2="Yes"),400,440)


  • #3
    jaybeeveedub
    Registered Users, Registered Users 2 Posts: 275 ✭✭jaybeeveedub


    perfect!! many thanks


Advertisement