Use the below formula for your first query.
=IF(A1="","",IF(A1=2,95,IF(AND(A1=1,A2=3),106,IF(A ND(A1=1,A2=4),104))))

I am not clear about your second query.

Remember to Click Yes, if this post helps!
--------------------
(Ms-Exl-Learner)
--------------------

"Gamq" wrote in message
...
Hi there,

I need a function that can provide one of three answers:

1 2 1 1...
3 3 4 4...
? ? ? ?...

If A1 = 1 and A2=3, answer 106; but if A1=1 and A2 = 4, answer 104; but if
A1=2, regardless of A2, answer 95.

The next function for column B is the same, except the answer is dependent
on the value delivered from the column A function. E.g. A3 + 6 or A3 +4 or
A3-5 etc.

Any help would be most appreciated.
--
*****
Many thanks
Gamq