Advanced Excel formula - 02/05/2018 10:35 EDT

$10-30 USD

Completed

Posted

almost 6 years ago

$10-30 USD

Paid on delivery

The project is to adjust an advanced excel formula used in a commission calculator. The requirements of the formula are outlined in the below scenarios: CURRENT FORMULA June billed revenue 100,000 July voided revenue -100,000 A negative threshold carryforward applies at a fixed value 34,999 applies to July which will carryforward to payables in August deducting from commissionable revenue. There is a maximum negative carryforward value already applied in the formula. CHANGES If the banked fee column is equal to or more than 34,999 in the previous month(s) no negative will apply. If the voided revenue is more than 34,999, the fixed negative carryforward will apply. If the voided revenue is less than 34,999, the negative carryforward will equal to that amount, e.g. -15,000.

Project ID: 16863836

About the project

8 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@avidusman

Hi Cooperfitch, I am an expert in excel and have good professional skills in accounts and finance with an experience of more than a decade. I can build the formula needed per you requirement. Lets please discuss in chat and get it completed soon. Regards,

$29 USD in 0 day

4.9

(12 reviews)

3.9

8 freelancers are bidding on average $26 USD for this job

@mdatikurrahman1

Hello, I have some experience with your work. I usually can catch on to a new job fast as long as the instructions are clear. I can use Excel and research on the internet.

$25 USD in 1 day

2.0

(2 reviews)

0.8

@maygawaran16

I have a positive character in duties and tasks. My time management is excellent and I'm organized doing office documents.

$25 USD in 1 day

0.0

(0 reviews)

0.0

@techsolve7

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned "I can do this job and give you an efficient job that will be very acceptable and presentable. I and my team work on web development and mobile apps and I can assure you that you will never be disappointed"

$31 USD in 1 day