Allocation based on percentages

[xoxonutty]

Hi Guys ,
Having a bit of an issue allocating overhead costs. In order to get my allocations i have been dividing my sales by my overhead to come up with my percentage of allocation. is there an excel formula that would convert that percentage to a figure? in other words if my allocation is 3% of sales for that job the formula should convert that 3% so i allocate $30.00 to that job for overhead.

Any help will be greatly appreciated

 

[copypastespecialvalues]

What's it 3% of? Multiply it by that figure and you have your answer. Simple cell reference should suffice.

 

[xoxonutty]

Thanks for your help , i tried that but it does not work is it possible i can share the sheet with the forum

 

[copypastespecialvalues]

You could post a screenshot.