Help required in modifying IF Statement

[grcshekar71]

=IF(INDEX(EmployeeMaster!O:O,MATCH(H2,EmployeeMaster!A:A,0))="Y",IF(SUM(Y2:AD2)>=SUM(S2:X2),0,IF(SUM(S2:X2)>15000,15000*12%,SUM(S2:X2)*12%)),0).

This formula is intended to work as follows.

IF SUM(S2:X2) - SUM(Y2:AD2) >= SUM(S2:X2) * 12%
THEN RESULT
ELSE 0

Also H2,EmployeeMaster!A:A,0))="Y" is only a flag check if Y then continue evaluating formula else no

But it is not working. It works only if SUM(Y2:AD2) = SUM(S2:X2)

 

[DanteAmor]

but in your example the two conditions are false. could you again, without formulas, describe the conditions. Write an example with values for each condition.

 

[grcshekar71]

I still have an error.

=IF(INDEX(EmployeeMaster!O:O,MATCH(H2,EmployeeMaster!A:A,0))="Y",IF((AND(SUM(S2:X2)<=Parameters!$B$5,
SUM(S2:X2)-SUM(Y2:AD2)>=SUM(S2:X2)*Parameters!$B$6%)), SUM(S2:X2)*Parameters!$B$6%,IF((AND(SUM(S2:X2)>Parameters!$B$5, SUM(S2:X2)-SUM(Y2:AD2)>=Parameters!$B$5*Parameters!$B$6%)), Parameters!$B$5*Parameters!$B$6%,0)))

If EmployeeMaster!O:O,MATCH(H2,EmployeeMaster!A:A,0))="Y". If this is "N" it is displaying at FALSE instead of 0

 

[grcshekar71]

IF EmployeeMaster!O:O,MATCH(H2,EmployeeMaster!A:A,0))="Y" only then formula should work else 0

After this, Condition 1
If SUM(S2:X2)>15000 AND SUM (S2:X2)*12%> SUM (Y2:AD2) THEN SUM (S2:X2)*12% ELSE 0

If SUM(S2:X2)<=15000 AND 15000*12%> SUM (Y2:AD2) THEN 15000*12% ELSE 0

 

[grcshekar71]

This works

=IF(INDEX(EmployeeMaster!O:O,MATCH(H2,EmployeeMaster!A:A,0))="Y",IF((AND(SUM(S2:X2)<=Parameters!$B$5,
SUM(S2:X2)-SUM(Y2:AD2)>=SUM(S2:X2)*Parameters!$B$6%)), SUM(S2:X2)*Parameters!$B$6%,IF((AND(SUM(S2:X2)>Parameters!$B$5, SUM(S2:X2)-SUM(Y2:AD2)>=Parameters!$B$5*Parameters!$B$6%)), Parameters!$B$5*Parameters!$B$6%,0)),0)

 

[DanteAmor]

Glad to hear you found the solution.