I am Nasir Muhammad Munim from Dhaka, Bangladesh. I work as an Excel and VBA Content Developer for Exceldemy right now. Electrical and electronic engineering was my major at Islamic University of Technology, where I got my degree. I love creative works and learning new things. And I'm really into online games, especially first-person shooter games.

## VBA Cells in Excel (Select, Get, Count, Format, Copy-Paste, etc.)

Cells property in Excel VBA (Visual Basic for Applications) is used for interacting with and modifying cells in Microsoft Excel. In simpler terms, it can read ...

## How to Calculate Standard Deviation with IF Conditions in Excel

While working on Excel, we often need to use a very common term called Standard Deviation. We can use the standard deviation based on conditions. This leads to ...

## How to Create Reverse EMI Calculator in Excel (2 Easy Methods)

In this article, with some simple techniques, we’ll learn how to create a reverse EMI calculator in Excel. The EMI refers to the Equated Monthly Installment. ...

## How to Use AVEDEV Function in Excel (2 Suitable Examples)

Excel has one of the best usages in statistics. Average Deviation is an important term in statistics that can be directly measured in Excel with the AVEDEV ...

## How to Lookup in Excel Dictionary (2 Suitable Ways)

One of the most useful features of Excel is having a dictionary that enables us to check for meaning and spelling. In this article, we will learn about Excel ...

## Radio Button in Excel Without Macro (Insert, Copy, Group & Delete)

Radio button in Excel is very common for creating forms and multiple-choice questions. Unlike checkboxes, radio buttons allow you to select only one option at ...

## How to Catalog Books in Excel (2 Easy Methods)

Excel is now widely used to track records of inventories such as supply chains or libraries for book collection management. One of the most common usages is to ...

## How to Remove Inverted Comma in Excel (7 Easy Methods)

When we import data in Excel, we may often encounter some Inverted Comma in data that creates problems while calculating data because it may change the data ...

## How to Add and Subtract Time in Excel (3 Suitable Examples)

One of the very popular uses of Excel is to calculate time and time differences. We may need to add or subtract time in Excel for a schedule or use custom time ...

## How to Mirror Table on Another Sheet in Excel (4 Easy Methods)

While working on Excel, we often face such scenarios where we need a table repeatedly in multiple sheets for calculation and analysis. Copying the entire table ...

## How to Undo a Table in Excel (2 Easy Methods)

One of the core features of Excel is to make tables with given data. But sometimes, we need to undo the table in Excel to make necessary changes or rebuild the ...

## How to Draw Lines in Excel (2 Easy Methods)

Excel is a versatile software with many features. One of the most used features is generating graphs with it and then showing the data related to arrow signs ...

## How to Sum Negative and Positive Numbers in Excel

One of the core features of Excel is to show the sum of numbers. It is widely used in different sectors. Summing positive numbers is fairly easy but if there ...

## How to Convert Large XML to Excel (2 Effective Ways)

We often need to convert large XML files to Excel for better understanding or readability of data. In this tutorial, we will learn how to convert large XML to ...

## How to Group and Hide Columns in Excel (3 Easy Methods)

One of the core uses of Excel is to insert data to analyze or visualize. For a large amount of data, there can be a lot of columns and rows. Sometimes we may ...

1. Reply Nasir Muhammad Munim Oct 18, 2023 at 10:43 AM

Hi Arthur,
Thank you for finding out about this issue. We have updated the VBA code to avoid the “Sub or Function Not Defined” error. Please try again with this new code and let us know if this problem still exists or not.
Regards,
Team Exceldemy

2. Reply Nasir Muhammad Munim Aug 28, 2023 at 1:35 PM

Dear AVI,
We can assure you that if you followed the steps correctly, everything should be fine with the tutorial. Moreover, both of these formulas are single-cell output formula. So, the procedure for the array formula implementation or pressing CTRL+SHIFT+ENTER is not required here.
If you want to take all the data to find out the standard deviation without conditions or avoid taking the false as 0, you should have a look at our article How to Calculate Average and Standard Deviation in Excel.
Regards,
Exceldemy

3. Reply Nasir Muhammad Munim Aug 21, 2023 at 1:57 PM

Dear Fardeen,

The profit margin is the percentage you get from the selling price. The formula for profit margin is: (Selling Price-Cost Price)/Selling Price or, Net Profit/Selling Price

The profit margin is calculated in the worksheet with the formula: =(F5-E5)/F5 On the other hand, the profit percentage is calculated based on the Cost Price. The formula for profit percentage is: (Selling Price-Cost Price)/Cost Price or, Net Profit/Cost Price

The profit percentage is calculated in the worksheet with the formula: =(F5-E5)/E5 Regards
Exceldemy Advanced Excel Exercises with Solutions PDF  