The attached Excel contains a short sample of an allocation I'm working on. I would like to allocate an amount in one column according the percentages in another column. The two columns are link by an ID number. I’m trying to use the IF function which seems to be working somehow but gives an error message after copying he formula down the column.
Thanks in advance for any suggestions.
Bookmarks