From the course: Excel Power User Challenge

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Reimbursement limit

Reimbursement limit - Microsoft Excel Tutorial

From the course: Excel Power User Challenge

Start my 1-month free trial Buy for my team

Reimbursement limit

“

- [Instructor] Erica has compiled her reimbursement request. We've got the dates, the location, categories, and the amounts. And if we go here, we can see the total being requested is $776.53. Ah, but Erica knows that there is a daily restriction of up to $65 per day for food, and the money cannot be rolled over to another day. Meaning if you only spend $40 one day, the next day, you still only have $65, not 65 plus 25 from the previous day. Let's click away from this. Now, Erica wants to know how much of this is coming out of her own pocket, because it will not be reimbursed. Hopefully it's not a lot, but that's what you have to figure out now. How much is coming out of Erica's own pocket because of this agreement? All right, pause the video and get that number for Erica. (upbeat music) Let's figure this out. My curser's in a data set. I am going to get some room here, highlight there, and insert a row…

Contents