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.

Calculate reimbursements based on a maximum per day

Calculate reimbursements based on a maximum per day - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Calculate reimbursements based on a maximum per day

“

- [Instructor] We just received a spreadsheet for D Leland expenses. Now we have to calculate how much to reimburse. But first, we got to change the view so we can see what's going on. That's the first objective. Second, calculate the reimbursement based on these rules. None of the miscellaneous, like that $105 massage, no! All of the transportation, gas, parking, yes. Reimburse all of that. And then food, we reimburse up to the daily amount that's in cell J2. So for example, if on the 15th of May, this person spent over $55, which is in J2, we only reimburse $55. So if you got that, go ahead, pause the video, get that calculated, and I'll walk you through a solution. Alright, let's get at it. Let's get this view boosted up, I'm going to go down here. I'm okay at 80%. Now I'm going to start my calculation this way. I'm going to go to equals, sum, open parentheses, and then the Transportation column. Enter.…

Contents