The usage of =SUM() in this case is not strictly correct.
SUM() is a function in its own right, and is not required in most Excel calculations. Many people incorrectly use =SUM(their expression), trying to tell Excel to calculate the maths (the "sum"), whereas SUM is short for Summate, meaning to 'Add-Up'
You generally need to use the function =SUM() to 'summate' a 'range' of cells, for example, =SUM(A12:A22). That would add up all the values in cells A12 to A22 inclusive. Notice the ':' between the cell references to distinguish them as a 'range' specification.
To achieve your answer, you could write a simple 'expression' without the SUM function, (as in VoG's post), but by including the parenthesis as in Greenfingers' post :-
where Costprice1 and 2 are both £3.50, giving £7.00 * 1.4 = £9.80.
The '1.4' is 1 for the sum of the costprices, plus .4 (40%) for the markup.
If you had a longer list of items to work with, other than your 2, then =SUM() comes into play proper.
For instance, if as above, Cells A12 to A22 contained a list of costprices 1 to 10, then the formula =SUM(A12:A22)*1.4 is certainly clearer than the equivalent longwinded expression:-
The financial functions in Excel are wrong the Interest function is based on the American way e.g Interest/12 the British way is more complicated e.g ((Interest/100+1)^12-1)*100 of course the /100 and multiply by 100 are not neccessary if the cell is formatted to %
joethebow The rules of maths: Exponent comes before Multiplication.
This thread is now locked and can not be replied to.