calculate desired profit margin depending on the cost.

calculate desired profit margin depending on the cost.

Closed - This job posting has been filled and work has been completed.

Job Description

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.