+ Reply to Thread
Results 1 to 8 of 8

How do you write a multiple IF formula

  1. #1
    Registered User
    Join Date
    05-12-2012
    Location
    Providence, RI
    MS-Off Ver
    Excel 2011 for Mac
    Posts
    3

    How do you write a multiple IF formula

    How do you write a conditional formula that answers for example IF A3 < B3 then B4 =B5 + B6, and IF A 3 = B3 then B4 = B5 * B7 and IF A3 > B3 then B4 = 0

  2. #2
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: How do you write a multiple IF formula

    =if(a3<b3,b5+b6,if(a3=b3,b5*b7,0))
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Valued Forum Contributor
    Join Date
    04-03-2012
    Location
    East Sussex, UK
    MS-Off Ver
    Excel 2003:2010
    Posts
    893

    Re: How do you write a multiple IF formula

    =if(a3<b3,b5+b6,if(a3=b3,b5*b7,if(a3>b3,0)))

  4. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,406

    Re: How do you write a multiple IF formula

    You can nest IF functions like:

    =IF(condition1, if_1_true, if_2_false)

    Then second condition goes:

    IF(condition1, IF(condition2, if_2_true, if_2_false), if_1_false)...

    And so on....

    So in your case:

    =IF(A3<B3, B5+B6, IF(A3=B3, B5*B7, 0))

  5. #5
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: How do you write a multiple IF formula

    further to that if your not sure lay it out like this
    =if(a1=x,"its x",
    if(a1=y,"its y",
    if(a1=z,"its z",
    if(a1=p,"its p","a1 doesn't equal anything"
    join them all together
    =if(a1=x,"its x",if(a1=y,"its y",if(a1=z,"its z",if(a1=p,"its p","a1 doesn't equal anything"
    count the number of IFs in this case 4 and put that many ")" at the end
    =if(a1=x,"its x",if(a1=y,"its y",if(a1=z,"its z",if(a1=p,"its p","a1 doesn't equal anything"))))

  6. #6
    Registered User
    Join Date
    05-12-2012
    Location
    Providence, RI
    MS-Off Ver
    Excel 2011 for Mac
    Posts
    3

    Re: How do you write a multiple IF formula

    Thanks guys!!!!! You solved this one. But I can;t figure out how to mark the thread solved

  7. #7
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,854

    Re: How do you write a multiple IF formula

    You can't mark it as solved because you asked it in a sub-forum in which you're not supposed to ask questions. This is an introduction forum, hence the name.

    I'll move it to another forum and then please mark it as Solved.

    Thanks.

  8. #8
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,854

    Re: How do you write a multiple IF formula

    You can't mark it as solved because you asked it in a sub-forum in which you're not supposed to ask questions. This is an introduction forum, hence the name.

    I'll move it to another forum and then please mark it as Solved.

    Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1