Mizbahul Abedin

About author

Md Mizbahul Abedin, BSc, Textile Engineering and Management, Bangladesh University of Textiles, has been working with the ExcelDemy project for 11 months. Currently working as an Excel and VBA Content Developer who provides authentic solutions to different Excel-related problems and writes amazing content articles regularly. He has published almost 20 articles in ExcelDemy. He has passions for learning new things about Microsoft Office Suite and Data analysis. Besides, he also likes to travel, photography, international politics, and read books and newspapers.

Designation

Excel content writer at ExcelDemy in SOFTEKO.

Lives in

Chattogram, Bangladesh.

Education

B.sc in Textile Engineering and Management, BUTex

Expertise

Content Writing, Microsoft Office, Adobe Lightroom

Experience

  • Technical Content Writing
  • Team Management
  • Undergraduate Projects
    • Industrial Visit
    • Smart Belt

Summary

  • Currently working as Excel & VBA content Developer of ExcelDemy.
  • Started technical content writing of Excel & VBA in February 2023.

Latest Posts From Mizbahul Abedin

0
Insert Row in Excel (After Every Row and for Table)

In this article, you will learn about how to insert row in Excel. Additionally, you will also know about deleting rows in your Excel Sheet and dataset. You ...

0
How to Merge in Excel (Merge, Find, Unmerge)

Merging in Excel means combining multiple cells, columns, rows, tables, sheets, or workbooks into one.  In this free Excel tutorial, you will learn how to ...

0
How to Create a Stacked Waterfall Chart with Multiple Series

What Is a Stacked Waterfall Chart in Excel? A stacked waterfall chart is a special type of graph that illustrates how values change across different ...

0
How to Remove Trace Dependents in Excel (3 Swift Ways)

In this article, we are going to show you how to remove trace dependents in Excel. We will know about some Excel features, keyboard shortcuts, and also Excel ...

0
How to Use Excel IF Statement for Increment by 1 (3 Examples)

In this article, we are going to show you how to use Excel IF statement for increment by 1. Along with the IF statement, we will also discuss the COUNTIF ...

0
How to Calculate Economic Order Quantity in Excel

EOQ, or Economic Order Quantity, is a mathematical model used in inventory management to determine the optimal order quantity for a company to minimize ...

0
How to Get Cell Value as String Using Excel VBA (4 Easy Ways)

In Visual Basic for Applications (VBA), working with cell values is a fundamental aspect of automating Excel tasks. While cells can contain various data types ...

0
[Solved!] Excel VBA “Argument Not Optional” Error

Excel VBA (Visual Basic for Applications) is a powerful tool that allows users to automate tasks, create custom functions, and enhance the functionality of ...

0
How to Use Excel VBA Do While Loop with Multiple Conditions

Excel VBA provides a robust set of tools for automating tasks and manipulating data. One essential feature is the Do While loop, which allows you to execute ...

0
How to Define VBA Global Array in Excel (2 Easy Ways)

In this article, we will explore the process of defining a global array in Excel VBA. We'll discuss the concept of module-level variables, their scope, and how ...

0
How to Use Excel VBA Text to Columns Date Format (2 Examples)

The article includes detailed step-by-step instructions on how to create a VBA macro that automates the Text to Columns process and converts text dates into ...

0
How to Sum If Cell Contains Number and Text in Excel

The following dataset contains sales records of the Continental Group for January. It includes information such as the date of the sale, the name and contact ...

0
Excel INDIRECT Function with Named Range (2 Ideal Examples)

The article provides an in-depth explanation of how to use the INDIRECT function with Named Range in Microsoft Excel. The INDIRECT function accepts a string ...

0
Automatic Ways to Scale an Excel Chart Axis – 2 Methods

Here is the overview of our dataset. Introduction to Chart Axis Scale in Excel Charts typically have two axes that are used to measure and ...

0
How to Create a Weighted Sales Pipeline in Excel

Having a comprehensive picture of the leads and sales in a sales pipeline may undoubtedly boost conversion and sales rates. However, this may result in having ...

Browsing All Comments By: Mizbahul Abedin
  1. Hello AMAR,

    Thanks for commenting. There is a typing mistake in your formula.

    The formula for exercise 7 which we applied to cell I148 is: =SWITCH(TRUE,D148>=$B$173,$C$173,D148>=$B$172,$C$172,D148>=$B$171,$C$171,D148>=$B$170,$C$170,0%)

    Formula Explanation:

    The condition D148>=$B$173 is checked first by the SWITCH function. If it is true, then it returns the value of cell $C$173. If the first condition is false, the formula checks the next condition D148>=$B$172. If this is true, then it returns the value of cell $C$172.

    This pattern continues for the following conditions and their respective values. If none of the conditions are true, the default value returned is 0%.

    We regret to inform you that we are currently unable to provide the video you requested. As we haven’t made any video on this topic.

    If you have any specific questions or if you need further clarification, feel free to ask!

    Regards,
    Mizbahul Abedin
    Team ExcelDemy

     

  2. Dear KRIS,
    Thanks for your feedback. We are extremely sorry that, we missed multiplying the formula by 2 (method-1). Now we have corrected the formula in the article, please try it now.
    If you still have any queries, please let us know in the comment section or our forum.

    Thanks and regards,
    Md. Mizbahul Abedin
    Excel & VBA Content Developer

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo