IF multiple conditions

[Dexir]

Hi All, i have this sheet with IF conditions, please let me know if there is any short formula for this. i have mentioned only "TSM & RSM" in this sheet, but i have more than 6 ranks with different criteria of incentive. Thanks

Training.xlsx
	B	C	D	E	F
5	Rank	Jul-24	Aug-24	Sep-24	Incentive
6	RSM	105%	0%	0%	6667
Sheet2

Cell Formulas
Range	Formula
F6	F6	=IF(C6="0%",0,IF(D6="0%",0,IF(E6="0%",0,IF(AND(B6="TSM",C6>=105%),12000/3,IF(AND(B6="TSM",D6>=105%),15000/3,IF(AND(B6="TSM",E6>=105%),18000/3,IF(AND(B6="RSM",C6>=105%),20000/3,IF(AND(B6="RSM",D6>=105%),25000/3,IF(AND(B6="RSM",E6>=105%),30000/3,)))))))))

 

[Joe4]

You can enlist the use of ORs to shorten your formula.
For example, these 3 checks you have at the beginning:

=IF(C6="0%",0,IF(D6="0%",0,IF(E6="0%",0,...

could be shortened to this:

=IF(OR(C6="0%",D6="0%",E6="0%"),0,...