From the course: Excel Weekly Challenge

Unlock this course with a free trial

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

What's the revenue based on revenue share?

What's the revenue based on revenue share? - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

What's the revenue based on revenue share?

“

Product line L, RA and then 0.35. Want to slide that down here and then 0.35, and I'm going to put that as keep. Turn this into a table. Let's have a little fun, make this this garish purple. Now our revenue equals I'm going to use XLOOKUP, double click there. Look up what? Look up the product line, comma, look it up where? Right here, comma, return what? That value, comma, if not found then put a one and enter. But that is not currency, this is just numbers. Good. Insert a column. Put this as hours equals total times the one, enter. Next, equals the sum, open parentheses, of this column, and enter. $4,735.84 in total was generated, and we kept $2,981.43.

Contents