ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   commission percentages (https://www.excelbanter.com/excel-worksheet-functions/164184-commission-percentages.html)

mzmalia

commission percentages
 
hi
im working on a project for school
I need the formula to figure out the commission for the following
projected sales amounts
3.25% of $542,413.00
$ 823,912.00
$362,750.00
$622,165.00
$ 750,450.00
Thank You!


Peo Sjoblom

commission percentages
 
Assume you have 3.25% in A1 and the amounts are in B1"B5, format C1 as
currency and put this formula there

=$A$1*B1

copy down to C5


--

Regards,

Peo Sjoblom




"mzmalia" wrote in message
...
hi
im working on a project for school
I need the formula to figure out the commission for the following
projected sales amounts
3.25% of $542,413.00
$ 823,912.00
$362,750.00
$622,165.00
$ 750,450.00
Thank You!





All times are GMT +1. The time now is 02:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com