Latest Posts From Mizbahul Abedin
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 ...
Mizbahul Abedin
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 ...
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 ...
For various Excel objectives, we occasionally change the names of cells and ranges to suit our needs. Finding and navigating to a specific named range might be ...
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 ...
This is an overview: Introduction to the Fibonacci Sequence The Fibonacci sequence is a set of integers starting with 0 and 1. The next number in ...
This is an overview. The INDEX and the MATCH Functions in Excel The INDEX function returns a value or a reference to a value from a ...
See Our Reviews at
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