Assign number to combination of checkboxes

[laguna92651]

I have 3 conditions set with checkboxes, I would like to generate a number between 1 and 7 which would show what combination of checkboxes have been checked. Is there a simpler way, rather than use of If statements to do this?
Combinations selected
1 - 1
2 - 2
3 - 3
4 - 1 & 2
5 - 1 & 3
6 - 2 & 3
7 -1 & 2 & 3

[Speshul]

Can the order in which the checkboxes add up to 7 be changed? You could just use Binary for this if so.
Checkboxes A B and C

Logic:

A B C
0 0 1 = 1
0 1 0 = 2
0 1 1 = 3
1 0 0 = 4
1 0 1 = 5
1 1 0 = 6
1 1 1 = 7

If A is checked, 1
if B is checked, 2
If C is checked, 4

=SUM(ABC)

Something like...and I may be wrong on that variable, I'm bad at arrays

dim v1(2) as variant
dim vResult as integer

if checkbox1.checked = true then v1(0)=1
else
v1(0)=0
end if

if checkbox2.checked = true then v1(1)=2
else
v1(1)=0
end if

if checkbox3.checked = true then v1(2) =4
else
v1(2)=4
end if

vResult = v1(0)+v1(1)+v1(2)

msgbox vResult

[newdoverman]

Well, I did use a mess of IFs, VLOOKUP and IFERROR.

=IFERROR(VLOOKUP(IF(AND(A1=TRUE,A2=TRUE,A3=TRUE),"G",IF(AND(A2=TRUE,A3=TRUE),"F",IF(AND(A1=TRUE,A3=TRUE),"E",IF(AND(A1=TRUE,A2=TRUE),"D",IF(A3=TRUE,"C",IF(A2=TRUE,"B",IF(A1=TRUE,"A",""))))))),M1:N7,2,0),"")

Another way using LOOKUP

=LOOKUP(A1&A2&A3,{"FALSEFALSEFALSE","FALSEFALSETRUE","FALSETRUEFALSE","FALSETRUETRUE","TRUEFALSEFALSE","TRUEFALSETRUE","TRUETRUEFALSE","TRUETRUETRUE";0,3,2,6,1,5,4,7})

[laguna92651]

Thanks for the approaches, I'll give them a try, and see which one works best for my application.
Al