Posted to microsoft.public.excel.misc

Andy

external usenet poster

Posts: 414

logic statement

Hope someone can help, as i am not too good at functions (Is there a book
with examples in??)

i would like to know a statement that will allow 1 answer cell to have two
conditions from two seperate work books.
if 1 work book cell is eg "OK" then one answer would be "N"
if the other work book cell was "y" then the answer would be "Y"

Only one cell either OK or Y would be populated. the other would be blank.

Regards

Andy

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
Logic Statement	Marc[_4_]	Excel Discussion (Misc queries)	2	May 22nd 08 07:41 PM
Need help w/ logic statement in excel	bettinab	Excel Worksheet Functions	2	August 26th 06 02:00 AM
rather complex logic statement	[email protected]	Excel Worksheet Functions	6	March 31st 06 08:32 PM
Logic Statement	abierly	Excel Worksheet Functions	3	March 14th 06 06:13 PM
Two Logic tests in an IF Statement	timmadge	Excel Worksheet Functions	2	February 7th 06 03:15 PM

All times are GMT +1. The time now is 11:46 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us