Using multiple conditions to reflect in cell column.

[CameronLegg]

My goal is to build a formula in column G that indicates when a cell, which contains a value, in column F is less than the price in column C. The difficulty I am having is that there are multiple prices in column F and the price in Column C can only be greater in weeks after column F is indicated.

Week	Opening Price	Closing Price	% Change	Entry Price	Exit Prices	2nd Exit
				-3%	5%
1	$ 476.30	$ 466.09	-2.19%​	$ 462	-
2	$ 462.70	$ 464.72	0.43%​	$ 449	-
3	$ 459.74	$ 437.98	-4.97%​	$ 446	-
4	$ 432.03	$ 441.95	2.24%​	$ 419	468
5	$ 441.24	$ 448.70	1.66%​	$ 428	-
6	$ 449.51	$ 440.46	-2.05%​	$ 436	-
7	$ 439.92	$ 434.23	-1.31%​	$ 427	-
8	$ 431.89	$ 437.75	1.34%​	$ 419	-
9	$ 432.03	$ 432.17	0.03%​	$ 419	-
10	$ 431.55	$ 420.07	-2.73%​	$ 419	-
11	$ 420.89	$ 444.52	5.32%​	$ 408	-
12	$ 444.34	$ 452.69	1.84%​	$ 431	-
13	$ 452.06	$ 452.92	0.19%​	$ 438	-
14	$ 453.13	$ 447.57	-1.24%​	$ 440	-
15	$ 444.11	$ 437.79	-1.44%​	$ 431	-
16	$ 436.81	$ 426.04	-2.53%​	$ 424	-
17	$ 423.67	$ 412.00	-2.83%​	$ 411	-
18	$ 412.07	$ 411.34	-0.18%​	$ 400	-
19	$ 405.10	$ 401.72	-0.84%​	$ 393	-
20	$ 399.98	$ 389.63	-2.66%​	$ 388	-
21	$ 392.83	$ 415.26	5.40%​	$ 381	-
22	$ 413.55	$ 410.54	-0.73%​	$ 401	-
23	$ 414.78	$ 389.80	-6.41%​	$ 402	-
24	$ 379.85	$ 365.86	-3.82%​	$ 368	422
25	$ 371.89	$ 390.08	4.66%​	$ 361	387
26	$ 391.05	$ 381.24	-2.57%​	$ 379	-
27	$ 375.88	$ 388.67	3.29%​	$ 365	-
28	$ 385.85	$ 385.13	-0.19%​	$ 374	-
29	$ 388.38	$ 395.09	1.70%​	$ 377	-
30	$ 395.75	$ 411.99	3.94%​	$ 384	-
31	$ 409.15	$ 413.47	1.04%​	$ 397	-
32	$ 415.25	$ 427.10	2.77%​	$ 403	-
33	$ 424.77	$ 422.14	-0.62%​	$ 412	-
34	$ 417.05	$ 405.31	-2.90%​	$ 405	-

 

[Peter_SSs]

Welcome to the MrExcel board!

Can you fill in manually the results that you would expect for that sample data and post it again, preferably with XL2BB this time. Then give any further explanation if possible about how you manually got those results.

 

[James006]

Hi,

If your formula in cell E3 is =B3*(1+$E$2)
What is your formula in cell F3 ?