Hi there!

I have a problem creating a formula that would contain multiple conditions
with only one possible answer.

If a5=1 and b5=0 and c5=1 and d5=1 Then e5=1
If a5=1 and b5=0 and c5=1 and d5=2 Then e5=1
If a5=1 and b5=0 and c5=2 and d5=1 Then e5=1
If a5=1 and b5=0 and c5=2 and d5=2 Then e5=1
If a5=1 and b5=0 and c5=3 and d5=1 Then e5=2
If a5=1 and b5=0 and c5=3 and d5=2 Then e5=2
If a5=2 and b5=1 and c5=1 and d5=1 Then e5=2
If a5=2 and b5=1 and c5=1 and d5=2 Then e5=2
If a5=2 and b5=1 and c5=2 and d5=1 Then e5=2
If a5=2 and b5=1 and c5=2 and d5=2 Then e5=3
If a5=2 and b5=1 and c5=3 and d5=1 Then e5=3
If a5=2 and b5=1 and c5=3 and d5=2 Then e5=4
If a5=2 and b5=2 and c5=1 and d5=1 Then e5=3
If a5=2 and b5=2 and c5=1 and d5=2 Then e5=4
If a5=2 and b5=2 and c5=2 and d5=1 Then e5=4
If a5=2 and b5=2 and c5=2 and d5=2 Then e5=5
If a5=2 and b5=2 and c5=3 and d5=1 Then e5=5
If a5=2 and b5=2 and c5=3 and d5=2 Then e5=6

Is it possible? Help!

Thanks in advance for your help!

Greywolf
--
Thanks !

Greywolf