Need help figuring out a formula to calculate prices based on 4 conditions

[Legacy 483325]

Hello everyone,
I was working on a personal project on which I need to get a value based off of 3 different conditions on different columns.

This is what currently works:
=IF(C2:C=1,P2:P/220,IF(C2:C=2,P2:P/150,IF(C2:C=3,P2:P/50)))

But I need to add one more condition
"C" is the edition of a card that ranges from 1-3
"P" is the amount of people requesting the card

The divisors are the current rate of the market in which we are using with the outcome being the price of the card. So, a card requested by 2,500 people at a rate of 200 would yield a price of 12.5.

The other 2 conditions I need on this formula is to check if the card is a high, mid, or low print. That would determine the rarity of the card.
High Prints are x>=1000, Mid Prints are x<=999~100, and Low Prints are x<=99

A High Print card (x>=1000) would use the rate of 200 if edition 1, 150 if edition 2, 80 if edition 3.
A Mid Print (x<=999 to 100) would use a rate of 50 if edition 1, 40 if edition 2, 30 if edition 3.

A Low Print (x<=99) would return a result of "LF Offers"


Here is the link to the spreadsheet: https://1drv.ms/x/s!AnGr1abH9vLwmk5MMsCzJQRiyL1Q?e=ZQmOLt
The formulas are on cells AC3 and AD3. However, we can hide every other column other than the Print,Type,Ed., Burn $, WL, Effort, Min, and Max.

The first goal: is to be able to generate a card's price based on the print (Low Print[1-99], Mid Print[100-999], High Print[1000+], edition (1,2,3), and the number of wishlists the card has.

The Print is located in Column B, Edition number on Column C, and Wishlists on Column Q.


The second goal: is to have a minimum recommended price and a maximum recommended price. This will be based on the effort of the card (located Column T). If the card has an effort over 200, increase the card's value by reducing the divisor (current market rate)
(e.g. A high-print Edition 2 card drops with an effort over 200. That card will now be divided by 100 instead of 150 in which the divisor is the current market rate). This will affect both the min and max price of course.

The minimum prices for High and Mid Prints would be:
High Print:
Edition 1: Generate a price of gold based on the "Burn Rate (Column I) +10 gold
Edition 2: Wishlists(WL)/200
Mid Print:
Edition 1: WL/50
Edition 2: WL/40

The maximum prices for High and Mid Print would be:
High Print:
Edition 1: Generate a price of gold based on the Burn Rate (Column I)+20 gold
Edition 2: Wishlists(WL)/200
Mid Print:
Edition 1: WL/20
Edition 2: WL/20

If the effort of the card is 200+, then highlight the cell with the maximum price using condition formatting.

1. 
   If the edition in the D column is 1 then divide the wishlist number in column D by 220.
   If the edition in the D column is 2 then divide the wishlist number in column D by 150
   If the edition in the D column is 3 then generate text: "LF Offers"
   
   I want to include another condition in which it does the above but factor in the effort (Column G) into account. This would mean lowering the divisor for the "Max" Column only, since the min price should always be the lowest available. (e.g. divisor being 200 instead of 220 if edition 1; 130 instead of 150 if edition 2).
   
   I suggested doing this by looking to see whether the data in Column G, "Effort",
   was greater than or equal to 200. If so, then divide by the new different divisor than the standard one.
   
   Reiterating the example above, this would mean dividing the wishlist number by 130 instead of 150 for edition 2 cards and 200 instead of 220 for edition 1 cards with the purpose of adding even more value to the card if the effort was 200+
   
   
2. IF(@D2:D303=1,@F2:F303/220,IF(@D2:D303=2,@F2:F303/150,IF(@D2:D303=3,@F2:F303/50)))
   
   Rough formula above was to find the card's price but it's a roundabout way of doing so. I also gave a rate of 50 to the edition 3 cards which at the moment, is not wise to do as they are new cards and their value has not been cemented into the current market so I suggested to generate a text advising to look for offers instead.
   

 

[Legacy 483325]

Formula Calculations.xlsx
	A	B	C	D	E	F	G	H	I
