Subtract, Multiple, Divide And Percentage
In Microsoft Excel, you can perform basic mathematical operations such as addition, subtraction, multiplication, division, and percentage calculation using formulas.- Subtraction: To subtract one value from another, use the minus sign (-). For example, "=A1-A2" subtracts the value in A2 from the value in A1.
- Multiplication: To multiply two values, use the asterisk () symbol. For example, "=A1A2" multiplies the values in cells A1 and A2.
- Division: To divide one value by another, use the forward slash (/) symbol. For example, "=A1/A2" divides the value in A1 by the value in A2.
- Percentage: To calculate a percentage, multiply the value by the percentage as a decimal. For example, to calculate 50% of a value, use the formula "=A1*0.5". To calculate the percentage of a total, divide the value by the total and then multiply by 100. For example, "=(A1/A2)*100" calculates the percentage of A1 in relation to A2.
No comments:
Post a Comment