Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 07-29-2013, 08:37 AM
s7y s7y is offline If or help needed Windows 7 32bit If or help needed Office 2010 32bit
Advanced Beginner
If or help needed
 
Join Date: May 2012
Posts: 38
s7y is on a distinguished road
Default 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
Reply With Quote
 



Similar Threads
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
If or help needed Frontpage help needed ytryity Misc 1 03-19-2011 09:07 AM
If or help needed help needed!!! thunder14 Word 1 10-17-2009 02:57 PM
If or help needed Help needed :) thechief55 PowerPoint 1 04-28-2009 01:25 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:34 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft