IF, VLOOKUP, or VBA?

A

alanad

Hello,

I'm new to Excel and need some help! It's kind of complicated, so I'l
try to explain as best as I can.

I need to create a worksheet that will perform a specific calculatio
based on a series of numbers that a user enters in a row of cells. Fo
example (P and Q are the numbers the user enters)

A B C D E F
1 P P P P P P
2 P P P P P Q
3 P P P Q P Q
4 P Q P Q P Q
 
A

alanad

I've attached a sample workbook that might help explain what I'm tryin
to do. This sample has the user select the pattern they have entere
from a dropdown list, then applys a formula. Ideally, I would like th
pattern to be recognized automatically and the applicable formul
applied

Attachment filename: testbook.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=68772
 
E

Earl Kiosterud

Alanad,

Are the numbers for P and Q fixed? Or can it be any pair of numbers in a
particular row? With 6 columns, there are 64 possible outcomes. Are there
64 formulas to apply?
 
A

alanad

There are 19 possible combinations that I'm interested in, and
specific formula would be applied depending on which combination o
numbers is entered.

P, Q, R and S denote possible numbers that a user would input in
cells of a row. They could be any number from 0 to 35.

Combination Column
Formula
A B C D E F

1 P P P P P P
1/x
2 P P P P P Q
1/2x
3 P P P Q P Q
1/2y
4 P Q P Q P Q
1/(x+y)
5 P Q P P P
 
Top