Thursday, February 15, 2024

Simple time saving excel mathematics hacks

 

Simple excel mathematics hacks that save mammoth amount of time.

1.Addition: 

1.Adding two numbers available in cells ‘A2’ and ‘B2’are as below:

 

2. Just click in cell where you want the addition total, for example column ‘C2’.

3.              3. And write formula ‘=A2+B2’ [without quotes] and hit the enter key.


4.               4. You will get addition of two numbers as below: ‘1+2=3

 

 

 

 

2.Subtraction:

          1. Subtracting two numbers available in cells ‘A2’ and ‘B2’are as below:

           

2. Just click in cell where you want the subtraction total, for example column ‘C2’.

      3. And write formula ‘=A2-B2’ [without quotes] and hit the enter key.


        4. You will get subtraction of two numbers as below: ‘3-1=2’

 

In similar way we can do for Multiplication and Division too, just replace the sign between the numbers and its done!!

 

 



How to create any mathematics tables with excel...

  Generate any tables with excel... 1.        Go to excel sheet, in first cell ‘A1’ enter the number whose table you want to generate, for...