How to Add, Substract , Multiply and divide in Excel?
Example1:- Sum formula
“=sum(C1,C3,C5)”
“=C1+C3+C5”
“=sum(A2:A20)”
a)Above sum function will add all given 3 cells.
b)You can write direct by equal sign.
c)Third one will add values from A2 to A20 i.e. in range addition
Example2:- Subtract formulas
“=sum(C1,-C3,C5)”
“=C1-C3+C5”
“=sum(A2:A20)”
a)Above sum function will add and subtract.
b)You can write direct by equal sign.
c)Third one will add and subtract values from A2 to A20 i.e. in range addition subtraction
negative values will be subtracted.
Example3:- Multiply formulas
“=C1*C3”
“=PRODUCT(C1:C3)”
“=PRODUCT(C1:C3, 3)”
a)Above multiply function will multiply direct
b)Multiply in range C1 to C3.
c)Multi ply in range from c3 to c1 and after in last multiply total with 3.
Example4:- Divide formulas
Note: There is no DIVIDE function in Excel.
“=C1/C3”
divide C1 with C3.
No comments:
Post a Comment