python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - price

Formula for price breaks in Excel

I am trying to create a calculation table for prices based on QTY and price break tier. I have an IF formula that doesn't seem to be working correctly and could use some help! Below I will post a sc...
test-img

cbutler

excel

price

Votes: 0

Answers: 1

Latest Answer

Try using MATCH and CHOOSE: =CHOOSE(MATCH(H2,{0,25,100,500,1000}),C2,D2,E2,F2,G2)*H2 The MATCH will compare the qty (in H2) to the values in the array ({0,25,100,500,1000}) and return a number (1 to ...
test-img

cybernetic.nomad

Item price factor compared to items in same subgroup

I have a large dataset including items, subgroups of the items and prices. The simplified version looks as follows: Item Subgroup Price 1 A 10 2 A 12 3 B 2 4 B 6 5 B 4 6 C 7 7 C 8 ...
test-img

Bert

python

pandas

price

Votes: 0

Answers: 1

Latest Answer

Use Groupby.transform and round: In [352]: df['relativePrice'] = round(df['Price'] /df.groupby('Subgroup')['Price'].transform('mean'), 2) In [353]: df Out[353]: Item Subgroup Price relativePric...
test-img

Mayank Porwal

Geometric Brownian motion C++

I am trying to devellop a small option pricer using win32 API. To do that I use monte carlo simulation to compute the price of a call option but there is a mistake in my simulation and I don't see whe...
test-img

AlexHhz

c++

call

montecarlo

price

gbm

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs