IF OR statement with multiple ORs

ClassicSarah

The following statement works...

=IF(OR([Commission Structure]@row = "HouseAcct-Estimator", [Commission Structure]@row = "Est & AM Shared", [Commission Structure]@row = "BizDev&Est"), 0.1 * [Profit before Commissions]@row, 0)

But, when I try to add a second OR I get unparseable error.

=IF(OR([Commission Structure]@row = "HouseAcct-Estimator", [Commission Structure]@row = "Est & AM Shared", [Commission Structure]@row = "BizDev&Est"), 0.1 * [Profit before Commissions]@row, ([Commission Structure]@row = "Jr Est & Est Shared"),0.05*[Profit before Commissions]@row), 0)

How do I fix the error?

Sameer Karkhanis

I believe you are trying to say that if the first OR condition is true then calculate 0.1 times profit before commissions, else if commission structure is "Jr Est & Est Shared" then calculate 0.05 times of the profit before commission else return 0. In that case its not a OR condition, it is else if condition, and the formula should written be as shown below,

=IF(OR( [Commission Structure]@row = "HouseAcct-Estimator", 
	[Commission Structure]@row = "Est & AM Shared", 
	[Commission Structure]@row = "BizDev&Est"
      ), 
	0.1 * [Profit before Commissions]@row, 
	IF([Commission Structure]@row = "Jr Est & Est Shared", 0.05*[Profit before Commissions]@row, 0)
)

Sameer Karkhanis

I believe you are trying to say that if the first OR condition is true then calculate 0.1 times profit before commissions, else if commission structure is "Jr Est & Est Shared" then calculate 0.05 times of the profit before commission else return 0. In that case its not a OR condition, it is else if condition, and the formula should written be as shown below,

=IF(OR( [Commission Structure]@row = "HouseAcct-Estimator", 
	[Commission Structure]@row = "Est & AM Shared", 
	[Commission Structure]@row = "BizDev&Est"
      ), 
	0.1 * [Profit before Commissions]@row, 
	IF([Commission Structure]@row = "Jr Est & Est Shared", 0.05*[Profit before Commissions]@row, 0)
)