Posted to microsoft.public.excel.worksheet.functions

Don B[_2_] Don B[_2_] is offline

external usenet poster

Posts: 5

IF Statement return wrong comparison

I have a If statement in L95 as follows: IF(L95="District Did Not Investigate" and L95 contains this statement It returns a FALSE answer when the answer should be TRUE. WHY?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
I'm trying to do a comparison if statement but it is not working!!	Brett Smith[_2_]	Excel Programming	4	February 28th 06 06:52 PM
wts wrong with this statement	Jason	Excel Worksheet Functions	2	February 24th 06 02:26 PM
HELP: Comparison IF statement	R Weeden	Excel Worksheet Functions	6	February 6th 06 08:55 PM
Date Comparison and IF statement	Holly	Excel Worksheet Functions	4	January 19th 06 01:01 AM
Comparison Operators for IF statement.	Shams	Excel Worksheet Functions	1	February 14th 05 03:35 PM

All times are GMT +1. The time now is 06:41 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us