About Us

Don Guillett

Glad to help

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Adrian" wrote in message
...
Thanks very much Don - it worked a treat :-)))) You've just made my life
a
whole lot easier!!!
--
Many thanks

Adrian

"Don Guillett" wrote:

Probably should be more detail to account for blanks, etc but this should
do
=IF(a2="Y",IF(b2="Y","lb","ld"),IF(b2="N","wl",$D$ 1))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Adrian" wrote in message
...
Hi

The following 2 columns can both contain either a "Y" for Yes or an "N"
for
No so there are 4 possible outcomes for each row. I require a formula
for
cell C1 which can return 1 of the 4 possible outcomes depending on the
Y
N
combination

i.e. if
Column A= Column B= then Column C =
Y Y "LBCC16A0" (text)
Y N "LDLL16A0" (text)
N Y a figure in cell D1
N N "Enter WLAD Ref" (text)

I've tried an IF function and seem to be close but it only seems to go
so
far. Would really appreciate some assistance :-)

--
Many thanks

Adrian

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
One formula, many possible answers.	GARDNERGUY	Excel Discussion (Misc queries)	1	April 5th 07 08:56 AM
How do you calculate text into numerical answers?	tyler8	Excel Worksheet Functions	4	November 3rd 06 10:38 PM
Calculate mean of test scores from rows of test answers	RiotLoadTime	Excel Discussion (Misc queries)	1	July 26th 06 05:14 PM
using formula with several possible answers	jog398	Excel Worksheet Functions	3	May 19th 06 02:39 AM
formula gives 2 different answers	klee	Excel Worksheet Functions	3	January 10th 06 12:58 PM