From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Explain this crazy formula and test it

Explain this crazy formula and test it - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Explain this crazy formula and test it

“

- [Instructor] We've got this big juicy formula in cell G three. The objective is to get some general sense of what's going on with it. We don't have to be precise and know everything about it, but just say, what is going on with discount A? What's going on with requirements, exclamation point, dollar sign, F, dollar sign, two? What is that? And part of the challenge is to create a relevant dataset to test the formula. And when you create that data set, it might help understand what this formula is doing, all right? So check out the formula, develop the dataset, come back and we'll do it together. Here we go. All right, the regions, exclamation point, requirements, exclamation point, that is telling us we've got sheets named those. All right, so I am going to make a regions page, and a requirements page. Wouldn't doing a count a in the range B six to B 14 and then a sum in C six through C 14 on the regions sheet.…

Contents