name any three constituents formula available in ms excel
Answers
Explanation:
=1+2 // returns 3.
=6/3 // returns 2.
=A1+A2+A3 // returns 9.
=B1+C1+D1 // formula in E1.
=A1 // relative reference =$A$1 // absolute reference.
=D1*$A$1 // formula in E1 =D2*$A$1 // formula in E2 =D3*$A$1 // formula in E3.
=SUM(1,2,3) // returns 6 =SUM(A1:A3) // returns A1+A2+A3.
=AVERAGE(1,2,3) // returns 2
Answer:
Simple Excel formulas perform just one mathematical operation, for example =10*5 or =SUM(A1:A10)
Complex (advanced) Excel formulas include more than one calculation, for example =10*5+20 or =SUM(A1:A10)/2.
Total formula: =$B2*$D2+$B2*$D2*$C2
1st multiplication: $B2*$D2 (price*qty. = amount)
2nd and 3rd multiplications: $B2*$D2*$C2 (price*qty.*VAT % = VAT amount)
Addition: amount + VAT amount = total
Commission formula: =($B2*$D2+$B2*$D2*$C2)*10%
To calculate the 10% commission, you need to multiply the total by 10%, so you enclose the previous calculation in brackets, and got the result you want.
Of course, nothing prevents you from multiplying the total already calculated in column E by 10%, in this case the formula would reduce to a simple calculation =E2*10%. However, in large worksheets, it makes sense to write independently calculated formulas, so that removing a column with one formula wouldn't break the others.
Explanation: