I got an if statement that says this
=IFERROR(IF(Q3="","",IF(Q3<0,Q3*(('MLB OVERALL'!$O$2*'MLB OVERALL'!$D$3)+$A$3+I3+O3)/-100,
(('MLB OVERALL'!$O$2*'MLB OVERALL'!$D$3)+'Week 1a'!$A$3+I3+O3)/$Q3*100)), "")
However the part I am concerned about is this
+$A$3+I3+O3
What I need is this to be added someway I will write it and see what you guys think
if J3="P" then do not add I3 and if P3="P" then do not add O3.
so in this example in row 10
if
J10=L
P10=P
then it would be
+$A$3+I3
Any help would be greatly appreciated
Matt
Just concentrating on this part
+$A$3+I3+O3
Add the conditions like this:
+$A$3+if(j3="P",0,I3)+if(p3="P",0,O3)
cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks