TODAY() FUNCTION
Displays today's date, taken from the system.
Calculations can be made with this function.
e.g.
=TODAY()+30 would return the date 30 days from today.
ORDER OF CALCULATION
The following numeric operators are used in formulas:
B () Parentheses
O ^ Orders (to the power of, square roots etc.)
D / Division
M * Multiplication
A + Addition
S - Subtraction
The order of calculation is important. Excel calculates brackets first, then any square roots etc. , then division, multiplication, addition and subtraction (as above). You can get different results if you do not follow these rules.
e.g. A2*(B3+C4) tells Excel to add the contents of B3 and C4 first then multiply the result by the contents of A2
Facebook Page
Linked In
Twitter
YouTube