Excel formula help wanted

[sharpe-e]

Hi i am having trouble with getting a figure when typing the following
formular;

=C45*PANEL!F22 doesnt work ... i want to MULTIPLY the cell C45 from a
worksheet called TRIAL CALC SHEET 1 by a percentage 1.00% which is cell F22
in a worksheet called PANEL and the formular is getting 0.00 which is wrong!
the formatted cell is set to number and 2 decimal places can any body
help....

i think its something to do with circular referencing not sure...

 

[Ron Rosenfeld]

Hi i am having trouble with getting a figure when typing the following
formular;

=C45*PANEL!F22 doesnt work ... i want to MULTIPLY the cell C45 from a
worksheet called TRIAL CALC SHEET 1 by a percentage 1.00% which is cell F22
in a worksheet called PANEL and the formular is getting 0.00 which is wrong!
the formatted cell is set to number and 2 decimal places can any body
help....

i think its something to do with circular referencing not sure...

Why do you think circular referencing?

In what cell is your formula located?

What is the value stored in C45?

If the value in C45 is less than 0.5, you will see a result of 0 in the cell.
--ron

 

[Tyro]

If your formula is on Trial Calc Sheet 1 then: =C45 * Panel!F22
If your formula is on Panel then: ='Trial Calc Sheet 1'!C45 * F22
If your formula is on some other sheet then ='Trial Calc Sheet 1'!C45 *
Panel!F22

Tyro

 

[Dave Peterson]

What's the value in C45?

Maybe formatting the cell that contains the formula to show more decimal places
will help you find the problem????