Somewhere right now, a business owner is working out a margin on a calculator while the spreadsheet sits open in the next window. The percentage formula in Excel does that job in a second. Six formulas cover most of the daily arithmetic in a small business, and this guide walks through each one.
Start with the ones that save the most time. Each section shows what the formula replaces and where it fits in a real sheet.
The cost of doing your numbers by hand

Manual math is slow, but accuracy suffers more. One mistyped digit can throw off a month of totals, and by the time anyone spots it, the figures are already stale.
Most of the work that eats an owner’s evenings repeats itself week after week. Excel formulas handle that kind of task well. The table lists the six formulas and the everyday work each one takes off your desk.
| Formula | What you stop doing by hand | Business use |
| Percentage | Working out margins on a calculator | Margins, markups, growth |
| SUM | Adding a column cell by cell | Daily and monthly totals |
| COUNT and COUNTIF | Counting rows by eye | Stock, invoices, orders |
| VLOOKUP | Scrolling to find a price | Price lists, customer records |
| IF | Flagging problems manually | Alerts, thresholds, status |
| AVERAGE | Averaging figures on paper | Sales, performance, pricing |
Each formula gets its own section, starting with the one most owners reach for first.
Percentage formula in Excel for the biggest time savings
Percentages eat more manual time than almost any other calculation. Owners check a margin, then a markup, then last month’s growth rate, often on paper and sometimes twice. One formula with a cell reference covers all three.
Working out margins and markups

A margin shows how much of each sale you keep after the cost of the product. Say a product costs 800 and sells for 1,000. The cost is held by the A column, whereas the selling price is held by the B column. In C2, write =(B2-A2)/B2, then format the cell as a percentage. The sheet returns 20 percent, and the figure updates as soon as either price changes.
A markup works from cost instead of price. Using the same columns, =(B2-A2)/A2 returns 25 percent for the same product. The formulas differ only in the denominator, and that one change alters the answer.
Read More: Courier services in Pakistan decide whether your online store survives
Tracking growth month to month
Growth is the percent change between two figures. Subtract the old number from the new one, then divide by the old number. The same pattern used for markups works here too. With September in column A and October in column B, =(B2-A2)/A2 returns the growth rate. If you sold 400 units in September and 460 in October, the result is 15 percent. Copy the formula down the column to check every month at once.
Adding and totalling without a calculator
Totals come next. A running sum on paper is slow, and it breaks the moment someone inserts a row in the middle of the list. The formulas in this section keep totals current without any retyping.
Excel sum formula for daily totals

SUM adds a range of cells in one step. For daily sales in B2 to B31, type =SUM(B2:B31) into the total cell. Excel adds every value in the range and skips blanks and text.
You may have used a plus sign before, as in =B2+B3. That works for two cells, but SUM is quicker once the list runs longer.
Subtracting costs and splitting per unit
Profit is revenue minus costs. Put revenue in column B and costs in column C. In column F, type =B2-C2 to get gross profit for that row.
Assume column D contains total costs and column E contains units sold. Then =D2/E2 gives cost/unit. Drag both formulas down the column to change all product lines at once.
Price x Quantity
On invoices and order sheets you generally have to multiply the amount by the unit price. Add quantity B2 and price C2 then use =B2*C2 for the line total. Copy it down the column rather than retyping the
Counting rows so tallies stay accurate
Counting by eye works until it stops working. A stock sheet with three hundred lines, or an invoice log covering a full year, is easy to miscount. The error usually surfaces when a customer or supplier points it out. Counting formulas return the number straight away.
Count formula in Excel for stock and invoices

