calculate desired profit margin depending on the cost.

Closed - This job posting has been filled and work has been completed.
Web, Mobile & Software Dev Desktop Software Development Posted 1 year ago

Fixed Price

Delivery by October 14, 2013

$15.00

Budget

Details

I need to develope a macro for an Excel sheet to calculate desired profit margin depending on our cost. Here's the scenario.

A1: landing cost in USD.

If 0 < A1 <= 2, then multiply 200% to A1 and write the target profit margin on B1
If 3 <= A1 <= 5, then multiply 150% to A1 and write the target profit margin on B1
If 6 <= A1 <= 10, then multiply 75% to A1 and write the target profit margin on B1
.....

So, it's a CASE scenario that determins the target profit margin depending on the cost group. I have 500 items to apply this function on each row in Excel sheet, so this function should be able to be copied to other cells like formulars.

I want someone who is very familiar with Excel VBA and available NOW so that he/she can finish this job by tomorrow morning in CA, USA time. Upon contract, the actual work file will be given.


About the Client

(5.00) 3 reviews

United States
Buena Park 03:56 AM

7 Jobs Posted
58% Hire Rate, 1 Open Job

$180 Total Spent
4 Hires, 0 Active

$5.56/hr Avg Hourly Rate Paid
37 Hours

Member Since Jan 12, 2012