Wanting To Add More Text To A IF Formula

[Treesh1994]

I would like to add more texts after "99B" but I keep getting #Spill.

Here is the formula that I am using that is currently working

=IF(H22="","",IF(H22="99B",-AT$1,AT$1*(1+OR(H22={"ELUC3H010D","EMPS1STS4RBW","EMPS2QMS5RBW","EMPS2STS5RBW","ELUC3H010W","PLUCTCL1","PMP2BKDGAJ","EMPS1STS1W","EMPS1QMS4RBW","VTX609C","VTXADAPT","I3JC"}))))

I have other options after the "99B" such as "Deduct Front Cage", "Deduct Rear Cage" Ect.

The only way I found so far is to keep repeating IF(H22="99B",-AT$1*AT$1,IF(H22="Deduct Front Cage",-AT$1*AT$1,IF(H22="Deduct Rear Cage",-AT$1*AT$1

I am trying to see if there is a better way to do this. Also each item has the word "Deduct" not sure if this helps making a formula based on a contained word

Any help would be greatly appreciated!

 

[DanteAmor]

Is it what you need?

=IF(H22="","",IF(OR(H22={"99B","Deduct Front Cage","Deduct Rear Cage"}),-AT$1,AT$1*(1+OR(H22={"ELUC3H010D","EMPS1STS4RBW","EMPS2QMS5RBW","EMPS2STS5RBW","ELUC3H010W","PLUCTCL1","PMP2BKDGAJ","EMPS1STS1W","EMPS1QMS4RBW","VTX609C","VTXADAPT","I3JC"}))))

 

[Treesh1994]

Is it what you need?

=IF(H22="","",IF(OR(H22={"99B","Deduct Front Cage","Deduct Rear Cage"}),-AT$1,AT$1*(1+OR(H22={"ELUC3H010D","EMPS1STS4RBW","EMPS2QMS5RBW","EMPS2STS5RBW","ELUC3H010W","PLUCTCL1","PMP2BKDGAJ","EMPS1STS1W","EMPS1QMS4RBW","VTX609C","VTXADAPT","I3JC"}))))

Yes that is exactly what I am looking for!

Thank you so much!
It appears that I didn't include the extra "",!

I appreciate your help!