View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default Working out other people's profit margins with Excel

=Hourly rate *10% etc

So if %s are in B1, C1, & D1 and hourly rate in A2:

=A2*B1 will give 10% markup.

For 10$ an hour = 1$ fee

HTH

"Karl" wrote:

Hi,

I want to work out how much agencies are charging us for temps. I want to
create a spreadsheet into which the user can enter the hourly rate the agency
is charging.

There will be three columns, headed as follows: 10%, 12.5%, 15%.

As you'd expect, the 10% column will tell the user how much markup the
agency is making if 10% of the hourly rate is made up by their fee.

Can anyone tell me how to do this? It feels like it should be simple, but
nothing I try works.

Cheers

Karl