+ Reply to Thread
Results 1 to 6 of 6

How to join two "IF" formula together

  1. #1
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Excel 2007
    Posts
    605

    How to join two "IF" formula together

    Dear all,how to join two "IF" formula together ?

    CELL U6 contains below formula (say results is 33)
    IF(AND(B6>=20,C6>=13),SUM(B6:C6),0)

    How to join below formula with first formula in the cell U6 together
    IF(U6>79,"A+",IF(U6>69,"A", IF(U6>59,"A-",IF(U6>49,"B",IF(U6>39,"C",IF(U6>32,"D",IF(U6>0,"F","F")))))))

    it will be something like below
    IF(AND(B6>=20,C6>=13),SUM(B6:C6),0) IF(U6>79,"A+",IF(U6>69,"A", IF(U6>59,"A-",IF(U6>49,"B",IF(U6>39,"C",IF(U6>32,"D",IF(U6>0,"F","F")))))))

    I will be happy if i get above issue solved by Macro also ( macro will be run from cell U6 to U1000 onwards )

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: How to join two "IF" formula together

    I'm not clear on just what you want your results to show.

    IF(AND(B6>=20,C6>=13),SUM(B6:C6),0)+LOOKUP(U6,{0,33,40,50,60,70,80},{"F","D","C","B","A-","A","A+"})
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

  3. #3
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Excel 2007
    Posts
    605

    Re: How to join two "IF" formula together

    Hi,Palmetto
    After few modification it works fine , thanks.

  4. #4
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: How to join two "IF" formula together

    Glad to help. You should post your modified formula for the benefit of others finding this thread in a forum search.

  5. #5
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Excel 2007
    Posts
    605

    Re: How to join two "IF" formula together

    IF(IF(AND(B6>=20,C6>=13),SUM(B6:C6),0)>79,"a+",
    IF(IF(AND(B6>=20,C6>=13),SUM(B6:C6),0)>69,"A",
    IF(IF(AND(B6>=20,C6>=13),SUM(B6:C6),0)>59,"a-",
    IF(IF(AND(B6>=20,C6>=13),SUM(B6:C6),0)>49,"b",
    IF(IF(AND(B6>=20,C6>=13),SUM(B6:C6),0)>39,"c",
    IF(IF(AND(B6>=20,C6>=13),SUM(B6:C6),0)>32,"d",
    IF(IF(AND(B6>=20,C6>=13),SUM(B6:C6),0)>=0,"f","")))))))

  6. #6
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Excel 2007
    Posts
    605

    Re: How to join two "IF" formula together

    If((if(and(b6>=20,c6>=13),sum(b6:c6),if(count(b6:c6)<>2,"",0)))="","",if((if(and(b6>=20,c6>=13),sum(b6:c6),if(count(b6:c6)<>2,"",0)))>79,"a+",if((if(and(b6>=20,c6>=13),sum(b6:c6),if(count(b6:c6)<>2,"",0)))>69,"a", if((if(and(b6>=20,c6>=13),sum(b6:c6),if(count(b6:c6)<>2,"",0)))>59,"a-",if((if(and(b6>=20,c6>=13),sum(b6:c6),if(count(b6:c6)<>2,"",0)))>49,"b",if((if(and(b6>=20,c6>=13),sum(b6:c6),if(count(b6:c6)<>2,"",0)))>39,"c",if((if(and(b6>=20,c6>=13),sum(b6:c6),if(count(b6:c6)<>2,"",0)))>32,"d",if((if(and(b6>=20,c6>=13),sum(b6:c6),if(count(b6:c6)<>2,"",0)))>0,"f","f"))))))))

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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