Create two excel formulas

$30-250 USD

Completed

Posted

over 10 years ago

$30-250 USD

Paid on delivery

Formula # 1: Sheet (A) in column D has a person's initials and the sales price in column H associated with that person. I need a formula where I can type the person's initials on (Sheet (B) cell A2) and the formula finds each price on Sheet (A) associated with those initials and displays that person's price in their column on Sheet (B). Formula # 2: With Formula # 1 completed, type in cell A2 initial's "PP". Different price amounts in (Column A) should appear. Each price amount is in a price range category in (Column D). Next to each Price Range is a Cogs Rate (Column E). Create a formula that finds the correct Price Range (Column D) and multiples each Price (Column A) by the correct Cogs Rate (Column E) and displays each amount in the Cogs Expense (Column B) Thank you for your help! Jessica

Excel

Project ID: 4822979

About the project

56 proposals

Remote project

Active 11 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:

@koolsidz

Your project is ready :)

$66 USD in 0 day

4.9

(149 reviews)

6.5

56 freelancers are bidding on average $53 USD for this job

@jeweljitu

Kindly Please check my comments, past feedback in the following message board, we look forward to your response.

$147 USD in 3 days

4.9

(904 reviews)

8.7

@jaylancer43

Excel VBA Expert. Please check PM for details. Thanks.

$35 USD in 3 days

5.0

(802 reviews)

8.8

@deepbluetech

Hi, I can take on the job. Please confirm.

$35 USD in 1 day

5.0

(173 reviews)

7.4

@priyal1997

ITS DONE ;-)). Please check PM. Thanks - Priyal

$30 USD in 1 day

5.0

(188 reviews)

6.8

@maverick44000

Hi there. My proficiency in Excel would not take more than an hour to get this done. Lets begin. Regards

$66 USD in 0 day

5.0

(70 reviews)

6.8

@sswijaya

Hi, let me help you to build your formula.

$30 USD in 1 day

5.0

(58 reviews)

6.4

@shikhamehta

Hello Jessica, I can create the custom formulas as required. However, I have a few queries. Please check the private message for my suggestions on how to go about it. Thanks and Regards, Shikha

$45 USD in 2 days

4.8

(96 reviews)

6.4

@binaryromel

##### Excel expert here! Please check PM. #####

$35 USD in 1 day

4.8

(109 reviews)

6.2

@SiroosJafary

Hi, it is done; please plese check your inbox for the file. Regards.

$30 USD in 0 day

5.0

(69 reviews)

6.0

@pkcyber

I will give u an application where u can select the excel files and click on output button , you will get the required output excel file. You can use this application any time

$50 USD in 1 day

4.9

(31 reviews)

5.7

@nagybatonyi

Such jobs are my daily practice. Please, see PMB for a sample file! Regards

$55 USD in 0 day

4.9

(64 reviews)

5.7

@sonarkaushik

Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards

$69 USD in 3 days

4.6

(43 reviews)

5.6

@aerobace

Hello, please check PM for the file.

$35 USD in 1 day

4.8

(8 reviews)

5.5

@FIBIN

Hi, I am interested to work for your project . I am an expert in excel and VBA Programming in Excel. I have experience working on lot of Excel based projects. I will make sure that I deliver you the best with 100% accuracy in minimum time . Pay me only if you are 100% satisfied with my work, after project delivery. Please see my private message(PM) for more details. Regards Fibin

$30 USD in 1 day

4.9

(50 reviews)

5.4

@buyaspreadsheet

Why pick me? Simply because it is done. See PM. Best regards, Andrew

$60 USD in 1 day

5.0

(14 reviews)

4.6

@hemi

I did it. Please see more details on private message. Thanks

$30 USD in 0 day

5.0

(27 reviews)

4.5

@tamrakar81

Expert here I can start today .. Please ref: https://www.freelancer.com/users/feedback_931653.html for my quality and client satisfactory work .

$33 USD in 1 day

5.0

(15 reviews)

4.4

@samin59

You think about quality, we deliver it. Please check PM.

$60 USD in 3 days

5.0

(10 reviews)

4.2

@farr4u

Hi, ITS DONE, values are coming great, with easily selectable values functionality, see pm for DEMO. Regards.

$30 USD in 0 day

4.9

(27 reviews)

4.2

@Midlander

Jessica, sending you sample Excel 2010 file that does exactly what you want, Happy to provide full file under a Confidentiality and Non-Disclosure Agreement, and you can have it as soon as you pay the Milestone into the site. More details on Private Message Board Bob Allen-Turl

$62 USD in 0 day