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.

What is this formula doing?

What is this formula doing? - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

What is this formula doing?

“

- [Instructor] A lot of times it is extremely helpful to be able to look at a formula and understand what it's doing. That's separate from any business rules or stories that the user might have because they can add confusion. We want to be able to talk directly to Excel and understand a formula and that's what we want to do here. In cell B three, we have this formula, our mission is to just be able to explain what's going on. But first, let's play with it a little bit. What if I changed this three to a 15, then the result turns into OK or if I turn this into a negative 100. Now we've got a number again. So let's look at the formula equals if open parenthesis sum C seven colon J12 greater than equal to 300 comma OK in double quotes comma overview exclamation point B three asterisk overview exclamation point C three closed parenthesis. Now pause the video. Go through the formula. Describe the functions purpose in your own…

Contents