# Formulas

## A collection of 22 posts

Standalone python3 script which enable multiline, versionning and comment for Excel Formulas
15 March 2022
Semi-automation of manual loads-descent calculations on a simple rectangular project using only Excel formulas as core computing
12 March 2022
Transpiler for Excel formula like language to Python. Support script and module mode
10 March 2022
Excel formulas interpreter in Python.
07 March 2022
Xlcalculator converts MS Excel formulas to Python and evaluates them.
07 March 2022
A Python Excel Formula Parser similar to the javascript handsontable formulaparser
05 March 2022
Library to fast calculate excel formulas
05 March 2022
Computer Vision Basics in Microsoft Excel Computer Vision is often seen by software developers and others as a hard field to get into. In this article, we’ll learn Computer Vision from
18 February 2020
In excel we are aware of operators like arithmetic and logical operators. Logical operators are mostly used in any organization to compare the two values either it is true or false. This logical
02 February 2020
Excel offers powerful conversion functionality to the user. You can apply simple equations across ranges of data to quickly produce new figures. Use this powerful feature to convert centimeters to inches in Excel.
02 February 2020
Excel provides you different ways to calculate percentages. For example, you can use Excel to calculate the percentage of correct answers on a test, discount prices using various percent assumptions, or percent change
02 February 2020
How to Subtract Cells in Microsoft Excel. Microsoft Excel tutorial on how to subtract using Microsoft excel. Check out the other microsoft excel videos and tutorials for more help in the “Microsoft
01 February 2020
Multiplying and dividing in Excel is easy, but you need to create a simple formula to do it. Just remember that all formulas in Excel begin with an equal sign (=), and you can
01 February 2020
Excel doesn’t have a divide function, so performing division in Excel requires you to create a formula. Let’s learn how to use formulas to divide numbers and calculate percentages
01 February 2020
A common engineering spreadsheet problem is solved by this quick tutorial on how to input square root. The tutorial shows how to do square root in Excel as well as how to calculate
01 February 2020
How to calculate percentages in Excel. Learn how to show data effectively for reports for example when calculating percentage change (percent increase or decrease) from Actual to Budget or this year to previous
01 February 2020
For referencing the current sheet tab name in a cell in Excel, you can get it done with a formula or User Define Function. In Excel, you can name cells and cell ranges,
01 February 2020
By default when you copy (or cut) and paste in Excel, everything in the source cell or range – data, formatting, formulas, validation, comments – is pasted to the destination cell(s). This
01 February 2020
In Microsoft Excel, you may have a named range that must be extended to include new information. A dynamic named range expands automatically when you add a value to the range. 1. For
01 February 2020
This tip helps you discover how to quickly display statistics on the status bar by simply highlighting data. Excel allows for up to 6 statistic options to be viewed on the status bar,
01 February 2020
Paste Special in Excel allows you to quickly add, subtract, multiply, divide to and from a cell series in-place without having to create a new cell series and write a formula. Use the
01 February 2020
Sum, Count, Average =SUM(A1:A10) Count =Count(A1:A10) Average =Average( Value1, Value2) If statements =IF(A1>A2, “GOOD”, “BAD”) Sumif, Countif, Averageif =SUM(A1:A15, “
12 January 2020