All articles with 'Nested If' Tag
A clever technique to simplify your long, nested IF formulas
![A clever technique to simplify your long, nested IF formulas](https://chandoo.org/wp/wp-content/uploads/2023/04/SNAG-2570.png)
Recently I used an elegant and smart technique to simplify lengthy nested IF formulas and made them 80% shorter. In this article, let me explain the process and share the results.
Continue »CHOOSE() me, an introduction to Excel CHOOSE function
![CHOOSE() me, an introduction to Excel CHOOSE function](https://img.chandoo.org/f/choose-formula-demo.png)
Today lets learn about Excel CHOOSE() function.
CHOOSE eh? What does it do?
To understand CHOOSE() and appreciate its uses, lets invent an imaginary boos-subordinate pair.
Jasmine is the boss. She is, well, lets call her peculiar. She likes olives, Tuesdays & color Red. She hates potatoes.
Martin is the faithful butler of Jasmine. He is obedient, quirky and tall. He likes lotuses, Fridays & color blue. He hates potassium.
Enter Jasmine’s scarf problem:
Jasmine likes to wear a different colored scarf every weekday. She likes to wear Red colored scarf on Mondays & Tuesdays. She likes to put on the blue polka dot scarf on Wednesdays. On Thursdays, she wears her olive colored scarf. On Fridays & Saturdays, she prefers the lovely orange blue scarf. Sundays are no scarf days.
No wonder she is peculiar.
Continue »;
Today we look at a very neat way of doing a complex Nested If or Vlookup style problem with a simple but beautiful Sumproduct based formula.