You might learn from some sources that when you enter a formula into a cell in Excel, you have to start your entry always with the equal sign. This is not true. You can, but DON'T NEED to start with the '=' sign.
Each formula can be started also with either '+', or '-' (if you mean negative number/expression) signs. When you press the ENTER key, Excel will voluntarily add the equal sign for you.
Here are couple of examples to illustrate what happens:
Similarly, entering dates (especially multiple dates) into your worksheet cells can be made easier/faster by following these exemplary patterns:
Just make sure that you get values you intended to enter. Please note that you must format cells in column C to your own formatting pattern. I've used my custom date format: dd-mmm-yy.
No comments:
Post a Comment
All comments are held for moderation. I reserve the right to edit, censor, delete and - if necessary - block comments.