My 1st Excel Formula

There is no doubt that any computer user, must have passed by Microsoft Excel. MsExel, is a very smart application that helps creating schedules, Tables with all its kinds. and draw Charts. In fact, I have been using Excel for a very long time, if I recall correctly version 3.0 on Windows 3.11 for Working group. but as a concept I used to use an older app called lotus123.

In this post i will not explain how Excel Works, or what its interface is about. There is a lot of blogs and details posts about that all over the internet. I will explain some basic concepts of how formulas and equations are used, so as later in another post we can combine that with Revit API.

How does it work

Before we use it, we need to understand some terms (Range, Formula)

Cell: is a location unit in a table, where you can fill it with data (number, text, image...etc)

Range: is a collection of two or more cells.
Formulas and Functions: is an expression which calculates the value of a cell.
Worksheets: a collection of cells where you keep and manipulate the data. Each Excel workbook can contain multiple worksheets.

I am assuming you already installed and running Microsoft Excel.

Write your first Formula:

let's say you have a collection of numbers written in cells, and you want to sum them up. you can simply go to an empty cell and type this formula =SUM(your Range) in the formula textbox.

where images and videos says more than reading a line. see this video