Excel formula help wanted

  • Thread starter Thread starter sharpe-e
  • Start date Start date
S

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...
 
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...
Click to expand...

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
 
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
 
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????
 
Back
Top