The example returns the message "Too Many Arguments". I have tried a few variations but always with the same result

=IF(AND(B4="Win",D43>1,OR(C24="NR",D24="NR",E24="W")),W6,IF(AND(B4="Win",D43>1),OR(C24="NR",D24="W",E24="NR")),W5,IF(AND(B4="Win",D43>1),OR(C24="W",D24="NR",E24="NR")),W4),B3)

Cells B4 & D43 have constant values for each combination so perhaps can be included only once

The Range is C24:E24 In this instance 3 different combination of values "W" and "NR"

Combination 1 if TRUE = Value Cell W6

Combination 2 if TRUE = Value Cell W5

Combination 3 if TRUE = Value Cell W4

If ALL combinations FALSE = Value Cell B3

I will also need to be able to expand the formula to include a range of 5 cells generating up to 25 different combinations with up to 5 instances of NR.

Also, this is to find a solution where there are a minimum of 2 instances of "NR" in each combination.

If the formula was to include just one instance of NR the the number of combinations would significantly increase and each combination would require a specific cell value when TRUE. I already have a solution to this so this would only be a "Nice To Have " option if a concatenated option is available.

Any help would be grateful received