Formula for calculation based on rang

[Tripleseas]

Hello community

i'm working on worbook and i need to do some calculation like this :

depending on the price in the 3 differents rang ( Cell B3 to Cell D28 ) in comparisson the rang table , if that rang is detected i want the price in the base table to be multiplied by numbers of days in that month

I did some manual examples :
Cell D3 = 60 000 ---> it's in the rang 50 001 - 180 000 ----> result : 250 ( the price of the rang ) * 31 ( numbers of days of january )

i also seperated the rangs ! i want to the calculations of the months of rang 3 to be done based on column rang 3 and so on for the others.

hope i was clear and thank you for the help.

price formulas.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Rang	Price
2	0-5 000	20,83
3	5 001 -50 000	83,33
4	50 001 -180 000	250,00
5					RANG 3						Rang 1			RANG 2
6	Gare de péage	Rang 1	Rang 2	Rang 3	Janvier	Février	Mars	Avril	Mai	Juin	Juillet	Août	Septembre	Octobre	Novembre	Décembre
7	X1	120 000	72 000	60 000	7750
8	X2	80 000	48 000	40 000
9	X3	40 000	24 000	20 000
10	X4	100 000	60 000	50 000
11	X5	20 000	12 000	10 000
12	X6	100 000	60 000	50 000
13	X7	10 000	6 000	5 000	645,73
14	X8	70 000	42 000	35 000
15	X9	20 000	12 000	10 000
16	X10	30 000	18 000	15 000
17	X11	5 000	3 000	2 500
18	X12	5 000	3 000	2 500
19	X13	5 000	3 000	2 500
20	X14	5 000	3 000	2 500
21	X15	180 000	108 000	90 000
22	X16	10 000	6 000	5 000
23	X17	5 000	3 000	2 500
24	X18	5 000	3 000	2 500
25	X19	15 000	9 000	7 500
26	X20	5 000	3 000	2 500
27	X21	5 000	3 000	2 500
28	X22	5 000	3 000	2 500
29	X23	5 000	3 000	2 500
30	X24	50 000	30 000	25 000
31	X25	45 000	27 000	22 500
32	X26	8 000	4 800	4 000
Feuil1

Cell Formulas
Range	Formula
B3	B3	=100/1.2
E7	E7	=250*31
E13	E13	=20.83*31

 

[Joe4]

Duplicate to: complicated calculation of price formula

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.