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

sharpe-e wrote:

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...

--

Dave Peterson