Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help
Item I.D. Cost Total Packs
a 200 136540 b 200 133530 c 200 72920 d 200 40340 e 200 290120 f 200 471520 g 200 0 I could do with some help if any one could! I need to find the proportionate cost of each item. For example if the total packs of A-G was 100 and A alone was 50 it would recieve half of the cost (100). However, even though g says it is 0 i need to allocate 1% of the cost to this item and making all the other costs still = 200. I have an easy formula should the 0 not occur (in other sheets) but i can't figure out how to do this. Help would be HUGELY appriciated!!! Thanks! |