COUNT returns how many cells in a range hold numbers. For invoice amounts in B2 to B200, =COUNT(B2:B200) tells you how many invoices have a value. Headers and notes stay out of the total, because COUNT ignores text. Use COUNTA when you need every non-empty cell, including text entries such as product names.
Counting only what matches with COUNTIF
Sometimes a count needs a condition. COUNTIF counts only the cells that meet a rule you set. For unpaid invoices marked Pending in column C, write =COUNTIF(C2:C200,”Pending”). Change the text to count orders from one city. For low stock, use “<10” as the condition on the stock column.
Looking up prices and records instantly
Searching a long sheet for one price is where time disappears. You scroll, lose your place, and sometimes copy the wrong number. A lookup formula does the searching and returns the match from the column you choose.
VLOOKUP Formula in Excel for Price Lists
VLOOKUP looks for a value in the leftmost column of a table , and then returns a value in the same row from a column you specify. Let’s say the product codes are in column A of a price list on Sheet 2, rows A2 through C100, and the code you want is in F2. To get the price from column C, use the formula =VLOOKUP(F2,Sheet2!A2:C100,3,FALSE). FALSE needs a precise match, which is good for codes and names. XLOOKUP is the job done in newer versions of Excel.
Combining names and details in one cell
Labels and SKUs are generally a combination of numerous columns, such as product name, size, and color. The concatenate Excel formula combines text from different cells into one. CONCATENATE(A2, ” “, B2, ” “, C2) concatenates three cells into one label. The ampersand does the same thing, as in =A2&” “&B2&” “&C2, and many people find it quicker to type.
Letting the sheet make the call
A good sheet does more than store numbers. It can flag an overdue payment, mark a line over budget, or warn you when stock runs low. The IF and AVERAGE formulas handle these jobs, so you check the sheet only when something needs attention.
IF formula in Excel for flags and alerts
IF tests a condition and returns one result when it is true and another when it is false. For invoices with a due date in D2, =IF(TODAY()>D2,”Overdue”,”On time”) flags each row. Swap in your own labels, such as “Over budget” or “Reorder.” Nested IF statements can handle more than two outcomes, but keep them short, since long chains are hard to audit later.
Averaging sales and performance
Averages show whether a number is climbing or slipping. For daily sales in B2 to B31, =AVERAGE(B2:B31) gives the mean. Place the average beside your monthly target, and the direction of the month becomes obvious. Blank cells are skipped, so a half-filled month won’t pull the figure down.
Formulas for dates and aging accounts
Money owed to you is only useful when you know how late it is. Dates are easy to misread on paper, so a formula that counts the days gives a clearer answer.
Excel date formula for due dates
Excel stores dates as numbers, so subtracting one date from another returns the days between them. If the due date sits in D2, =D2-TODAY() returns the days until payment is due. A negative result means the payment is overdue. Format the cell as a number so you see a count rather than a date. TODAY() refreshes each time the file opens.
Aging formula in Excel for overdue payments
Excel has no single built-in aging function, so you build one from subtraction and IF. The aging formula needs days overdue, which is the reverse of the date formula above. In E2, =TODAY()-D2 returns a positive number once the due date has passed.
Then =IF(E2<=30,”0 to 30″,IF(E2<=60,”31 to 60″,”Over 60″)) sorts each invoice into a bucket. Invoices not yet due also land in the first bucket, so add a check for negative values if that matters to you. Count the invoices in each band with COUNTIF, or use SUMIF to total the amounts owed.
Choosing where to start with formulas
Saving time doesn’t require the whole Excel formulas list. Begin with basic Excel formulas that cover totals, margins, and flags: SUM, the percentage formula, and IF. Those three handle most weekly tasks for a small business, and the rest can wait until you need them.
For exact syntax and argument lists, the Microsoft Excel support pages are the reliable reference. The SMEDA website is a useful starting point for wider guidance on running a small business. When filing season approaches, read Income tax return season catches Pakistani SMEs off guard every year to see where clean sheets matter most.
Pick one manual sheet this week and rebuild it with two or three of these formulas. Time the old version against the new one. That comparison will show which formula to learn next.
Related: Business ideas in Pakistan that survive past the first year
FAQs
How do you write a percentage formula in Excel?
Divide the part by the whole, then format the cell as a percentage. For a margin, the cost sits in A2 and the selling price sits in B2, so the formula is (B2-A2)/B2. A product costing 800 and selling for 1,000 returns 20 percent.
What is the sum formula in Excel used for?
You can use the SUM formula in Excel to add a range of cells or numbers together. The SUM formula sums a range of values at once. It replaces the manual addition of columns and it updates when a value in the range changes. Daily amounts for a month in B2 through B31: Sum = SUM(B2:B31)
How does the Excel VLOOKUP formula work?
VLOOKUP looks for a value in the first column of a table and returns a value in the same row from another column. It requires the lookup value, the table, the column number to return, and FALSE for an exact match. The most common use is to get prices from a list of products.
What’s the difference between COUNT and COUNTIF in Excel?
COUNT counts the number of cells in a range that contain numbers. COUNTIF only counts the cells that meet a condition such as the word Pending or a value less than ten. Use COUNT for totals and COUNTIF for filtered counts.
Which Excel formulas should a small business owner learn first?
Most owners get the biggest return from SUM, the percentage formula, and IF. Those three cover totals, margins, growth, and flags, which repeat every week. COUNTIF and VLOOKUP come next, once the basics feel natural.
Can Excel formulas update automatically?
Yes, results recalculate whenever the cells they refer to change. A total or margin updates the moment a price or quantity changes. Formulas that use TODAY also refresh each time the file opens.
Read More: Best Shopping Apps in Pakistan That Can Make Your Lives Easier