Everyday we come across some problem for which we try, research for hours and once solved, looks so easy in MS Excel.I like to keep a note of it and share with others, so people can use them.These notes are not necessarily my own writing but are the one which I came accross during my research over the net to find out solutions.
Saturday, November 20, 2004
MS Access(or MS Excel):Mathematical order of operations
5 + 3 * 4 = ?
Answer is 17 or 32
It is 17.
Remember this order:
B E D M A S B = ( ) Brackets E = 2raise to power 3 Exponents=8 D = / Division M = * Multiplication A = + Addition S = - Subtraction