When you type an equal sign into an empty cell, Excel assumes that you are entering a formula because a formula always begins with an equal sign. Excel’s accommodating nature also permits you to begin your formula with a minus sign or a plus sign. However, Excel always inserts the leading equal sign after you enter the formula.
As a concession to former Lotus 1-2-3 users, Excel also allows you to use an “at” symbol (@) to begin a formula that starts with a function. For example, Excel accepts either of the following formulas:
=sum(A1:A100) @sum(A1:A100)
However, after you enter the second formula, Excel replaces the @ symbol with an equal sign. You can enter a formula into a cell in one of two ways: Enter it manually, or enter it by pointing to cells that are used in the formula.
A formula can consist of up to about 8000 chars. In the unlikely event that you need to create a formula that exceeds this limit, we must break the formula up into multiple formulas. Other than this you can opt for VBA.
Keep Learning and do share
Sanjay Bakshi
mesanjaybakshi@gmail.com
“Knowledge Increases by Sharing but not by Saving” ..Kamari aka Lyrikal
As a concession to former Lotus 1-2-3 users, Excel also allows you to use an “at” symbol (@) to begin a formula that starts with a function. For example, Excel accepts either of the following formulas:
=sum(A1:A100) @sum(A1:A100)
However, after you enter the second formula, Excel replaces the @ symbol with an equal sign. You can enter a formula into a cell in one of two ways: Enter it manually, or enter it by pointing to cells that are used in the formula.
A formula can consist of up to about 8000 chars. In the unlikely event that you need to create a formula that exceeds this limit, we must break the formula up into multiple formulas. Other than this you can opt for VBA.
Keep Learning and do share
Sanjay Bakshi
mesanjaybakshi@gmail.com
“Knowledge Increases by Sharing but not by Saving” ..Kamari aka Lyrikal
No comments:
Post a Comment