Guys,

I have two formulas

=IFERROR(IF(H18="","",CEILING(IF(H18<0,H18*(($C$17*'MLB OVERALL'!$E$7)+$C$16)/-100,(($C$17*'MLB OVERALL'!$E$7)+$C$16)/$H18*100),1)), "")

and

=IFERROR(IF(H18="","",CEILING(IF(H18<0,H18*(((G18*-1)*'MLB OVERALL'!$E$7)+$C$16)/-100,(((G18*-1)*'MLB OVERALL'!$E$7)+$C$16)/$H18*100),1)), "")

these two formulas are in cells
J18:J25 and on sheets
Week 1a:week 26b


what I want is to create a check box on my main sheet


which if checked does formula #2 and if unchecked does formula #1?


Is this possible and how please?


Matt