Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download


AnalyserXL - Download


DownloaderXL - Download


Smart VBA - Download


TraderXL - Download

Quick Mathematics in Excel

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS


Back to Excel Model Builder Start

Quick mathematics    

Can you imagine how useful it would be to have a dialogue box that would allow you to perform on the spot calculations? In other words, to be able to perform calculations using the values of certain cells within a dialogue box. This way you would not have to waste time performing calculations in the worksheet and then have to erase them To achieve this, follow my instructions: After you click on the respective button in the tools bar.


In the space labeled Math action, we must enter the symbol representing the arithmetical calculation we are planning on doing; then we enter the value we wish to use.


Then, we start scrolling through the cells we are interested in. Note that the results of the calculations will be displayed in the area labeled Results.


If we add + 5 to the value of the active cell, we would have 55.45. That is what the tool does: it performs quick calculations.

Let us go on. Notice that the dialogue box has a button labeled Enlarge. Click on it, and the dialogue box will change its size.


If you "check" the space marked with red, several mathematical options will be activated. They will allow you to work with cell ranges.

What has happened here is as follows:

1.- The selected range was added; and then, + 5 was added to that sum. The total would be 197.48.

Think of the great things you could do with this tool.

View Demos

Excel Model Builder  Secure Payment Options

1 License $129.95 USD
2 - 5 Licenses $110.95 USD
6 - 10 Licenses $97.95 USD
11+ Licenses $64.95 USD

Choice of Complete Excel Training Course OR OzGrid Add-ins Collection on ALL purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH!  Purchases MUST be made via this site. Send payment confirmation to [email protected] 31 days after purchase.


Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.
Contact Us