Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to calculate 4 possible answers in one cell
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to calculate 4 possible answers in one cell
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to calculate 4 possible answers in one cell
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
One formula, many possible answers. | Excel Discussion (Misc queries) | |||
How do you calculate text into numerical answers? | Excel Worksheet Functions | |||
Calculate mean of test scores from rows of test answers | Excel Discussion (Misc queries) | |||
using formula with several possible answers | Excel Worksheet Functions | |||
formula gives 2 different answers | Excel Worksheet Functions |