Cell value depending on input in a different cell value

[vdaesety]

How do I pull in rebate in column G ( after four quarters)? The Sale quarter is an input that can be changed, rebate recognition should change to after four quarters of sale and should do it automatically based on sale quarter.

 

[Ezguy4u]

If somebody else can come up with a solution fine, but I would like to see input and output or what it is you want to see for the output of your problem. I would like to see what it is you want to see when all the data is entered.

 

[vdaesety]

Output should be $10 rebate in Column G8. Basically rebate is paid after four quarters of a sale. Output example below. Thanks Ezguy4u

 

[Ezguy4u]

vdaesety we have our work cut out for us here. From how we set up our worksheet to what it is we want to accomplish. How and what data is going to be entered. When we enter data what happens. Now if you are planning to use Mr Excel web page it would be beneficial to download that XL2BB program. I am using it to enter the worksheet below. Now this is going to be a slow process. If you have the patience, you will be rewarded in the end. Why is there 10 in G8? Is it because of the D4 cell? Does F4 change if D4 changes? Let's begin the discussion.

24-09-09.xlsx
	C	D	E	F	G	H	I	J
3	Sale Quarter	Revenue	Rebate
4	1Q'24	$100	$10
5
6
7	1Q'24	2Q'24	3Q'24	4Q'24	1Q'25	2Q'25	3Q'25	4Q'25
8	100				10
Data

Cell Formulas
Range	Formula
C8	C8	=IF(C7=C4,D4,0)