Basic formula for Ms- Excel, Basic formula for data analysis.
Title:- Basic formula for Ms- Excel, Basic formula for data analysis.
Name :- Ajay Kumar
Contact No:- 9773648725.
G-mail :- [email protected]
Basic formula for Ms-Excel
Ex:- Add:- The Excel addition formula or the syntax is: =SUM (number1, [number2], [number3], ...) number1 – is the first number that you want to add; required. This can be a number, a cell range (B2:B8), or a cell reference (B6). number2 – is the second number you want to add; optional. There are two basic ways to use the SUM function.Type a number into a cell. Type a number into another cell.Type = into a third cell.Type the numbers' cell designations after the = sign.
Minus:-Step 1 Open a new Excel spreadsheet and enter two different numbers in two separate cells. ...
Step 2 Enter the equal sign ("=") in the C1 cell in the Excel spreadsheet. ...
Step 3 Enter "a1-b1" into the C1 cell after the equal sign. ...
Step 4 Change the value in the B1 cell to 4 and press the "Enter" key. ...
Divide:-Type =A2/$C$2 in cell B2. Be sure to include a $ symbol before C and before 2 in the formula.
Drag the formula in B2 down to the other cells in column B.
Multiply:-Type =A2*$B$2 in a new column in your spreadsheet (the above example uses column D). Be sure to include a $ symbol before B and before 2 in the formula, and press ENTER.
Drag the formula down to the other cells in the column.
For Any sheet.
excel formulas,formulas,concatenate,most important,microsoft excel,microsoft office,multiply,counta,analyze,tutorial,excel 365,excel 2010,excel 2007,excel 2013,excel 2016,excel 2019,step by step,data,count,excel,basic,average,microsoft,sumif,office,median,subtract,office 365,current time,sum,add,min,max,help,guide,divide,how to,vlookup,countif