Search On Google

Monday, February 4, 2019

How to Add Subtract Multiply And Divide In Excel


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

About Me

My photo
Mumbai, Maharashtra, India