In case we are using nested IF formula & we all know nested IF takes a lot of time in calculating the result. In this article, we will learn how we can avoid using nested IF function.
Question: I have a task assigned by my manager to check / compare the max change in the last four years sales figures.
I tried using IF function along with MAX & MIN functions to get the result but I guess the formula I am using is a bit long & I want to avoid; so if there is any formula that can replace nested IF then it will be a great help for me.
Following is the snapshot of data we have; the numbers may mislead you but these all are in million
Conclusion: In this way, we can avoid using nested IF function & we can opt for other functions.
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at firstname.lastname@example.org
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.