View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sharpe-e sharpe-e is offline
external usenet poster
 
Posts: 1
Default Excel formula help wanted

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