# help

#### erenkey

##### Board Regular
Can someone help me with a formula or code? I have 20 envelopes containing one of the following numbers (1000,750,500,250,100) totaling 9,500. I need to know how many envelopes contain each number. The only thing that I do know is there is only 1 envelope containg 1000. can anyone help me with the others?

### Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

#### Gerald Higgins

##### Well-known Member
This is a maths / statistical question, not an excel question.

Can you do the maths to work out the result ? If yes, post it here and there's bound to be an excel solution.

#### Gerald Higgins

##### Well-known Member
Here's one solution, found by trial and error, but it might not be unique

1000, 1
750, 6
500, 6
250, 2
100, 5

Replies
7
Views
557
Replies
2
Views
472
Replies
3
Views
470
Replies
8
Views
381
Replies
1
Views
176

1,190,560
Messages
5,981,693
Members
439,730
Latest member
gjvv

### 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