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.