3 Ways to enter formulas in Excel

There are 3 ways in which you can enter formulas into an Excel cell. Select any cell and type one of the following sign and enter the name of the function and press "Enter".

1) = (equal sign)
2) +  (Plus sign)
3) @ (at sign)


For Example, Enter values 3, 4 and 5 in cells A1, A2 and A3 respectively. Now, type (without quotes)

"=SUM(A1:A3)"
"+SUM(A1:A3)"
"@SUM(A1:A3)"

in cells B1,B2 and B3.

Note: @ works only for built-in functions in Excel, but not for arithmetic operators using cell references (i.e. "@SUM(A1:A3)" works but not "@A1+A2+A3").