Would like to setup a formula for the following excel file.
If columns E+F is between 0-9.99, column I should be [(E+F)*4 ]+ (H*175).... (Assuming H is 1. If H is greater than 1, the second half should be (1*175) + ((H-1)*150).
Also want to include the following in the same formula...
If columns E+F is as below, it should be multiplied as stated below
$10-$19.99: 3x
$20-$49.99: 2.5x
$50-$99.99: 2x
$100-199.99: 1.8x
$200+: 1.75x
Basically, column I should incorporate all the above scenarios in a single formula based on columns E, F and H
Hi,
I have read the description about developing formula.
I have 9 years of experience.
I an excel expert.
I can solve any query of excel.
I am an expert at VBA, MACROS, FORMULAS
100 % SATISFACTION AND ACCURATE RESULTS WITHIN FEW HOURS.
THANKS
$25 USD en 0 día
5,0 (2 comentarios)
1,6
1,6
12 freelancers están ofertando un promedio de $25 USD por este trabajo
Hi,
I have gone through your project details and can help you in completing excel formula you need as mentioned. Being experienced in working on excel/formula/macro extensively, I assure you of quick and efficient results.
Waiting for your response for more discussion. Thanks.
Hi I have 10+ years of experience in Advance Excel, MS Access Development, VBA, Macros and other office integration development. I am sure i can handle your request
Dear Sir
I am an excel professional having hands on expertise in data analysis and management I will do your project as per your requirements by applying advanced excel formulas.