# Formula For distributing

#### paul29berks

##### Active Member
I have 2 sets of data 1 that is split by product:

2004 Actual Data:

Product A 1
Product B 2
Product C 3

Total 2004 6

The other I have only a total:

2005 Plan:

Total 2005 = 8

In order to achieve distribution between Products A-C for 2005 I have % loaded each product i.e

Product A = Product A/Total 2004 * Total 2005
Product B "
Product C "

This is fine - but if I have say 0 as a total for 2004 and 2 as a total 2005. How can distribute evenly?

Thanks

### Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Replies
1
Views
328
Replies
5
Views
449
Replies
0
Views
413
Replies
4
Views
251
Replies
3
Views
470

1,181,124
Messages
5,928,246
Members
436,594
Latest member
asifm0

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