I have to calculate commission with check box, if the check box is unchecked we donot have to pay comm ,
the last formula i have *(I51-0.25)that's what i have added . seems likes is not correct. can some one please help, i want to show if the check box the checked we want to pay comm .
if the info i posted is not clear please let me know ,






Model Checkbox Disc % Comm Cal
350S1G4 TRUE $55,571.27 $136,500.00 $102,375.00 $34,125.00 25.00% $6,162.98
=IFERROR(IF(J11>0,IF(F11,K11*($K$52-($M11*$R$13)),K11*($K$52-($M11*$R$13))*(($I$51-0.25)/$I$51))),"")