# IF Formula Help & making formulas shorter

#### jb00976

##### New Member
I have this formula which works if 'AM Targets'!F6=Budgets!\$H\$3 :

=IF('AM Targets'!C6=Budgets!\$L\$5,Budgets!\$M\$6,IF(AND('AM Targets'!C6=Budgets!\$G\$4,'AM Targets'!F6=Budgets!\$H\$3),Budgets!\$H\$4,IF(AND('AM Targets'!C6=Budgets!\$G\$5,'AM Targets'!F6=Budgets!\$H\$3),Budgets!\$H\$5,IF(AND('AM Targets'!C6=Budgets!\$G\$6,'AM Targets'!F6=Budgets!\$H\$3),Budgets!\$H\$6))))

The first part of the formula
=IF('AM Targets'!C6=Budgets!\$L\$5,Budgets!\$M\$6, needs to stay however how do I get different outputs if 'AM Targets'!F6=Budgets!\$H\$7 or 'AM Targets'!F6=Budgets!\$H\$11

Output if 'AM Targets'!F6=Budgets!\$H\$7 as follows:

IF(AND(C6=Budgets!\$G\$4,'AM Targets'!F6=Budgets!\$H\$7),Budgets!\$H\$8,IF(AND(C6=Budgets!\$G\$5,'AM Targets'!F6=Budgets!\$H\$7),Budgets!\$H\$9,IF(AND(C6=Budgets!\$G\$6,'AM Targets'!F6=Budgets!\$H\$7),Budgets!\$H\$10))),

Output if 'AM Targets'!F6=Budgets!\$H\$11 as follows:

IF(AND(C6=Budgets!\$G\$4,'AM Targets'!F6=Budgets!\$H\$11),Budgets!\$H\$12,IF(AND(C6=Budgets!\$G\$5,'AM Targets'!F6=Budgets!\$H\$11),Budgets!\$H\$12,IF(AND(C6=Budgets!\$G\$6,'AM Targets'!F6=Budgets!\$H\$11),Budgets!\$H\$12)))

I am looking for how to put this together properly (not sure if OR would be used) and maybe how to make it shorter.

-------------------------------------------------------------------------------

On a second formula I have:
=IF(D6=Budgets!\$B\$4,Budgets!\$C\$4,IF('AM Targets'!D6=Budgets!\$B\$5,Budgets!\$C\$5,IF('AM Targets'!D6="Hybrid",((Budgets!\$C\$4+Budgets!\$C\$5)/2))))

I am looking how to make it shorter if possible.

EDIT:
Also, how to make this formula shorter:
=IF(AND(D6=Budgets!\$L\$10,'AM Targets'!F6=Budgets!\$M\$10),Budgets!\$N\$10,IF(AND(D6=Budgets!\$L\$10,'AM Targets'!F6=Budgets!\$M\$11),Budgets!\$N\$11,IF(AND(D6=Budgets!\$L\$12,'AM Targets'!F6=Budgets!\$M\$12),Budgets!\$N\$12,IF(AND(D6=Budgets!\$L\$12,'AM Targets'!F6=Budgets!\$M\$13),Budgets!\$N\$13,IF(AND(D6=Budgets!\$L\$12,'AM Targets'!F6=Budgets!\$M\$14),Budgets!\$N\$14,IF(AND(D6=Budgets!\$L\$12,'AM Targets'!F6=Budgets!\$M\$15),Budgets!\$N\$15, IF(AND(D6="Hybrid",'AM Targets'!F6=Budgets!\$M\$10),(Budgets!\$N\$10+Budgets!\$N\$12)/2,IF(AND(D6="Hybrid",'AM Targets'!F6=Budgets!\$M\$11),(Budgets!\$N\$11+Budgets!\$N\$13)/2))))))))

Last edited by a moderator:

### Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Replies
1
Views
211
Replies
1
Views
207
Replies
6
Views
229
Replies
3
Views
416
Replies
21
Views
660