![]() |
How do I correctly enter a formula?
I entered =i15+j15 to add the 2 columns but it doesn't work correctly. I want
to add for instance 150.0+150.0 & I get 15000.0 instead of 300.0. What am I doing wrong? |
How do I correctly enter a formula?
Hi,
If you go to Tools | Options | Calculation (tab), is Iteration checked? -- Regards, Zack Barresse, aka firefytr "mcdowell0711" wrote in message ... I entered =i15+j15 to add the 2 columns but it doesn't work correctly. I want to add for instance 150.0+150.0 & I get 15000.0 instead of 300.0. What am I doing wrong? |
How do I correctly enter a formula?
On the same tab Zack mentioned, check to make sure your calculation is set to
automatic. "mcdowell0711" wrote: I entered =i15+j15 to add the 2 columns but it doesn't work correctly. I want to add for instance 150.0+150.0 & I get 15000.0 instead of 300.0. What am I doing wrong? |
All times are GMT +1. The time now is 09:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com