| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel formula help wanted
On Tue, 26 Feb 2008 17:17:01 -0800, 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... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel formula help wanted
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 "sharpe-e" wrote in message ... 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... |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel formula help wanted
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel shutting down - not wanted! | Excel Discussion (Misc queries) | |||
| Formula wanted | Excel Discussion (Misc queries) | |||
| Wanted: Business Excel Books | Excel Discussion (Misc queries) | |||
| Wanted: Busines Excel Books | Excel Discussion (Misc queries) | |||
| formula wanted please, I have a list of data | Excel Discussion (Misc queries) | |||
Linear Mode
