You need to give more detail to be able for me to even make a guess.
What are your formulae?

This works for me:

Sheet1:

A1: 20
B1: 50
C1: =A1/B1 === 20% when formatted as a %age.


Sheet2:

J2: 150

Sheet3:

Z34: =Sheet1!C1 * Sheet2!J2 === 30


In article ,
"Geag" wrote:

I have formatted the cell as a percentage, but even so it still is not giving
the right answer.

I have 3 sheets to my workbook, my first sheet gives all of the %'s and the
second is holding additional data. On my 3rd sheet I am quite simply using
the data on my 2nd sheet and multiplying it by the % in the 1st sheet.

To be honest it's that simple I can't understand what i'm doing wrong!

I have found out what it is, very simple - rounding!

Thank you very much for your help

"JE McGimpsey" wrote:

You need to give more detail to be able for me to even make a guess.
What are your formulae?

This works for me:

Sheet1:

A1: 20
B1: 50
C1: =A1/B1 === 20% when formatted as a %age.


Sheet2:

J2: 150

Sheet3:

Z34: =Sheet1!C1 * Sheet2!J2 === 30


In article ,
"Geag" wrote:

I have formatted the cell as a percentage, but even so it still is not giving
the right answer.

I have 3 sheets to my workbook, my first sheet gives all of the %'s and the
second is holding additional data. On my 3rd sheet I am quite simply using
the data on my 2nd sheet and multiplying it by the % in the 1st sheet.

To be honest it's that simple I can't understand what i'm doing wrong!