Ok here is my current if statement

=IFERROR(IF(D3="","",CEILING(IF(D3<0,D3*(('MLB OVERALL'!$O$2*'MLB OVERALL'!$B$3)+$A$4)/-100,(('MLB OVERALL'!$O$2*'MLB OVERALL'!$B$3)+'Week 1a'!$A$3)/$D3*100),1)), "")
what I want to add is this

if DVBOX=true then go with the above code.
if DVBOX=false then I want to replace 'MLB OVERALL'!$O$2 with B1

thats it.

Can someone help me I go so much going on here I cant follow.

Matt