Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 1

Problem with AND function

I'm using the function as shown below

=IF(AND((COUNTBLANK(O14:AE14)<17),L140),N14*L14, "enter project")

essential =IF(AND(TRUE, TRUE), do this, else "enter project"

however, I'm getting "enter project" even if only one of the options is TRUE.

I thought the whole point of AND was that BOTH had to be TRUE?

Any ideas???

Excel 2003

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
If function problem	chrisnsmith	Excel Discussion (Misc queries)	5	February 7th 09 07:52 AM
Problem in If function	Junaid	Excel Worksheet Functions	7	January 27th 09 10:53 AM
Problem with IRR function	Keith	Excel Worksheet Functions	2	May 21st 07 01:40 PM
Function problem	Winnie	Excel Discussion (Misc queries)	2	October 9th 06 01:31 PM
Problem with IF function	haitch2	Excel Worksheet Functions	3	October 10th 05 01:05 AM

All times are GMT +1. The time now is 09:54 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us