What is the excel formula to calculate different percentages into one column?

All right.Im a salesman along with im seeking to make the spreadsheet to calculate my personal commissions.Im directed at 3 rows.”New Gross” “Used Gross” and “Voucher”.WE make 25% on new cars and trucks and 17% at used vehicles.What formula does someone use from the “voucher” column to help calculate this specific

I experimented with this nevertheless i speculate its not even a appropriate formula haha…

=(H:H*.25)OR(I:I*.17)

(Column H is different cars, column I can be used cars, and column J is actually my payment voucher)

YOU SHOULD HELP!!!!

A) Get into this solution in column J to get the total commissions intended for sales listed in columns THEY WOULD and MY SPOUSE AND I.

=SUM(H:H)*0.25+SUM(I:I)*0.17

B) In case you wanted to get the commission per sale within column J get into this within column J as well as copy along the column.

=IF(AND(H2=””, I2=””), “”, H2*0.25+I2*0.1

Then one can have the entire commissions received maybe within column K
using the formula:

=SUM(H:H)*0.25+SUM(I:I)*0.17

It is as long as you if you need to notice the commissions earned through each sale or just the total dried up commissions

C) Something to take into account.If everyone added your Date Column in addition to only added in the commission for each sale without treatment row, you may create your Pivot Table that will analyse the sales by Month, Season, New or maybe Used.

Try:Number Formula:
=SUM(H1:H100 * 25%) + SUM(I1:I100 * 17%)
typed in by THREE key:Ctrl + Move + Type in!!!