![]() |
#1
|
|||
|
|||
![]() 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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
If-Then help needed | sammipd | Mail Merge | 1 | 04-24-2013 04:38 AM |
Serious help needed. | karlyak22 | Outlook | 0 | 11-13-2011 07:32 AM |
![]() |
ytryity | Misc | 1 | 03-19-2011 09:07 AM |
![]() |
thunder14 | Word | 1 | 10-17-2009 02:57 PM |
![]() |
thechief55 | PowerPoint | 1 | 04-28-2009 01:25 PM |