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 |
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 |