How do I correctly enter a formula?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

If you go to Tools | Options | Calculation (tab), is Iteration checked?
 
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?
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Table Lookup 4
Transferring Totals (MCorn) 3
Want To Shrink Formula 1
could not find title 1
complicated If statements 3
Nested IF limit or Open parentheses limit 5
need one formula for % change in TY vs LY revenue 16
Help with writing System.drawing in server control 3

Back
Top