# possibilities

1. ### IF statements (Nested) ??

I have the following formula located in K31. =IF(L31<>"TECH","In", IF(V31>=71,"Out","In")) The manual variables are located in L and V. Here's the variable possibilities for L: TECH or Nothing. (Empty cell) TMOAM TMOOT TMPPA Here's the variable possibilities for V: =>71 If V31 => 71...
2. ### SUMIFS with multiple possibilities for 2 criterias

SUMIFS with multiple possibilities for one criteria, can be solved using: =SUMPRODUCT(SUMIFS(G10:G100,A10:A100,A5,B10:B100,B5,C10:C100,C3:C6)) According to: https://www.mrexcel.com/board/index.php?threads/821600/ But If I need to apply SUMIFS with multiple possibilities for 2 criterias...
3. ### Four Digit Possibilities

Hello, I’m looking for the total number of possibilities for a four digit entry where: 1. Available digits = 0,1,2,3,4,5,6,7,8,9. 2. Any single digit can only be used once. 3. Any combination of four digits are equal and only counted as one possibility (i.e., 0123, 3210, 1230, 2130 etc...
4. ### VBA create box with some possibilities

Hi I would like ask how is possible to write macro which will open (create) some "box" or bracket with two possibilities. This two possibilities will be conected to different macros. Then when I will choose one option this box will disapear. On next time when I will activete this kind of...
5. ### Schedule Help

I am trying to have my schedule tell me when I am missing shifts. I need a total of 3 D and 2 N. Theses represent 12hr day and 12 hr N, but they can be made up with d8, n8, and e8. I have entered separate lines to count each type of shift and then used a separate line to show me the "needs". The...
6. ### VBA code or formula to list all possibilities

Hi Excel Masters, I would like to be able to list all the possibilities in a column of the following : - If I have a qity of X in A1, I would like to be able to create a serie of possibilities of this qty to be dispacthed in A2 and A3 in column A as per below example... This will have to be...
7. ### list of lettercombinations?

Hello all, Sander Sturing here, Student Information & Interactive Media Design from Holland... My 'problem' is the following: For an assignment we have to come up with a new sollution to re-order the list of english '3-letter words'. That is a list of 1015 words atm! I'm planning on making...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back