00:00Someone recently asked me how can she quickly calculate the total salary right here if the total salary is actually a sum of base salary and the bonus.
00:11And the bonus depends on the position in the company. How would you do that?
00:15Well, first of all, I'm going to introduce a new column called bonus itself and look up for the bonus based on the position.
00:21And this is the formula I'll use. Equal V, look up, open parenthesis, the position itself, comma, this dictionary, a position like this, highlight it.
00:32I'm going to press F4 to make that into a fixed reference, comma, and the column that we're looking for is not one, but the second one here, the bonus itself.
00:41So I'm going to put two here and comma, and I'm going to say exact match by double clicking on false here.
00:47Close parenthesis and hit enter.
00:49Right now, it's showing as fraction. I'm going to convert that into percentage like this.
00:54Now, to calculate the total, we say equal base salary multiply by this, the bonus itself, plus one, close parenthesis.
01:07And that's how you calculate it. And to finish it off, apply to all the rows by double clicking on it like this.
