Forum Discussion
CBHenry
May 06, 2021Copper Contributor
Formulas with Tab Names
I am currently working with the below formula and it has worked well so far. However, I am now needing to change the list the data is pulled from to a new tab/sheet and the calendar the formula creat...
Yea_So
May 10, 2021Bronze Contributor
in this statement:
=IF(AND(M$4>=(List!$G6), M$4<=List!$G6),"C",IF(List!$I6=M$4,"E",IF(List!$K6=M$4,"R",0)))
the statements inside the AND is conflicted:
AND(M$4>=(List!$G6), M$4<=List!$G6)
it can't be both, either $M$4>= List!$G6
OR
$M$4<=List!$G6
So which is it?
=IF(AND(M$4>=(List!$G6), M$4<=List!$G6),"C",IF(List!$I6=M$4,"E",IF(List!$K6=M$4,"R",0)))
the statements inside the AND is conflicted:
AND(M$4>=(List!$G6), M$4<=List!$G6)
it can't be both, either $M$4>= List!$G6
OR
$M$4<=List!$G6
So which is it?