View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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!