Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,514
Default If statement checking list

Correction...

=IF(COUNTIF(ListRange,Criteria)0,"Yes","No")

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF statement checking if a cell's text is red Shazzer Excel Worksheet Functions 7 April 3rd 23 02:40 PM
Checking whether a value in a list is present in a second list [email protected] Excel Discussion (Misc queries) 5 June 1st 07 02:30 PM
checking for a value in a list kcrad Excel Discussion (Misc queries) 3 March 13th 07 04:20 PM
If Statement Checking Formula NOT Value in a Cell Marathon Excel Discussion (Misc queries) 7 January 28th 07 10:31 PM
Checking if value is in a list roeaster Excel Worksheet Functions 1 April 15th 05 05:00 PM


All times are GMT +1. The time now is 05:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"