In Progress

Excel Formula

I need a formula for "sheet 1 K5" of the attached spreadsheet. What I need is when the user chooses the steel type, girth and bends the formula will pick up the correct wholesale price from the Sheet named "wholesale prices" and apply a user entered discount which is entered into "sheet 1 H5".

The sheet named "Wholesale Prices" contains price grids for the available raw material with girth and bends.

Please note that the formula must work in Excel 2011 for Mac as well as Excel 2010.

Skills: Excel

See more: discount steel, excel spreadsheet formula, excel sheet formula, steel work, excel formula, excel contains, mac excel spreadsheet, pick excel, need formula, formula sheet, price formula, discount prices excel spreadsheet, type excel sheet, excel 2011 mac, price excel spreadsheet work, excel formula spreadsheet, excel 2011, mac excel, excel 2010, material spreadsheet, excel mac, excel spreadsheet wholesale, material excel sheet, formula sheet excel, spreadsheet steel

About the Employer:
( 7 reviews ) Carole Park, Australia

Project ID: #2566692

Awarded to:

rohitpithisaria

Hi... I would like to apply for the job.

$30 AUD in 1 day
(5 Reviews)
3.3

10 freelancers are bidding on average $39 for this job

sonarkaushik

Sir, I can do the project. Refer PMB. with regards

$89 AUD in 3 days
(15 Reviews)
4.9
binaryromel

==========EXCEL EXPERT HERE! PLEASE CHECK PM. ==========

$30 AUD in 0 days
(36 Reviews)
4.9
manishadk

Believe me, this is very easy job for us. Please check PMB for details.

$30 AUD in 1 day
(9 Reviews)
3.6
vikashgadia

we r excel macro expert. ready to deliver the project.

$30 AUD in 0 days
(15 Reviews)
3.6
hemsingh1

Hi, EXCEL expert here ready to start. Thanks.

$60 AUD in 2 days
(0 Reviews)
1.9
assadhassan

I have the requisite competance and experience...

$30 AUD in 1 day
(0 Reviews)
0.0
joserarodrigues

I'm a software developer with 15 years experience in applications development using many technologies (C#, Visual Basic, Office Automation, SQL Server, Access and Crystal Reports). I'm also an excel "fan" so I'm alw More

$30 AUD in 0 days
(0 Reviews)
0.0
seuw1981

Dear Hiring Manager I'm a qualified data entry operator with eight years experience in the government sector, and I'm very interested in your job post involving these skills. I have recently done the project which More

$30 AUD in 2 days
(0 Reviews)
0.0
Microsuccess

Dear Hiring Manager, I have recently worked in Software Developing Team as a Developer and Designer. And I Have other Experience in Web Researching, Data Entry ,Graphic Designing on Photoshop and Gimp . More

$30 AUD in 1 day
(0 Reviews)
0.0