=(CODE(UPPER(A1))-64)*NOT(B1)

--
Regards,
Tom Ogilvy

"Kikkoman" wrote in message
...
sorry didn't make myself clear...

if choose a & T, result 0
if choose a & F, result 1
if choose b & T, result 0
if choose b & F, result 2
if choose c & T, result 0
if choose c & F, result 3

Thanks for helping

"Bob Phillips" wrote:

You don't say how so a guess

=IF(AND(A1="a",B1=TRUE),1,IF(AND(A1="b",B1=FALSE,2 ,3))

--
HTH

Bob Phillips

"Kikkoman" wrote in message
...
in cell A1: from a dropdown list - choose a, b or c
in cell B1: from a dropdown list - true or false
in cell C1: Results will depend on A1 and B1 - give 1, 2 or 3