If or help needed
hello everybody,
I have a cell that, based on a if or formula, should return 0 or 1.
The formula is
"=IF(OR('Limitations (2)'!I17<'Limitations (2)'!K17;'Limitations (2)'!I16<'Limitations (2)'!J16;'Limitations (2)'!I15<'Limitations (2)'!J15;'Limitations (2)'!I14<'Limitations (2)'!J14;'Limitations (2)'!I13<'Limitations (2)'!J13;'Limitations (2)'!I12<'Limitations (2)'!J12;'Limitations (2)'!I11<'Limitations (2)'!J11);1;0)"
the thing is that I don't get the result that I am looking for. What am I doing wrong?
what I am trying to write is "if any of the cells =< the the other then the result should be 1"
Last edited by s7y; 07-29-2013 at 08:39 AM.
Reason: completion of the question
|