Help!! my boss needs this ASAP

[cl21]

I need some help. I have 2 choices ( + and -) and I need to put them in a sequence of 5. is there a formula or anything that can tell me these?

something like this:
+ - - - -
+ + - - -
+ + + - - -
- - + + -
- - - + + ....etc. what are the possibilities? how can i find them out without human error??

 

[cl21]

i did. how do i get rid of the ones that are multiples? I only want one - - - + +, not 80

 

[cl21]

i dont have five variables..i have 2 variables and i need to put them in a sequence of 5. i need to see how many combinations there are

 

[hallingh]

Do you need to see the combinations? Or just how many combinations there are?

 

[cl21]

i need to see the combinations. i believe there are 32. correct me if im wrong

 

[Desu Nota from Columbus]

You need to read Myrna Larson's instructions more carefully than I did

I think you need to do either 1) or 2).

1) Leave A2 = 5 , put a + in A3, and a - in A4

2) Change A2 = 2, and leave the A3:A7 = +, A8:A12 = -

 

[West Man]

Try putting 0 through 31 in A1:A32, then in B1 use =DEC2BIN(A1,5). Drag down to B32.

View 0's as - and 1's as +.