Formula to calculate 4 possible answers in one cell

  • Thread starter Thread starter Adrian
  • Start date Start date
A

Adrian

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 :-)
 
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))
 
Thanks very much Don - it worked a treat :-)))) You've just made my life a
whole lot easier!!!
--
Many thanks

Adrian


Don Guillett said:
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))
Click to expand...
 
Glad to help

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
Adrian said:
Thanks very much Don - it worked a treat :-)))) You've just made my life
a
whole lot easier!!!
Click to expand...
 
Back
Top