Phoenix - Your AI AssistantExcel Formula
- Posted:
- Proposals: 24
- Remote
- #3694974
- Awarded
Lisbon 
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?
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