On Wednesday, January 16, 2019 at 1:29:53 AM UTC+5:30, MyVeryOwnSelf wrote:
Not knowing what the conditions are, I temporarily used cells A1,B1,C1,D1 to hold TRUE-or-FALSE values to test my approach. These four correspond to the conditions A,B,C,D.

This formula seems to meet the need:
=IFERROR(MATCH(--A1--2*B1--4*C1--8*D1,
{15,13,6,11,5,12},0), "")

In real life, dont use A1,B1,C1,D1, of course. Instead, replace them with the required conditions. Replacing A1,B1,C1,D1 with four real-life conditions might look something like:
=IFERROR(MATCH(--(K7<5)
--2*(J7+8P7)
--4*OR(Q7100,Q7<0)
--8*(TODAY()+60R7),
{15,13,6,11,5,12}, 0), "")

Explanation: There are sixteen possible combinations of TRUE/FALSE values for the four conditions. The expression
--A1--2*B1--4*C1--8*D1
assigns a different number to each combination. For example, the combination number 15 is what the expression returns from the "conditions true" for decision number 1. The array {15,13,6,11,5,12} lists the combination numbers for the six "conditions true" lines in the original post. Since 15 is the first entry in {15,13,6,11,5,12}, the MATCH returns 1 (as required) when
--A1--2*B1--4*C1--8*D1
is 15; that is, when conditions A, B, C, D are true. Likewise, the conditions for decision number 2 produce combination number 13, causing the MATCH to return 2, etc. For combinations that do not appear in the original post, IFERROR makes the result an empty string, since no decision number applies.

Hope this helps getting started.

Thanks a ton for the help. In fact I was trying to use the "Choose" function but it was not working. Just want to know regarding the assigning of 1 for A, 2 for B, 4 for C and 8 for D. Is this assigning of 1,2,4,8, in anyway related to the maximum no. of combinations of 4 conditions or is it just to arrive at a unique value for each set of True/False?