Find Jobs
Hire Freelancers

Excel Pricing Calculation

$30-250 USD

Completed
Posted over 4 years ago

$30-250 USD

Paid on delivery
I need to have the dropdown box in cell K8 point to the corresponding price for the selected value. For example if the value in K8 is 2500 then the price identified in cell Q5 ($1,625.00). Cell K11 should equal whatever number is selected in the dropdown box multiplied by cell K9.
Project ID: 21754702

About the project

9 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

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:
User Avatar
hi sir, i will enter the formulas to lookup the price based on the value entered and will multiply by the required input factor, will do right now, thanks
$30 USD in 1 day
4.9 (351 reviews)
6.5
6.5
9 freelancers are bidding on average $37 USD for this job
User Avatar
Hi, This can be done within couple of minutes. I am available right away to work and can deliver result right away. Thanks
$30 USD in 1 day
4.9 (248 reviews)
6.7
6.7
User Avatar
Greetings! The formula you are looking for is "INDEX($Q$3:$Q$10,MATCH(K8,$O$3:$O$10,10))". This will return the price based on Pricing Breakdown table for the System Licenses Purchased. This is not a $30 effort but since the project budget minimum is $30, the tool does not allow me to quote below $30. Have a Great Weekend! Srinivasan
$30 USD in 1 day
5.0 (189 reviews)
6.8
6.8
User Avatar
Hello there, I am an Excel expert and I will create this corresponding dropdown for you. It will request few script inside then you can use it very easy. Please contact me and I think it can be completed in 30 mins. Thank you.
$30 USD in 1 day
5.0 (163 reviews)
6.0
6.0
User Avatar
Dear Client, I am Expert in Excel. I have 5+ Years of Experience in EXCEL (VBA and MACROS), Web Scrapping (Python, Octoparse, Parsehub,Selenium and Beautifulsoup), Data Entry, Product Listing and Web Research. I will be there during your working hours to provide support whenever you need. Let’s have a quick chat to discuss this project. Looking forward to hear from you soon. Thanks & Regards, Ritika Keshri
$30 USD in 1 day
5.0 (34 reviews)
4.8
4.8
User Avatar
HELLO, I AM INTERESTED IN DECLARING MY CANDIDACY FOR THE EXCEL EXPERT POSITION FOR YOUR PROJECT. I AM EFFICIENT IN MICROSOFT OFFICE TOOLS AND ALSO EXPERIENCE IN SORTING DATA, CATEGORIZING ITEMS, REMOVING DUPLICATES, WORKING WITH FUNCTIONS OR FORMULAS, COMPARING SHEETS FOR UNIQUE DATA ETC. THANK YOU FOR YOUR TIME AND CONSIDERATION. SINCERELY, BHARAT
$30 USD in 1 day
4.7 (22 reviews)
4.6
4.6
User Avatar
Hi, I am interested in this project. 100% quality is my top priority. I am a new freelancer and I've got 5stars reviews. Please send me a message so we can get started. Hope to hear from you soon.
$40 USD in 1 day
5.0 (4 reviews)
2.1
2.1
User Avatar
I think that I can do that because I do that all the morning. so that it will be easy to help you to rearrange your sheet also
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Sacramento, United States
4.9
6
Payment method verified
Member since May 10, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.