# How to join two "IF" formula together

1. ## 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. ## 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+"})

3. ## Re: How to join two "IF" formula together

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

4. ## 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. ## 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. ## 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"))))))))

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

#### 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