Want to highlight a helpful answer? Upvote!
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
This is maybe a simple question, but I cant seem to find the answer.
I have a cell with a number (100) in it. I need to add 10 to this number.
In excel you go to the cell and add =10+ to the cell, so it says =10+100 and hit enter. Then te cell shows 110 correctly.
If I do this in Numbers it gives me a syntax error.
How do I do this in Numbers?
Numbersis not excel and does not support the "=10+" operation. You should be able to type "=10+100" into a cell:
Numbersis not excel and does not support the "=10+" operation. You should be able to type "=10+100" into a cell:
I figured it out!
You are right, when I type =10+ to a cell with a number below 1000 it works, but a number above 1000 did not and that was the only one I tried.
But it wasnt working because it was spelled as 1,000.
Answer:
=10+1,000 gives a syntax error
=10+1000 is correct
Adding to a value in a cell
