🐈
» Forums » Freelancers » UpWork Fee Calculations
Page options
eidolonds
Community Member

UpWork Fee Calculations

Hi everybody!

Maybe someone has a formula / function of calculating the commission.
For example, I'm doing an interactive table in a Google document.
Where do I make for my employees their number of hours worked. And I need that I deduce the profit taking into account the entire committee.

 

For example:
If the employee earned $560.
$500 at a rate of 20% and $60 at a rate of 10%.

Thank you all.

ACCEPTED SOLUTION
shetani
Community Member

I assume you mean Sheets? Example if gross amount is in A1:

 

Fees:

=IF(A1>10000,1050+(A1-10000)*0.05,IF(A1>500,100+(A1-500)*0.1,A1*0.2))

 

Or earnings after fees:

=A1-(IF(A1>10000,1050+(A1-10000)*0.05,IF(A1>500,100+(A1-500)*0.1,A1*0.2)))

View solution in original post

7 REPLIES 7
mthornton-cpc
Community Member

Vlad, you could post a job for a freelancer to make you a formula. Smiley Wink

Good idea....but NO Smiley LOL 

only himself, only hardcore)


@Vlad S wrote:

Good idea....but NO Smiley LOL 

only himself, only hardcore)


I gotta ask...hardcore what exactly? Also, I am NOT being sarcastic when I ask...

 

Have you tried searching for help with this forumula online? Sometimes that is a LOT faster then waiting for a POSSIBLE, but unlikely, answer in the forums.

 

 

 

 

 

 

shetani
Community Member

I assume you mean Sheets? Example if gross amount is in A1:

 

Fees:

=IF(A1>10000,1050+(A1-10000)*0.05,IF(A1>500,100+(A1-500)*0.1,A1*0.2))

 

Or earnings after fees:

=A1-(IF(A1>10000,1050+(A1-10000)*0.05,IF(A1>500,100+(A1-500)*0.1,A1*0.2)))

Oh. Thank you so much!

tkwon
Community Member

I created a google sheet for this. Click here

grimesr
Community Member


Thomas K wrote:

I created a google sheet for this. Click here


I would be useful if you had no restrictions on getting access.Robot Frustrated

Latest Articles
Featured Topics
Learning Paths