Update cookies preferences

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!!

 

 



No comments:

Post a Comment

How to Add a Free GDPR/AdSense Compliant Cookie Consent Banner with 'Accept & Reject Buttons' on Blogger

  If you run a Google Blogger ( .blogspot.com ) site with Google AdSense enabled, relying on the platform's default notification layou...