From the course: Excel: Advanced Formulas and Functions

Unlock this course with a free trial

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

Use ALT+ENTER to make formulas more readable

Use ALT+ENTER to make formulas more readable - Microsoft Excel Tutorial

From the course: Excel: Advanced Formulas and Functions

Start my 1-month free trial Buy for my team

Use ALT+ENTER to make formulas more readable

“

- [Instructor] Here's something that you can do to bring some ease and calm around complex formulas. Now let's look at this data. There's the compensation agreement. Pay hours at a given rate, up to 40 hours. The rate is in I1, that's $45 and 70 cents. Time over 40 hours is paid at 1.5 times the rate. Got it. And if a person worked at least 35 hours at Central or West locations, then pay the Add rate. Let's look at Friendly. Friendly worked 51.5 hours at Central, so that means Friendly should get the Add rate of $115. Friendly should be paid 40 hours times $45 and 70 cents, and an additional 11.5 hours at time and a half. Okay. And we have the pay column with everything calculated. Let's go here. We've got a lot of @ symbols, if statement, XLOOKUP, dollar signs, plus signs, a lot of stuff is going on in this formula. I'm going to peel it down. Okay, the first part up to this plus sign, let's see if hours greater than…

Contents