1	Code	Print	Type	Ed.	Burn $	WL	Effort	Min	Max
2	npkfv2	344		3	400	3014	349	60	151
3	jxfbxl	7708		2	395	7237	200	48	90
4	5gtcb2	4922		2	390	6356	179	42	79
5	nz9x0d	427		3	393	1573	166	31	79
6	k821vg	4514		2	388	5444	333	36	68
7	jkttbm	6159		2	395	4928	229	33	62
8	npw2n0	222		3	376	818	310	16	41
9	k8mqg4	1403		1	344	6699	208	30	33
10	k7k6m9	3927		2	47	2271	28	15	28
11	jcxzn2	1729		1	157	5347	85	24	27
12	n2ldnw	7754		2	48	2135	25	14	27
13	54c8st	4773		2	195	2072	118	14	26
14	j42stx	7611		2	95	2043	51	14	26
15	5q2q6l	4028		2	95	1544	55	10	19
16	n2fb0b	11169		1	22	3792	14	17	19
17	59hpwx	4944		2	95	1407	58	9	18
18	jsjf32	22		3	193	342	130	7	17
19	52cb39	4085		2	93	1100	55	7	14
20	k5sh6v	9201		1	380	2650	178	12	13
21	nz87zm	7461		2	94	1019	51	7	13
22	n27sjx	6873		2	47	942	25	6	12
23	5p079j	9896		1	88	2271	49	10	11
24	jr92dl	6773		2	383	869	205	6	11
25	jn9rbb	6950		2	382	823	220	5	10
26	5csrfg	5291		2	383	818	334	5	10
27	5ckzrc	4870		2	376	770	323	5	10
28	k5435j	3558		2	379	762	330	5	10
29	np3r1q	446		3	370	189	180	4	9
30	5p5p95	8219		1	91	1715	51	8	9
31	5cmxwm	5241		2	381	679	228	5	8
32	n48bc8	368		3	187	159	96	3	8
33	jw8t5w	6624		2	94	629	54	4	8
34	57d5bx	4922		2	186	544	100	4	7
35	js6x9g	7633		2	189	532	105	4	7
36	j2334q	6085		2	189	528	96	4	7
37	5qcbwp	4514		2	367	517	226	3	6
38	5l4m83	4560		2	178	511	111	3	6
39	5zrtcb	5145		2	95	497	55	3	6
40	nw4bdw	11518		1	148	1197	81	5	6
41	5n50b5	4973		2	180	476	106	3	6
42	kprr2z	9208		1	172	1176	91	5	6
43	k74zck	3696		2	44	465	28	3	6
44	5kgl2b	4995		2	191	456	119	3	6
45	2qxs11	1495		2	363	450	321	3	6
46	jtz0f2	531		2	381	429	221	3	5
47	nkmrxd	199		3	342	104	200	2	5
48	j4x6xb	6679		2	344	415	195	3	5
49	n03kgb	7918		2	91	392	51	3	5
50	5k0q99	5059		2	85	386	50	3	5
51	555wnc	4997		2	361	368	198	2	5
52	5kn1xn	4290		2	366	353	301	2	4
53	j63h10	7761		2	91	341	51	2	4
54	jdqztw	6709		2	182	334	105	2	4
55	n3ptmb	7797		2	162	333	79	2	4
56	j8kh3r	7047		2	95	312	53	2	4
57	k99m4j	3784		2	47	312	26	2	4
58	5nccrz	9971		1	42	770	25	4	4
59	jc7trw	7714		2	89	304	49	2	4
60	5zlgmd	4859		2	363	304	223	2	4
61	k821k0	4405		2	94	298	58	2	4
62	nj1zdf	7273		2	89	283	48	2	4
63	5sr9xj	4725		2	44	283	26	2	4
64	nrdbch	8445		2	47	269	25	2	3
65	n4mh3v	163		3	22	65	15	1	3
66	wszlmk	2766		2	350	260	279	2	3
67	np1sdn	8041		2	94	251	51	2	3
68	5f2406	5309		2	359	236	290	2	3
69	5v5f1k	4946		2	169	233	103	2	3
70	nj74d3	4945		2	19	218	13	1	3
71	56zhj7	5096		2	21	215	14	1	3
72	kgw8tg	4424		2	84	203	46	1	3
73	k8t517	4151		2	347	198	206	1	2
74	j3bdr5	7215		2	138	196	80	1	2
75	jz76nx	3984		2	20	196	13	1	2
76	bmv3mp	5802		2	43	196	23	1	2
77	5tjh13	3154		2	87	191	54	1	2
78	jxzpdc	10660		1	130	444	75	2	2
79	j3hvzr	4280		2	322	168	176	1	2
80	j45n5m	1333		2	85	167	51	1	2
81	np1stl	247		3	92	40	54	1	2
82	nzhhcn	176		3	189	39	116	1	2
83	nkrmd3	5150		2	154	156	88	1	2
84	5ph8f3	4743		2	83	149	50	1	2
85	jsjf3h	11433		1	171	354	95	2	2
86	nk9hgk	7900		2	79	141	44	1	2
87	kcfc9n	9499		1	86	352	48	2	2
88	j13q03	6893		2	18	133	13	1	2
89	bprs94	3896		2	166	129	101	1	2
90	nzxvmj	8501		2	79	128	44	1	2
91	jcs2r2	185		3	90	32	60	1	2
92	5b8ps5	4776		2	42	126	26	1	2
93	b57394	985		2	283	122	234	1	2
94	jx51dc	7743		2	81	121	45	1	2
95	513lfz	4892		2	306	120	156	1	2
96	jp6mlx	6834		2	147	118	84	1	1
97	nqr6dd	7134		2	39	116	23	1	1
98	nvq81h	3584		2	82	116	48	1	1
99	jdxprf	7607		2	299	116	170	1	1
100	nkrmxq	10952		1	161	288	88	1	1
101	b6smsz	6804		2	72	115	43	1	1
Sheet1

Cell Formulas
Range	Formula
H2:H101	H2	=IF(D2:D303=1,F2:F303/220,IF(D2:D303=2,F2:F303/150,IF(D2:D303=3,F2:F303/50)))
I2	I2	=IF(D2:D303=1,F2:F303/200,IF(D2:D303=2,F2:F303/100,IF(D2:D303=3,F2:F303/20)))
I3:I101	I3	=IF(D3:D303=1,F3:F303/200,IF(D3:D303=2,F3:F303/80,IF(D3:D303=3,F3:F303/20)))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:B303	Cell Value	>999	text	NO
B2:B303	Cell Value	between 999 and 100	text	NO
B2:B303	Cell Value	<100	text	NO
F2:F303	Cell Value	>=3000	text	NO
F2:F303	Cell Value	between 2999 and 2000	text	NO
F2:F303	Cell Value	between 1999 and 1000	text	NO
F2:F303	Cell Value	<1000	text	NO
G2:G303	Cell Value	between 350 and 500	text	NO
G2:G303	Cell Value	between 349 and 200	text	NO
G2:G303	Cell Value	<200	text	NO
H2:K303	Cell Value	between 5 and 1	text	NO
H2:K303	Cell Value	between 6 and 10	text	NO
H2:K303	Cell Value	between 11 and 15	text	NO
H2:K303	Cell Value	between 16 and 20	text	NO
H1:K303	Cell Value	>20	text	NO