Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-28-2009, 04:44 AM
sixhobbits sixhobbits is offline If formula Windows 7 If formula Office 2007
Novice
If formula
 
Join Date: Aug 2009
Posts: 6
sixhobbits is on a distinguished road
Default If formula

Hello,

I am trying to write an IF formula in sheet1 which returns "true" if ANY CELL in sheet2 = "x". Is this possible?

Thanks,

Sixhobbits
Reply With Quote
  #2  
Old 10-02-2009, 08:02 AM
CGM3 CGM3 is offline If formula Windows XP If formula Office 2007
Advanced Beginner
 
Join Date: Oct 2009
Posts: 38
CGM3 is on a distinguished road
Default

Code:
=IF(COUNTIF(sheet1!A1:IV65536,"x")>0,True,False)
That's using 65,536 as the maximum number of rows a worksheet can have, and 256 as the maximum number of columns. If you don't expect that much of sheet1 to be used, you can use lower values.

In fact, you can select the region of sheet1 you need to check, name it (Insert | Name | Define) and use that name in the formula, redefining the area it covers as necessary:
Code:
=IF(COUNTIF(LookForX,"x")>0,True,False)
Of course, this only works if "x" is the only character in a cell.

Last edited by CGM3; 10-02-2009 at 10:29 AM.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
If formula Formula assistance please blazzercat Excel 2 07-08-2009 08:45 AM
If formula Range Formula aleksandr Excel 10 05-18-2009 12:14 PM
Help for formula dehann Excel 5 05-01-2009 10:44 AM
Need another formula to match my last one tinkertron Excel 2 04-29-2009 02:17 PM
If formula Need help with a formula tinkertron Excel 11 04-16-2009 11:43 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:18 PM.


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