Make one cell a percentage of another
I have a sales spreadsheet, and I'd like to have one column be items for which there's a 10% commission ("A" items), and another column be for items with a 12.5% commission ("B" items) ... then two more columns that automatically compute those commissions.
So I want to create a formula in a third column ("A" commissions) that says if there's a number in the cell to my left in the "A items" column, multiple it by 10% and enter the result here.
And a formula in another column that says if there's a number in the "B items" column to my left, multiply by 15% and enter that number here.
So it'll look like this, but instead of my entering the commission totals manually, they'll be entered automatically.
Can't figure out how to do that.
MacBook Pro with Retina display, OS X Yosemite (10.10.3)
