Posted to microsoft.public.excel.worksheet.functions

Pat[_2_]

external usenet poster

Posts: 14

Creating an IF / AND statement

Is there a way to create an if statment that involves two different cells;
ie "IF B2=3, AND C2=1, YES, NOT YET"

I've tried: =IF(B2=3,(AND(C2=1,"YES","Not yet")))
but it returns a #Value! error.

Thank you!

--
Thanks, Pat

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
Creating ODBC link within SELECT statement	Ron Coderre	Excel Worksheet Functions	0	January 31st 06 01:57 PM
Creating ODBC link within SELECT statement	Ron Coderre	Links and Linking in Excel	0	January 31st 06 01:57 PM
Creating ODBC link within SELECT statement	Ron Coderre	Charts and Charting in Excel	0	January 31st 06 01:57 PM
Creating ODBC link within SELECT statement	Ed Ferrero	Charts and Charting in Excel	0	January 31st 06 07:48 AM
If statement to avoid Creating Circular Reference	Tim H	Excel Worksheet Functions	3	December 22nd 05 05:37 AM

All times are GMT +1. The time now is 04:34 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us