A less complicated Multiple IF Statement

[nutrijenna]

Hi,


I'm wondering if we can make this Multiple IF Statement a less complicated one.


=if(J2="Free Minutes - New Client/Welcome Email",0,
if(J2="Free Minutes - Payoff/Bonus", 0,
if(J2="Internal - Not Billed",0,
if(J2="Billed Minutes - Peak", H2*0.25,
if(J2="Billed Minutes - Off-Peak", H2*0.38,
if(J2="Pre-Task Activities", 0,
if(J2="Admin",0
)))))))


Thanks in advance!!!

 

[Gerald Higgins]

Hi, welcome to the board.

There are lots of ways of simplifying this.

Here's one . . .
=((RIGHT(J2,4)="Peak")*H2*0.25)+((RIGHT(J2,8)="Off-Peak")*H2*0.13)

 

[Fluff]

Another option, like
=IF(OR(J2={"Free Minutes - New Client/Welcome Email","Free Minutes - Payoff/Bonus","Internal - Not Billed","Pre-Task Activities","Admin"}),0,IF(J2="Billed Minutes - Peak", H2*0.25,IF(J2="Billed Minutes - Off-Peak", H2*0.38,"")))