From the course: Excel: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

Use Alt+Enter to make formulas more readable

Use Alt+Enter to make formulas more readable

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.70. 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.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 at symbols, if statement, X look up, 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 40, and…

Contents