This is probaby very simple, but I really don't know a lot aout formulars.

When I have created formulas to work out the percentage of each sales type
that we have, I then need to use this % as a part of another formula, Ie

Sales type A is 50% of our overall sales "=sum(B1/B3)*100", I am am then
trying use this 50% to apportion our wages bill to a sales type.

When I create another formula "=sum(B10/B13)*the cell reference of the
formula I previously calculated" it is throwing out the incorrect answer.

Can anyone give me a simple answer to a very simple question as I have
resorted to manually typing in the % excel has calculated and I am producing
very large and confusing spreadsheets?

Thanks very much