View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
San[_4_] San[_4_] is offline
external usenet poster
 
Posts: 26
Default How to choose a qualifier from different set of criteria or combinations


I have a set of conditions denoted by A, B, C, D and depending upon specific combinations of the conditions being true, I need to take a corresponding decision from a group of decisions denoted as 1,2,3,4,5,6

So if True or "T" for the following conditions, the corresponding decisions would be as mentioned under

Conditions True Decision Number

A,B,C,D - 1

A, C, D - 2

B, C - 3

A, B, D - 4

A, C - 5

C, D - 6


I hope I have been able to explain my problem.

Thanks for the help

San