Create two excel formulas

$30-250 USD

Terminado

Publicado

hace más de 10 años

$30-250 USD

Pagado a la entrega

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

ID del proyecto: 4822979

Información sobre el proyecto

56 propuestas

Proyecto remoto

Activo hace 11 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

Adjudicado a:

@koolsidz

Your project is ready :)

$66 USD en 0 día

4,9

(149 comentarios)

6,5

56 freelancers están ofertando un promedio de $53 USD por este trabajo

@jeweljitu

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

$147 USD en 3 días

4,9

(904 comentarios)

8,7

@jaylancer43

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

$35 USD en 3 días

5,0

(802 comentarios)

8,8

@deepbluetech

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

$35 USD en 1 día

5,0

(173 comentarios)

7,4

@priyal1997

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

$30 USD en 1 día

5,0

(188 comentarios)

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 en 0 día

5,0

(70 comentarios)

6,8

@sswijaya

Hi, let me help you to build your formula.

$30 USD en 1 día

5,0

(58 comentarios)

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 en 2 días

4,8

(96 comentarios)

6,4

@binaryromel

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

$35 USD en 1 día

4,8

(109 comentarios)

6,2

@SiroosJafary

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

$30 USD en 0 día

5,0

(69 comentarios)

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 en 1 día

4,9

(31 comentarios)

5,7

@nagybatonyi

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

$55 USD en 0 día

4,9

(64 comentarios)

5,7

@sonarkaushik

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

$69 USD en 3 días

4,6

(43 comentarios)

5,6

@aerobace

Hello, please check PM for the file.

$35 USD en 1 día

4,8

(8 comentarios)

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 en 1 día

4,9

(50 comentarios)

5,4

@buyaspreadsheet

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

$60 USD en 1 día

5,0

(14 comentarios)

4,6

@hemi

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

$30 USD en 0 día

5,0

(27 comentarios)

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 en 1 día

5,0

(15 comentarios)

4,4

@samin59

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

$60 USD en 3 días

5,0

(10 comentarios)

4,2

@farr4u

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

$30 USD en 0 día

4,9

(27 comentarios)

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 en 0 día