# How to set Formula to get the total

#### dttl0925

##### New Member
Hi, would like to seek for assist to the below excel formula.

Criteria
Product A = Must have at least 20pts, if less than 20pts can add in the pts from Product C to hit the 20pts.
Product B = Must have at least 20pts, if less than 20pts can add in the pts from Product C to hit the 20pts.
Product C = The total can share to either Product A & B.

Sample:
Product A = 17pts. Less 3pts which need to borrow from Product C.
Product B = 13pts. Less 7pts which need to borrow from Product C.
Product C = 12pts

Questions : How do i do the formula to split the pts from Product C to Product A & B? And if the pts already borrow to Product A, it cannot duplicate borrow the pts to Product B.
Above sample show, is 12pts can split 3 pts to Product A & 7 pts to Product B.

### Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

#### Snakehips

##### Well-known Member
dttl925,

To the best of my understanding then maybe something like...
Excel Workbook
ABCD
2A17320
3B13720
4C12**
Sheet6

NB A will get priority over B for sharing from C

Hope that helps.

#### dttl0925

##### New Member
Thanks a lot for the formula... Its really work... Appreciate your help.

Replies
1
Views
572
Replies
4
Views
641
Replies
2
Views
705
Replies
31
Views
1K
Replies
3
Views
2K

1,190,561
Messages
5,981,695
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