New Posts
Home / Computer 4 Beginners / Creating Excel Formulas.

Creating Excel Formulas.

Creating Excel Formulas.

For many Microsoft Excel users, Creating Excel formulas are the most common thing they do. Formulas many times straight forward simple and easy to use.

Creating-Excel-Formulas

  • Creating simple formulas.
  • Copying a formula into adjacent cells.
  • Creating a percentage change formula
  • Using AVERAGE formula.
  • Using SUM formula.
  • Using AutoSum.
  • To know the maximum number.
  • To know the Minimum number.

Creating simple formulas.

But they start with the different concept.

Example-1.

Suppose you want to cut 100 from 120 number.

Creating simple formulas exampel 1

Creating simple formulas example 2

But in Microsoft Excel typically we type formulas based on location I mean row and column.

Example -2.

Creating simple formulas exp 3

120 number show location as column B and row shows location as 2.

100 number show location as column B and row shows location as 3.

Also, we can type physically row and column address but we do not need it.

When you use formulas the first requirement is that we have to give equal to sign ( = ).

before starting formula like below example.

Example-3.

Creating simple formulas exm 4

In this above example, we have used equal to sign (=) at the beginning.

Then we have used b2 it is cell address of number.

Secondly, we have used minus – sign for subtraction.

Noted: in place of minus sign – we can also use + addition, * multiply, / divide.

Then I have used b3 which is the address of number 2 at the end you can use enter from the keyboard or click mouse another place.

Creating simple formulas exm 5

Hit Enter.

Addition.

addition

+

*

/

=sum.

Copying a formula into adjacent cells.

See below example where we have used minus formula.

Copying a formula into adjacent cells 1

Same thing you want to do with C, D, E, F, and so on other columns.

You can copy to left or downside.

Hold down left mouse and continues to right.

Copying a formula into adjacent cells 2

 Copying a formula into adjacent cells 3

 

 

Copying a formula into adjacent cells 4

 

For checking double click.

In copying, we are also copying cell address.

Creating a percentage change formula.

Creating a percentage change formula

 Creating a percentage change formula 2

Hit enter.

Using AVERAGE formula.

=Average ().

average 1

average formula

Using SUM formula.

Using SUM formula.

Using AutoSum.

 Using autosum

 shortcut of sum

 

 

1 sum 2

To know the maximum number.

=Max( )

max

To know the Minimum number.

=Min( )

min

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

About imran

My Name Mohammad Ramzan Bhutto. Live in District Jacobabad, Sindh, Pakistan. I have started blogging on Information Technology, my selected areas are Online Business, Digital Marketing, Make Money Online.

Check Also

Microsoft Excel Data Analysis Tools

Microsoft Excel Data Analysis Tools

Learning Microsoft Excel Data Analysis Tools. This article illustrates the Microsoft Excel Data Analysis Tools. …