Excel Formula
- or -
Post a project like this565
€54(approx. $58)
- Posted:
- Proposals: 25
- Remote
- #3694974
- Awarded
Data Consultant (Expert in Excel, VBA/Macros, Google Sheets, Fillable Pdf services, Data Entry)
Zwota
Data Collection | Business Plan Writer | Web Researcher | PowerPoint Presentation Expert
Bay Minette
Logo & Graphic Designer / illustration / PowerPoint / CAD / AI Expert / Web Designer
Rawalpindi
Excel | Google Sheets | Google Apps Script Automation | VBA Macro | Dashboard | Data Analysis
Karachi
553184638794437910101751581572415837082056702681767075186608173634423453650505041591
Description
Experience Level: Entry
I need to create a formula to achieve the following for me:
Column A has about 20k Product SKU Numbers
Column B has the price.
I need in column C the percentage markup price. Here is where the complication comes in. The percentage markup changes depending on the price in Column B.
example
Column B Price - €100 Column C Markup Price (10%) is €110
Column B Price - €200 Column C Markup Price is (20%) is €240
Column B Price - €300 Column C Markup Price is (5%) is €315
You can see we have different markup prices depending on the price in column B.
Is it possible to create a formula for this and it can be applied to all of column C?
Column A has about 20k Product SKU Numbers
Column B has the price.
I need in column C the percentage markup price. Here is where the complication comes in. The percentage markup changes depending on the price in Column B.
example
Column B Price - €100 Column C Markup Price (10%) is €110
Column B Price - €200 Column C Markup Price is (20%) is €240
Column B Price - €300 Column C Markup Price is (5%) is €315
You can see we have different markup prices depending on the price in column B.
Is it possible to create a formula for this and it can be applied to all of column C?
Trevor N.
98% (35)Projects Completed
39
Freelancers worked with
15
Projects awarded
22%
Last project
8 Apr 2024
Ireland
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Trevor,
Can you tell me the deadline for this job?
Regards
Mahmood
1033543
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies