Thread: IF AND question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gamq Gamq is offline
external usenet poster
 
Posts: 1
Default IF AND question

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