# Mizbahul Abedin

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.

## Education

B.sc in Textile Engineering and Management, BUTex

## Expertise

Content Writing, Microsoft Office, Adobe Lightroom

## Experience

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

## Summary

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

## Insert Row in Excel After Every Row and for Table: 8 Methods

Method 1 - Using Keyboard Shortcut Select row 7 and then press ALT+I+R. A new row has been inserted into your Excel sheet. You can use another ...

## How to Merge, Find, and Unmerge in Excel: 9 Methods

Method 1 - How to Merge Cells in Excel Using Merge & Center Feature Select the cells from B5 to G5. Go to the Home tab. From the Alignment group, ...

## 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 ...

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

Trace dependents can make it easier to find which cells track data, but can also make the sheet a bit messier. We'll use a simple dataset as an example of how ...

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

In this article, we will demonstrate how to use the Excel IF statement to increment by 1. We will also increment by 1 using the COUNTIF function, and by using ...

## How to Calculate Economic Order Quantity in Excel

What Is Economic Order Quantity? It means the optimum level of order quantity, not higher or lower. Economic Order Quantity (EOQ) is a calculation ...

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

Here's an overview of the VBA code needed to get cell values. How to Get Cell Value as String with Excel VBA: 4 Approaches Method 1 - Get a String ...

## How to Resolve the Excel VBA “Argument Not Optional” Error (4 Solutions)

Why “Argument Not Optional” Error Occurs in Excel VBA This error occurs when you call a procedure or function without providing all the required arguments. In ...

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

The Do While loop in Excel VBA allows code to be executed repeatedly as long as a specified condition remains true. In this article, we will explore how to ...

## How to Define a Global Array in Excel VBA – 2 Methods

This is an overview. What Is a Global Array in Excel? In VBA (Visual Basic for Applications), a global array is an array that is declared at the ...

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

The article demonstrates how to create a VBA macro that automates the Text to Columns process and converts text dates into Excel date format. ...

## 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 ...

## How to Use the Excel INDIRECT Function with Named Range (2 Examples)

Named Ranges are a powerful feature in Excel that allows you to assign a name to a range of cells, making it easier to reference and use that range throughout ...

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

This is an overview.   Method 1 - Using the Format Axis Feature to Change the Chart Axis Scale in Excel Step 1: Creating a Dataset for X and Y ...

## 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