Friday, 21 August 2015

1.4-Creating a basic formula

Hello Excel-lent,

TGIF!

Hope you're doing great and how has your week been? The week has been tough emotionally but I thank God for His goodness and mercy! 

I was going to ask if you had ever used any excel formula before and for what purpose? That sounds like "are you serious at all?", but the factual truth is many have not seen the spreadsheet grid lines before or for those who had seen it, seeing was only what they could do!

We agreed last week that formulas are one of the most commonly used features of Excel and they can be used to carry out simple addition and subtraction or far more complex mathematical calculations. All formulas in Excel, no matter how complex, always begin with the same two steps:

  1.  Click on the cell where you want the formula's result to be displayed.
  2.  Type an equal sign ( = ) to let Excel know you are creating a formula
In the example below, I want my formula's result to be displayed in cell "B3", so i put my cursor in cell "B3" as shown below..

Illustration 1.

With that done, i can then think of what i want excel to calculate for me. I can do a basic calculation of how much i need to pay if i buy 25 litres of petrol at N87/ litre. In the example below, I have "Litres" entered in cell B1 and "Rate" in cell C1 as titles while i have 25 and 87 captured in cells B2 and C2 respectively. Because i want my formula's result to show in cell B3, i then type in the "equals to = sign" and using my cursor, reference cells B2 and C2 with a multiplication sign embedded like this =B2*C2. Once this is done, hit the enter button and gbam.....excel gives you your result.  

Illustration 2.

Illustration 3.
From this simple formula, you can then graduate to building complex formulas like what you see in Illustration 4 below.

Illustration 4.
With excel + a sound knowledge of formulas, you are bound to excel at your workplace and save a lot of time spent stumbling in a data jungle.

Please, if your answer is not 2,175 in the example above, kindly let me know but if you buy 25 litres Petrol at any filling station and they sell it for more than N2,175.00 (Two Thousand, One Hundred And Seventy Five Naira only) at N87 per litre, please report to DPR on 01-261 8228  or visit 5, Kofo Abayomi Street, Victorial Island, Lagos.

Have a Cntrl + A weekend, where "A" ="Awesome"

Oladapo Sorinola
07014282477, 07062932708
BB Pin 52E9802D












No comments:

Post a Comment