Since you multiply your result by 100 to get percentages, you need to
divide by 100 when you use that result.

Another way to do it would be to simply format the percentage as a
percentage and use it directly. For instance

A1: 50
A2: 100

B1: =A2/A1

Format B1 as a percentage to display 50%. Note that SUM() is superfluous.

Then

C1: <total salary
C2: =C1*B1

will display, in this case, 50% of the total salary in C2.

In article ,
"Geag" wrote:

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