Latest Posts From Mizbahul Abedin
Microsoft Excel includes a variety of engineering functions that are designed to perform specific calculations commonly used in engineering and scientific ...
Mizbahul Abedin
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 ...
In Microsoft Excel, the COMPLEX function is used to create a complex number given real and imaginary coefficients. The syntax for the COMPLEX function is as ...
Financial Functions in Excel Here's a summary of some of the most commonly used financial functions in Excel, along with examples. 1. PV Function (Present ...
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 ...
In this Excel tutorial, you will learn: - How to redo actions - How to repeat cell values - How to repeat patterns - How to repeat formulas using the Fill ...
In this article, you are going to learn how to create a Stacked Waterfall Chart with multiple series in Excel. We will explore the benefits, best practices, ...
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 ...
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 ...
EOQ, or Economic Order Quantity, is a mathematical model used in inventory management to determine the optimal order quantity for a company to minimize ...
In this article, we are going to show you how you link sheets in Excel with an index. We will apply the HYPERLINK link function, VBA macro, and also use the ...
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 ...
![[Solved!] Excel VBA “Argument Not Optional” Error](https://www.exceldemy.com/wp-content/uploads/2023/07/Excel-VBA-Argument-Not-Optional-Error.png)
Excel VBA (Visual Basic for Applications) is a powerful tool that allows users to automate tasks, create custom functions, and enhance the functionality of ...
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 ...
Looking for ways to use Excel VBA to call private sub from userform? Then, this is the right place for you. In Excel VBA, private subs are typically ...
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
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